Excel Power Query Data Cleansing Part 2 Clean Extract Data Using Formulas Analytical Tools

In this 2nd of a 3 part training series on Excel Power Query & Data Cleansing you will learn the different ways to clean and extract data using Excel formulas and Excel’s built in analytical tools.

This training is for beginners & intermediate Excel users and can be applied to Microsoft Excel 2003, 2007, 2010, 2013 & 2016 versions.

Download the Excel workbooks used in this tutorial to practice:
http://myexcelonline.com/blog/wp-content/uploads/2016/09/Data-Cleansing-Training-Video-2-Workbooks.zip
You will learn the following topics:

Intro from John Michaloudis
03:55 – Proper Function
05:00 – Trim Function
08:55 – Text Function
13:30 – Left Function
15:05 – Right Function
17:00 – Substitute Function
18:55 – Replace Function
20:45 – Convert Text to Numbers – TIP!!!
22:50 – Number Formats
24:00 – Find Blank Cells With Color
25:35 – Remove Duplicates
27:30 – Text to Column – Split Names
28:30 – Flash Fill

View the rest of this training series here:

VIDEO 1: Different Ways to Format Data Using Power Query

VIDEO 3: Consolidate Workbooks & Worksheets using Power Query

WATCH OUR FREE WEBINAR ON POWER QUERY & DATA CLEANSING NOW: http://www.myexcelonline.com/107-21.html

Please share, like & leave your comments below.

Thank You,

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My blog: http://datascopic.net/blog-2-2