PQB04.5 | Combine Excel files from a folder | Automatically update new data | PowerQueryBasics

#excel #powerquery
--------------------------------------------------------------------
Visit the website for more content: www.aaa-power.net
--------------------------------------------------------------------
0:00 Intro
1:41 Example explained
3:19 Use combine data button
4:50 Use Excel.Workbook
13:03 Add new data & auto update the report
---------------------------------------------------------------------
Hello and Welcome, we continue with PQB or Power Query Basics.
This video demonstrates how to combine data from a folder containing Excel Files using Power Query then perform and automated required data transformation, so when you add more files to the folder, it automatically flows to your final report.
Method #1: Use "Combine Files" button 3:34
Method #2: Use "Excel.Workbook" function 7:55
The previous video was PQB16 and supposed to be the last video of PQB series, however, I received inquiries from some colleagues who watched video PQB04 (discussing combining files from a folder contains CSV files) and tried to apply the same technique to consolidate data from a folder contains Excel Workbooks but it didn't work. Accordingly, I decided to add this topic to PQB series to cater for this requirement.
--------------------------------------------------------------------
To download the excel working file, data & additional data files:
https://drive.google.com/drive/folder...
--------------------------------------------------------------------
To watch video PQB04:
   • Видео  
--------------------------------------------------------------------
To view the full play list
   • PQB | Power Query Basics  
--------------------------------------------------------------------
To subscribe:
   / @aaaexcelenglish  
---------------------------------------------------------------------
To follow on Facebook:
  / excelispower  
---------------------------------------------------------------------
To follow on LinkedIn:
  / amratef