Help  |  Pay an Invoice  |  My Account  |  CPE Log  |  Log in

20SS-0096: Surgent's Microsoft Excel 2016: Creating and Formatting Charts (Self-Study)

Valid for one year from purchase date
Self-study - Downloadable PDF
4 CPE (4 non-technical)

If the organization paying for the purchase is exempt from sales tax, call us at 952-831-2707 to complete your purchase.

Add to cart

Alternate dates & more options

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.

Major subjects

  • 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

Learning objective(s)

  • 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

Who should take this program?

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

Fees

Our records indicate you are a nonmember. If you register, you will be charged $65.00 (Standard Nonmember Fee). Members: Please log in to receive member fee.
Standard Member Fee $65.00
checkmark Standard Nonmember Fee $65.00

More program information

Area
of study
Information technology
Field(s)
of study
Computer Software & Applications - Non-Technical (4.0)
Level Intermediate
Format Self-study - Downloadable PDF
Sponsor Surgent
NASBA ID#: 103212
Prerequisites Prereq. "Getting Started with Excel 2016" or equivalent experience working with Excel 2016 in the Windows operating system environment
Advance
prep
None

If the organization paying for the purchase is exempt from sales tax, call us at 952-831-2707 to complete your purchase.

Add to cart

Not a member? Join the MNCPA to start saving on CPE and accessing members-only benefits.

Search CPE catalog