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.

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

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.

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

Secure Socket Layer (SSL)

What is SSL and why it is Required

How Secure Socket Layer Works 

Mircosoft Excel : Shortcuts You Probably Don't Know

Mircosoft Excel : Shortcuts

This Video shows time-saving shortcuts to make your 

spreadsheet workflow faster and easier.

Microsoft Excel : How to Use Pivot Tables

How to Analyze Data with Pivot Tables in Excel 

One of the most useful tools in Excel is often the least used. Pivot Tables allow you to quickly manipulate data to draw meaningful analysis. This tutorial walks you through a simple slicing and dicing of the interim results by using Pivot Table