Exam 77-427 Microsoft Excel 2013 4. Create Advanced Charts and Tables 4.2 Create and Manage PivotTables: Use PowerPivot

Introducing PowerPivot PowerPivot is a more sophisticated approach to PivotTables and PivotCharts. A PowerPivot works with a Data Model. The Data Model can have more than one Perspective, or View, of the data. 6. Start Here: Create a PowerPivot Go to PowerPivot->Data Model->Manage. What Do You See? A PowerPivot should open in a new window. The data, tblProducts, will be formatted as a PivotTable.   Keep going... PowerPivot ->Data Model-> Manage