Video #1:

Watch Now
PQ VIDEO 1 THUMBNAIL WITH VIDEO PLAYER

Video #3:

Coming Soon

PLC VIDEO 3 - THUMBNAIL with play

 


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
 

DOWNLOAD THE EXCEL WORKBOOKS USED IN THIS VIDEO

 


 

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)

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin