The Ultimate Excel Power Query & Data Cleansing Course

is Closing its Doors in…

 

ozcourse1_728x90


 BONUS VIDEO #2:

Transform an ERP Report to an

Excel Pivot Table Dashboard


 

In this training you are going to learn the following:
Intro: Converting Financial Data into a Flat File
01:00 Starting the Solution
04:50 Add Conditional Column in PQ
07:10 Unpivot Other Columns
08:42 Insert Pivot Table
09:28 Insert Slicers
10:28 Intro 2: Pointing to a Dedicated Folder
16:25 Add New File to Dedicated Folder
17:08 Refresh Pivot Table
17:27 Add another File to Dedicated Folder
18:50 A word about Queries, Connections and Filepaths
20:00 Editing the Query
 

DOWNLOAD THE EXCEL WORKBOOKS USED IN THIS VIDEO

 

Click to view & access the course now:

ozcourse1_728x90

 


View Training Videos 1, 2 & 3 again before they disappear in:

 

 

 

PQ VIDEO 1 THUMBNAIL WITH VIDEO PLAYER

plc-video-2-thumbnail-v2

PLC VIDEO 3 - THUMBNAIL with play


*** NEW ANNOUNCEMENT ***

Listen to Oz and I discuss data cleansing & our upcoming online course…

 


 

Please leave a comment below if you liked this video or if you have any questions and we will reply back with a fix 🙂 

(make sure to be specific and attach example workbook links 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+