Excel Charts & Graphs – Virtual Live

Excel Charts & Graphs –  Virtual Live

Course Description: This course will demonstrate to the Excel user how to create effective charts off of spreadsheet data. A discussion of chart basics will be featured along with the creation of column charts, pie charts, three-dimensional charts, and a variety of chart formatting techniques. The user will also be exposed to more advanced charting such as secondary axis charts, combination charts, the Pie of Pie chart, and adding a trendline.

Objective: Upon completion of this course the user will be able to use charts and charting techniques to visually display their data graphically.

  • Chart basics
    1. Common do’s and don’ts
    2. Exploring the data source
    3. Switching row and column data
  • Column charts
    1. Two-dimensional charts
    2. Three-dimensional charts
  • Chart Formatting
    1. Color fills and lines
    2. Axis editing
    3. Data points and labeling
  • Pie charts
    1. Adding data labels
    2. Rotating 3D charts
    3. Exploding slices
  • Advanced Charts
    1. Secondary Axis
    2. Combination charts
    3. Pie of Pie charts
  • Adding a Trendline
Course Information
  • Course Level:Intermediate
  • Prerequisite:Basic Excel Training
  • Credit:3 CPE hours
  • Fee:$135
  • Length:3.5 hours
  • Hours:1:30 p.m. - 4:30 p.m. (flexible
  • Delivery:Virtual Live

Related Courses