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.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 ...
Get MOS 2016 Study Guide for Microsoft Excel Expert now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
