اكسل

You already know how to make a pivot from data in one file. How about creating a pivot with data from multiple files? You can use Excel Power Query to connect to multiple files and fetch the data. We can then load this data in to “Data model” and create pivot tables from it easily.

To make pivot tables from data in multiple files:

1. Use “Get & Transform data” option in Excel data ribbon to connect to your source data files. These can be either spreadsheets or database tables or web pages etc.
2. Load data in to data model from Power Query so that Excel can access this data.
3. Insert Pivot Table from the data model

[Related: Introduction to Power Query]