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)

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