Auto Updated Pivot Tables Using Power Query

Using Power Query, you can create a folder of Excel workbooks that are related and that automatically update every time you add new workbooks to the folder. It makes life so much more efficient. Power Query will not only add the new data to our analysis, but it will also carry out any cleaning instructions that you used on the previous data. #excel #powerquery

Download the following three files and save them all to a folder named: Donut Sales

Once you are at the appropriate point in the video, download the file below and save it also to the Donut Sales folder . . . but wait until the video is at the right point!

0:00 – Intro
0:44 – Setting the Stage
1:27 – Get Data From Folder
2:02 – Combine Files with Power Query
3:02 – Transform the Data
8:48 – Close and Load the Data
9:20 – Create Pivot Table and Pivot Chart
9:48 – Save the NEW File to the Folder
10:49 – Refresh the Pivot Table