O'Reilly logo

MOS 2016 Study Guide for Microsoft Excel Expert by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Objective group 4. Create advanced charts and tables

The skills tested in this section of the Microsoft Office Specialist Expert exam for Microsoft Excel 2016 relate to creating charts, PivotTables, and PivotCharts. Specifically, the following objectives are associated with this set of skills:

4.1 Create advanced charts

4.2 Create and manage PivotTables

4.3 Create and manage PivotCharts

Worksheets and external databases can contain hundreds of thousands or even millions of records. Analyzing that much data can be extremely difficult without the right kinds of tools. To help you, Excel offers three powerful data analysis tools: charts, PivotTables, and PivotCharts. By using these tools, you can visualize or summarize a large dataset in a concise ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required