Pinterest Pixel

Data Cleansing Training – Clean & Extract Data Using Formulas & Excel’s Analytical Tools

  VIDEO #2: Clean & Extract Data Using Formulas & Excel’s Analytical Tools       In this... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Data Cleansing Training - Clean & Extract Data Using Formulas & Excel's Analytical Tools | MyExcelOnline Data Cleansing Training - Clean & Extract Data Using Formulas & Excel's Analytical Tools | MyExcelOnline

Video #3:

Coming Soon

Data Cleansing Training - Different Ways to Format Data Using Power Query

 


VIDEO #2:

Clean & Extract Data Using Formulas & Excel’s Analytical Tools

 

 

 

In this training you are going to learn the following:
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
 

See also  Cheat Sheet Download Link

download the excel workbooks used in this video Data-Cleansing-Training-Video-2-Workbooks.zip

 


 

Please leave a comment below with your data cleansing issues

and we will reply back with a fix ?

(make sure to be specific and attach example workbooks if possible)

If you like this Excel tip, please share it
Data Cleansing Training - Clean & Extract Data Using Formulas & Excel's Analytical Tools | MyExcelOnline Data Cleansing Training - Clean & Extract Data Using Formulas & Excel's Analytical Tools | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...