Building Interactive Dashboards in Microsoft 365 Excel

5

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. ...