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

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

Prerequisite
None

Expected Duration
71 minutes

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.

Objective

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
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.