PivotTables or Power Pivot: Choose Your Course

Two reporting problems

Imagine a clean list of project costs with columns for date, project, category and amount. Your immediate question is how to summarise it by project and filter the result. That points toward the PivotTable and slicer topics in Advanced Data Management.

Now imagine that the analysis draws on several related sources and needs a reusable model. That points toward the relationships and measures in Expert Data Management. These examples illustrate a buying decision; they do not promise a particular class exercise or custom implementation.

Compare	Advanced Data Management	Expert Data Management
Data preparation	Validation, duplicate handling and advanced filters	Power Query imports, cleaning and connections
Reporting	PivotTables, PivotCharts and slicers	Model-based reporting and refresh workflows
Modelling topics	Not the dedicated Power Pivot course	Data models, relationships, measures and KPIs
Starting point	Compare the outline against your current Excel work	Published prerequisite: Advanced Data Management or equivalent

Check the application as well as the course name

Microsoft describes Power Pivot as an Excel data-modelling tool. Confirm that your installed Excel edition supports the features used in the course. Do not assume every feature is available in every Excel application simply because a workbook can be opened there. See Microsoft’s Power Pivot overview.

For a broader view of the available paths, compare the Excel courses. If the data foundation already works and the problem is presentation, the separate dashboard course may be more relevant.

Related options: Excel Advanced Data Management: PivotTables, Filtering and Validation; Excel Training for Teams and Businesses; Excel skills assessment.