Surgent's Microsoftr Excelr 2016: Creating and Formatting Charts - Download

Overview

Excel provides a variety of tools you can use to create, format and enhance charts: contextual Ribbon tab buttons, menus and galleries, shortcut menus, keyboard shortcuts, task panes, and more. This course allows you to explore using these tools to create and format common chart types.

Highlights

Identify chart elements
Select an embedded Pie chart using Recommended Charts; select formatting options for the chart
Select a Clustered Column chart using the Quick Analysis feature; select formatting options for the chart
Recognize how to preview and print charts
Select methods to change the chart type and subtype
Identify how to apply a predefined chart layout and chart style
Recognize ways to add, select, and format individual chart elements
Select methods to add and remove data and change data orientation
Select Line with Markers, Stacked Area, exploded 3-D Pie, Pie of Pie, and Clustered Column-Line on Secondary Axis, Treemap, Sunburst, and Waterfall charts; identify ways to format the charts
Recognize a Sparklines chart; identify formatting options for the chart
Identify ways to insert and format a picture and draw and format a shape on a chart

Prerequisites

“Getting Started with Excel 2016” or equivalent experience working with Excel 2016 in the Windows operating system environment

Designed For

Experienced Excel 2016 users, or experienced Excel users switching from earlier versions.

Objectives

Create, preview, and print commonly used charts
Format charts using the Chart Elements and Chart Styles buttons
Apply chart quick layouts and quick styles
Modify a chart’s underlying data using multiple methods
Reposition and resize an embedded chart
Move an embedded chart to its own chart sheet
Select and format individual chart elements