Course Details

Previous Page


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


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



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