Microsoft Excel 2016 Advanced: Power Pivot, Custom Formatting, Fills, and Forms

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
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.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel; and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016

Prerequisites
None

Expected Duration (hours)
1.2

Lesson Objectives

Microsoft Excel 2016 Advanced: Power Pivot, Custom Formatting, Fills, and Forms

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

create and populate a PivotTable using Power Pivot in Microsoft Excel 2016

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

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

use custom formats, filters, and fill series when working with data in Microsoft Excel 2016

Course Number:
mo_adve_a02_dt_enus

Expertise Level
Expert