Data Warehouse
Wednesday, January 7, 2015
Tuesday, January 6, 2015
How to Compare Two Email Lists in Excel?
Compare Two Email Lists. Is Email in List? Is email NOT in List? Compare 2 E-mail Lists. Is E-mail in List? Is e-mail NOT in List?
See how to compare two e-mail lists where one list has extra semi-colons:
1. (00:28 min) Find and Replace feature to remove semi-colons (Ctrl + H).
2. (01:32 min) Is in List: MATCH and ISNUMBER functions.
3. (03:20 min) Is NOT in List: MATCH and ISNA functions.
See how to compare two e-mail lists where one list has extra semi-colons:
1. (00:28 min) Find and Replace feature to remove semi-colons (Ctrl + H).
2. (01:32 min) Is in List: MATCH and ISNUMBER functions.
3. (03:20 min) Is NOT in List: MATCH and ISNA functions.
Excel 2013: Power Query: Merge Tables Into One in PowerPivot or Excel Table
See how to import three tables from three different source files (Access database, Excel File, Text File) and merge them into one table using Power Query. Merge tables into the PowerPivot Data Model or an Excel Table
1. (01:38 minute mark) Import Access File. Remove column, Format Data Type as Date
2. (02:33 minute mark) Import Excel File
3. (03:05 minute mark) Import Text File
4. (03:28 minute mark) Append Table: merge Three Tables
5. (04:12 minute mark) Load to Data Model or Excel Table
1. (01:38 minute mark) Import Access File. Remove column, Format Data Type as Date
2. (02:33 minute mark) Import Excel File
3. (03:05 minute mark) Import Text File
4. (03:28 minute mark) Append Table: merge Three Tables
5. (04:12 minute mark) Load to Data Model or Excel Table
Microsoft Excel :Compare 2 Lists and Extract Record
See how to Compare Two Lists and Extract Records with Excel Advanced Filter:
1. Extract items in list 2 that are NOT in List 1 using Advanced Filter and Logical Formula in Criteria Area with ISNA and MATCH functions.
2. Extract items that are in both list using Advanced Filter and Logical Formula in Criteria Area with ISNUMBER and MATCH functions.
1. Extract items in list 2 that are NOT in List 1 using Advanced Filter and Logical Formula in Criteria Area with ISNA and MATCH functions.
2. Extract items that are in both list using Advanced Filter and Logical Formula in Criteria Area with ISNUMBER and MATCH functions.
Friday, January 2, 2015
Microsoft Excel: Top 10 Favourite Excel Tips
Learn some amazing Excel tips! These tips are the most time-saving, productivity enhancing tips that I've learned over the 25 years that I've been training. Enjoy!
Insert System Date - 1:01
Autofill techniques - 2:20
Custom date & number formatting - 1:50
Custom lists - 4:20
Quick-filling cell ranges - 5:00
2-Dimensional Sums - 6:15
Duplicating sheets - 7:50
Editing multiple sheets simultaneously - 9:10
Creating a quick chart - 11:46
Viewing sheets side-by-side - 12:20
Autofill techniques - 2:20
Custom date & number formatting - 1:50
Custom lists - 4:20
Quick-filling cell ranges - 5:00
2-Dimensional Sums - 6:15
Duplicating sheets - 7:50
Editing multiple sheets simultaneously - 9:10
Creating a quick chart - 11:46
Viewing sheets side-by-side - 12:20
Thursday, January 1, 2015
Subscribe to:
Posts (Atom)