The Ultimate Excel Power Query & Data Cleansing Course

is Closing its Doors in…

 

 

ozcourse1_728x90


BONUS VIDEO #1:  

Unstack & Merge Data Using Power Query


 

In this training you are going to learn the following:
00:47 Description of Challenge
02:10 Starting to Reshape the Data
03:05 Add Index Column
03:10 Add Modulo Column
04:02 Modulo Explained
05:30 Pivot Column – Don’t Aggregate
09:39 Load Query as a Connection
10:00 Merge Queries (Left Outer Join)
12:40 Edit a Query
12:50 Adding a Conditional Column
14:32 Slicers
15:22 Summary
16:03 Kitchen Sink
 

DOWNLOAD THE EXCEL WORKBOOK 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 John 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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+