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