Video #2:

Coming Soon

plc-video-2-thumbnail-v2

Video #3:

Coming Soon

PLC VIDEO 3 - THUMBNAIL with play

 


VIDEO #1: 

Different Ways to Format Data Using Power Query

 

In this training you are going to learn the following:
Intro from John Michaloudis & Oz du Soleil
12:10 – Intro to Power Query (Get & Transform in Excel 2016)
16:30 – Trim leading & trailing spaces
20:30 – Format “text” Dates & Values using Excel v Power Query
24:15 – Parse URLs using Excel v Power Query
27:55 – Transform & automate reports from an ERP system (e.g. Oracle, SAP, QuickBooks) into a flat Excel file
 

DOWNLOAD THE EXCEL WORKBOOKS USED IN THIS VIDEO

 


Bonus Video:

Install Power Query Using Excel 2010 & Excel 2013

 

 

CLICK HERE TO READ HOW TO INSTALL POWER QUERY IN EXCEL 2010

CLICK HERE TO READ HOW TO INSTALL POWER QUERY IN EXCEL 2013

 


 

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 itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+