Traditional PivotTables are incredible, but have limitations. Use Power Pivot to bypass many of these restrictions.
Power Pivot is included in current versions of Excel for Windows (unavailable in Excel for Mac). It enables the creation of PivotTables that were previously not practical. In this session, we’ll build PivotTables from multiple tables and create measures.
Master Power Pivot to enhance your reports.
Recall the steps to access the Power Pivot window
Identify the process to create table relationships
State the procedure for creating measures
Power Pivot
Data Model
PivotTables
Measures
Table Relationships
Calculated Columns
Cube Functions
CPAs, accountants and staff.
Comfortable with traditional PivotTables.
If you’d like to work along, please confirm your version of Excel supports Power Pivot.