Customer Service: 800-778-7436     

    Log In to Your Surgent Account

    Forgot?
    Forgot?

    Register for an Account

Sign In to Your Surgent Account

Forgot Username or Password | Register for an Account

Choose CPE Format:

Live WebinarSELECT

There are currently no upcoming dates scheduled for this webinar. Please fill out this short form to be notified when this webinar is next available. 

FIRST NAME
LAST NAME
EMAIL ADDRESS
COMMENTS (OPTIONAL)
Self-StudySELECT STARTING AT $65

Downloadable PDF

Credits: 4

Qualifies For:

$65

Textbook

Credits: 4

Qualifies For:

$80
Get this course FREE with an Unlimited Package! Learn More
  • 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 2013: Creating and Formatting Charts Using a Touch Screen (CFCT)

  • Customer Rating
  • Field of Study
    Spec. Knowledge
  • 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. It is ideal for users familiar with Excel 2013 or those who have completed the basic Excel 2013 course. This course emphasizes using finger gestures and the keyboard to perform tasks in the Windows 8 operating system environment – mouse actions are not included.

Major Topics:

  • Identify chart elements
  • Create an embedded Pie chart using Recommended Charts
  • Reposition and resize the embedded Pie chart
  • Create a Clustered Column chart using the Quick Analysis feature
  • Modify the Clustered Column chart’s underlying data
  • Move the Clustered Column chart to a chart sheet
  • Preview and print charts
  • Change the chart type and subtype
  • Apply a predefined chart layout and chart style
  • Add, select, and format individual chart elements
  • Add and remove data; change data orientation
  • Create and format a Line with Markers chart
  • Create and format a Stacked Area chart
  • Create and format an exploded 3-D Pie chart
  • Create and format a Pie of Pie chart
  • Create and format a Clustered Column-Line on Secondary Axis combination chart
  • Create and format Sparklines
  • Add pictures and shapes to 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
  • Who should take this course:

    Designed for:

    Users experienced with using Excel 2013 in the Windows 8 operating system environment with a touch-screen, or experienced Excel users switching from earlier versions of Excel.

    Prerequisite:

    "Microsoft® Excel® 2013: Getting Started Using a Touch Screen" (GSET) or equivalent experience working with Excel 2013 in the Windows 8 operating system environment with a touch-screen tablet, notebook, or laptop

    Advanced Preparation:

    None

    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

    Self-Study Library Package

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

    • Courses range from 2-20 credits

    • Provides online grading & CPE certificates by email

    $499

    Learn More

    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 12/31/16

    $649

    Learn More

    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

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

    $849

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

    Explore Additional Courses by Topic

    SURGENT IS APPROVED AS A PROVIDER OF CONTINUING EDUCATION BY:

    Thank You!

    Thank You! Your subscription has been submitted.