MS Excel 2016 advanced level – Power Pivot, Formatting, Filling and Custom Forms

Overview

Using the Power Pivot feature in Microsoft Excel 2016, you can gather a lot of data from different sources and analyze it. In this course, you will learn how to use the Power Pivot Function, which was previously an additional feature and is now a feature of Excel 2016. This course also covers creating custom and conditioned formatting and filters, as well as custom add-ons.

Objectives

• Configure Power Pivot and import data into a Microsoft Excel 2016 Workbook
• Create a PivotTable using the Power Pivot function in Microsoft Excel 2016
• Create a custom number format in Microsoft Excel 2016
• Create a date format and custom time in Microsoft Excel 2016
• create a custom accounting format in Microsoft Excel 2016
• create a custom add-in format format in Microsoft Excel 2016
• create custom conditional formatting rules in Microsoft Excel 2016
• change custom conditional formatting rules in Microsoft Excel 2016
• apply complex data filtering criteria in Microsoft Excel 2016