Create advanced charts and tables Overview

The skills tested in this section Create advanced charts and tables of the Microsoft Office Specialist Expert exams for Microsoft Excel 2013 relate to creating sophisticated charts and tables. 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 to create charts and tables to display your data. This chapter guides in you studying methods for creating advanced chart elements, and creating and managing PivotTables and PivotCharts.

Specifically, the following objectives are associated with this set of skills:

Create advanced chart elements

This #section describes specific features you can apply to charts to highlight trends in #data, how to use chart templates, ...
Read More

Create and manage PivotTables

Arranging a large #data set as a PivotTable report can help facilitate your analysis and presentation of the information it ...
Read More

This chapter is a part of 77-427 Excel 2013 Expert Part One Prep course. More chapters in this course are

Excel 2013 Workbooks Management

Excel 2013 Workbooks Management Overview The skills tested in this section Excel 2013 Workbooks Management of the Microsoft Office Specialist Expert exams ...
Read More

Apply custom formats and layouts in Excel 2013

Apply custom formats and layouts in Excel 2013 Overview The skills tested in this section Apply custom formats and layouts in ...
Read More

Advanced formulas in Excel 2013

Advanced formulas in Excel 2013 Overview This section discusses the skill of creating Advanced formulas in Excel 2013, which is an ...
Read More

Create advanced charts and tables

Create advanced charts and tables Overview The skills tested in this section Create advanced charts and tables of the Microsoft Office ...
Read More

The Practice tests included in this course are:

No posts found.