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)

1

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