Loading Data from Multiple Files in Excel using Power Query
ExcelChef - 3/101
Struggling to load Data from multiple files into Excel? Tired of copying data from multiple files and pasting it? There is an easier way...
The Data Menu in Excel can help you load / connect to a variety of data sources and load data into excel in a more systematic way. The Data menu is powered by Power Query - A Powerful Data Transformation Engine.
In my opinion Power Query is the single most powerful feature in excel that can take away all the pains of working with multiple sources and data transformations.
Here is a quick overview of how to load multiple files using Get Data in Excel.
There will be a series of Power Query based videos following this with nice little projects spread in between.
This is the 3rd video in the ExcelChef 101 Series. 98 more to go...
What excel topics would you like me to post? Share your feedback in the comments. Please share this post with friends and colleagues - Who knows you might help them decrease their excel workload!
#excelskills #exceltips #exceltutorial #exceltricks #excel #msexcel #excelonline #exceltraining #excelformulas #exceltipsandtricks #exceldataentry
On this page of the site you can watch the video online Loading Data from Multiple Files in Excel using Power Query with a duration of hours minute second in good quality, which was uploaded by the user ExcelChef 17 May 2021, share the link with friends and acquaintances, this video has already been watched 296 times on youtube and it was liked by 4 viewers. Enjoy your viewing!
