Certification     Isograd     TOSA Desktop     TOSA Excel 2016

---

You can create advanced PivotTables and analyze data from a variety of different sources using the Power Pivot add-in for Excel 2016. Learn how to use Power Pivot to import databases, create and modify tables, and create a dashboard.

---

---

Objectives

Excel 2016: Using the Power Pivot Add-in Activating Power Pivot Using the view settings in Power Pivot Importing your database Creating Power Pivot relationships Customizing your Power Pivot tables Applying data formats in Power Pivot tables Sorting the data in your Power Pivot table Filtering data in your Power Pivot table Creating a calculated field in your Power Pivot table Creating custom views in your Power Pivot table Updating your Power Pivot tables Creating an advanced PivotTable Creating an advanced PivotChart Creating a dashboard