Pinterest Pixel

Data Cleansing Training Bonus Video #2: Transform an ERP Report to an Excel Pivot Table

John Michaloudis

 The Ultimate Excel Power Query & Data Cleansing Course

is Closing its Doors in...

 .
Data Cleansing Training Bonus Video #2: Transform an ERP Report to an Excel Pivot Table | MyExcelOnline Data Cleansing Training Bonus Video #2: Transform an ERP Report to an Excel Pivot Table | MyExcelOnline

Data Cleansing Training - Different Ways to Format Data Using Power Query


 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 Bonus-Video-2-Workbook.zip

 

Click to view & access the course now:

Data Cleansing Training - Different Ways to Format Data Using Power Query

 


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

 

 

 

Data Cleansing Training - Clean & Extract Data Using Formulas & Excel's Analytical Tools

Data Cleansing Training - Consolidate Multiple Excel Workbooks & Worksheets Using Power Query

Data Cleansing Training - Different Ways to Format Data Using Power Query




*** 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 it
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Excel Age Difference Calculator - How to Calculate Birthday Date & Gaps Fast!

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...