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)

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