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