PivotTable and Power Pivot

Pivot Tables have been at the core of dynamic reports in Excel for over 25 years, since their introduction in Excel 5 in 1994. They're often the quickest route to creating high-level or summary reports from large record sets. In the business world, most datasets are a growing set of daily transactions and business activities, which can be overwhelming for decision makers. The decision makers are often interested in summarized reports at a monthly or weekly level, grouped by a business relevant dimension (product, region, cost center, department, and so on). And for those responsible for creating these types of reports, a Pivot Table is a very convenient way to build them and capture new data in them automatically. The extremely important role a Pivot Table plays in the work life of a data analyst moved Microsoft to create Power Pivot as a more advanced version of a Pivot Table.

Pivot Tables and Power Pivot are indispensable tools for the modern data...