Consolidate Data from All Excel Worksheets in Multiple Excel Workbooks

This is probably level 8 on the Power Query Difficulty Scale (that goes to 10 if you are not aware :) ), but boy, it is THE BEST thing you can learn in Power Query. By watching this video, you will not only learn how to combine or consolidate data from multiple WorkSheets from Multiple Workbooks. More importantly, you will learn how to create Custom Functions in Power Query—so turning your single Query into a reusable tool of choice that you point to any data source and it does its magic. Imagine creating a custom Power Query Function to dynamically fill in the last part of a particular URL and then consolidated data from all the URLs. Pure brilliance!

This tutorial was made using Excel 365, but all methods work with Excel 2010 and above. Keep in mind that for Excel 2010 and 2013, Power Query is a separate AddInn you have to install.

Blog Post on the Topic: https://bit.ly/2VEVOfF
Another Post on the topic: https://bit.ly/3ANAhl0

Chapters:
0:00​ Excel Olympics Animation
0:08 Introduction and Explanation
1:16 Data Review and Power Query Strategy
3:02 Creating a Base Query
5:38 Turning a Query into a Function
7:52 Final Query - Power Query From Folder
15:23 Outro

Gear Used:

US Links
Camera: Canon EOS R6 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7

EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y

Recorded With: Camtasia - https://www.techsmith.com/video-edito...

Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub

Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK

Disclaimer: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!

#Excel #ExcelOlympics #gasperkamensek