Excel Power Query Data Cleansing Part 3 Consolidate Workbooks Worksheets Using Power Query

/in /by

In this final video of the 3 part training series on Excel Power Query & Data Cleansing you will learn the different ways to consolidate your various Excel workbooks and worksheets using Power Query. Download the Excel workbooks used in this tutorial to practice:
http://myexcelonline.com/blog/wp-content/uploads/2016/06/Data-Cleaning-Power-Query-Training-Video-3.zip
This training is for beginners & intermediate Excel users and can be applied to Microsoft Excel 2010, 2013 & 2016 versions.

You will learn the following topics:

Intro from Oz du Soleil
03:30 – Consolidate multiple Excel workbooks using Power Query (Get & Transform in Excel 2016)
12:50 – Consolidate multiple Excel worksheets using Power Query (Get & Transform in Excel 2016)

Click on the following links to watch the other training videos:

VIDEO 1: Different Ways to Format Data Using Power Query

VIDEO 2: Format & extract data using Excel Formulas & Excel’s Data Tools

WATCH OUR FREE WEBINAR ON POWER QUERY & DATA CLEANSING NOW: http://www.myexcelonline.com/107-21.html

Please share, like & leave your comments below.

Thanks much!

Oz

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My blog: http://datascopic.net/blog-2-2