Exam 77-427 Microsoft Excel 2013 Expert 4. Create Advanced Charts and Tables 4.2 Create and Manage PivotTables: Use PowerPivot Perspectives (Power Pivot Reports)

Change the Data Model Information is dynamic. What happens if you change the Data Model? Will the Power View update? What about the other PivotChart? Here is a simple test that you can do, with or without a Share Point Server.   1. Try it: Edit the Data Model Go to PowerPivot ->Data Model->Manage. The PowerPivot window will open. Select a Field: Item. Go to Home->Sort and Filter->Sort A to Z..   What Do You See? The Items will be Sorted from Avocado to Yeast Donuts (A-Z). Go to File->Save. You should return to the Power View. Sooooo then, what? PowerPivot ->Data Model-> Manage