The skills tested in this section of the Microsoft Office Specialist Expert exams for Microsoft Excel 2013 relate to creating sophisticated charts and tables. Specifically, the following objectives are associated with this set of skills:
|4.1 Create advanced chart elements|
|4.2 Create and manage PivotTables|
|4.3 Create and manage PivotCharts|
The data contained in an Excel worksheet can often be presented as a chart for the purposes of analysis, reporting, and sharing. You can use charts to add emphasis in verbal presentations and printed reports, or to present data that is inherently visual or difficult to describe, such as a trend or a growth curve. Excel 2013 provides a variety of tools that you can use ...