Microsoft Office 2016 Intermediate Excel: PivotTables and Advanced Charts

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
52 minutes

Description
In Microsoft Excel 2016, PivotTables and PivotCharts let you dynamically reorganize and display your data. They can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. You can choose and change what you want to summarize. In this course, you will also learn how to use advanced chart features like trendlines and dual axis charts.

Objective

PivotTables

  • start the course
  • create a PivotTable in Microsoft Excel 2016
  • modify the data in a PivotTable in Microsoft Excel 2016
  • alter the look of your PivotTable in Microsoft Excel 2016
  • filter PivotTable data with slicers in Microsoft Excel 2016
  • PivotCharts

  • use recommended charts to create a PivotChart in Microsoft Excel 2016
  • use PivotTable data to create a PivotChart in Microsoft Excel 2016
  • alter the data in a PivotChart in Microsoft Excel 2016
  • Advanced Charts

  • add trendlines to a chart in Microsoft Excel 2016
  • create a dual axis chart in Microsoft Excel 2016
  • create a chart template from an existing chart in Microsoft Excel 2016
  • Practice: PivotTables and PivotCharts

  • present data in PivotTables and PivotCharts
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.