Customer Service: 800-778-7436     

To access your product click the Log In link at the top right of the screen. Once inside your account, you will be able to access your Packages, Self-Study Product, and Webinar Registrations.

Sign In to Your Surgent Account

Forgot Username or Password | Register for an Account

Microsoft® Excel® 2016: Creating and Formatting Charts (CF16)

Choose CPE Format:

Self-Study SELECT STARTING AT $65 (On Demand)

Downloadable PDF

Credits: 4

Qualifies For: CPE

$65

Textbook

Credits: 4

Qualifies For: CPE

$80
  • It was an awesome course. I have recommended it to a couple of CPA friends.

    - A Surgent Customer

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.

Microsoft® Excel® 2016: Creating and Formatting Charts (CF16)

  • Customer Rating
  • Field of Study
    Specialized Knowledge and Applications
  • Level
    Intermediate
  • Credits
    4
  • Qualifies for

    CPE

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.

Major Topics:

  • 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 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

Designed for:

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

Prerequisite:

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

Advanced Preparation:

None

  • It was an awesome course. I have recommended it to a couple of CPA friends.

    - A Surgent Customer

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.
loading

Loading...

Loading...

Thank You!

YOU HAVE ADDED THE FOLLOWING TO YOUR CART:


Loading...

Thank You!

Thank You! Your request has been submitted.



Get More with a Surgent CPE package

Unlimited Self-Study Package

  • Unlimited 24/7 access to 200+ downloadable self-study courses

  • Courses range from 2-20 credits

  • Provides online grading & CPE certificates by email

  • Does NOT include Premium courses

$499

Buy Now

Unlimited Webinar Package

  • Unlimited access to all non-premium live CPE webinars

  • Includes 1-, 2-, 3-, 4-, and 8-hour webinars, including Saturday and evening options

  • Access through December 31st of the year in which you purchase

  • Does NOT include Premium courses

$599

Buy Now

 

Unlimited Plus Package

  • Unlimited access to ALL live CPE webinars

  • Includes all premium courses and virtual conferences

  • Unlimited 24/7 access to all self-study courses

  • Includes all on-demand webcasts

  • Access for a year from purchase date

$799

Buy Now
  • CPE Continuing Professional Education for CPAs

  • IRS Continuing Education for EAs and the AFSP program

  • CFP Accepted by the CFP® Board

  • YB YellowBook Continuing Education

  • CTEC Approved for CE by CTEC

Explore Additional Courses by Topic

QAS Approval Surgent IRS Approval Surgent CFP Approval Surgent CTEC Approval Surgent
CPE Webinars
CPE Webinars

Thank You!

Thank You! Your subscription has been submitted.