Collections     Essentials     Microsoft Office 2016: Advanced Excel

---

Using Power Pivot in Microsoft Excel 2016, you can pull together huge amounts of data from different sources and analyze it. In this course, you will learn how to use Power Pivot, which was formerly an add-in and is now a feature of Excel 2016. This course also covers the creation of custom and conditional formatting and filters, as well as custom fills.

---

---

Objectives

Power Pivot start the course configure Power Pivot and import data into a Microsoft Excel 2016 Workbook create a PivotTable using Power Pivot in Microsoft Excel 2016 Practice: Using Power Pivot create and populate a PivotTable using Power Pivot in Microsoft Excel 2016 Custom Formats and Fills create a custom number format in Microsoft Excel 2016 create a custom date and time format in Microsoft Excel 2016 create a custom accounting format in Microsoft Excel 2016 create a custom fill series in Microsoft Excel 2016 Conditional Formatting and Filters create custom conditional formatting rules in Microsoft Excel 2016 modify custom conditional formatting rules in Microsoft Excel 2016 apply complex filtering criteria to data in Microsoft Excel 2016 Practice: Format, Fills, and Filtering use custom formats, filters, and fill series when working with data in Microsoft Excel 2016