Excel Macro Tutorial: February 2015

Thursday 26 February 2015

Remove duplicates excel 2010

Title:
Remove duplicates excel 2010

Published:
21/Feb/2013

Video:

Description:http://www.msofficeinfo.com/removing-duplicates-from-excel-2010-list/ Removing duplicates from your excel list doesn't have to be difficult. Use this short v...

Find Duplicates in Excel 2010 & 2013

Title:
Find Duplicates in Excel 2010 & 2013

Published:
07/Nov/2012

Video:

Description:Please Change Video Quality. Excel's conditional formatting feature is an easy way to add special formatting features to specific areas of your spreadsheets....

Monday 9 February 2015

MS Excel Result Sheet

Title:
MS Excel Result Sheet

Published:
08/Feb/2015

Video:

Description:MS Excel Result Sheet in Bangli or Hindi.

Excel 2013 Video 38 The XOR Function the Easy Way

Title:
Excel 2013 Video 38 The XOR Function the Easy Way

Published:
08/Feb/2015

Video:

Description:Learn how the XOR function behave and some other funny things ! - PHD in Economy ; - Certifyed Public Accountant ; - Auditor ; - 2 Years Master Degree in Tax ...

Thursday 5 February 2015

Excel VBA UserForm ListBox with Multiple Columns Populate (Column Property)

Title:
Excel VBA UserForm ListBox with Multiple Columns Populate (Column Property)

Published:
16/Jan/2015

Video:

Description:Excel VBA UserForm Learn how to populate ListBox with multiple columns (Column Property) The source code used in this video: Private Sub ...

Automate Email Extraction from Website Using Excel VBA

Title:
Automate Email Extraction from Website Using Excel VBA

Published:
07/Jan/2015

Video:

Description:How to extract email addresses from a website automatically using Excel VBA. Sample file and details available here: http://www.exceltrainingvideos.com/autom.

US and European, International Date Format conversions with Excel VBA - Hot Tip!

Title:
US and European, International Date Format conversions with Excel VBA - Hot Tip!

Published:
12/Jan/2015

Video:

Description:www.ExcelVbaIsFun.com** A lot of people tell me how dates make them crazy in Excel, especially when dealing with international date formats. Here's a littl...

Learn Excel - Ugly Web Data into Excel with Power Query - Podcast 1947

Title:
Learn Excel - Ugly Web Data into Excel with Power Query - Podcast 1947

Published:
05/Feb/2015

Video:

Description:After trying to scrape some data from a web table into Excel, some modern web trickery is causing the data to copy to the clipboard in a way that all the data ...