Course Outline

Microsoft Excel 2007 Charting in Depth
This class is designed for people who are familiar with Excel who need to go beyond the basics for creating charts and graphs.  Participants will learn to create chart sheets and embedded charts and to enhance charts by using colors, gradients, textures and fill effects.  The class covers Excel's various chart types and how to change from one chart type to another.  The class covers using pictures and graphic objects to customize charts.

Participants should have direct experience working with the Excel 2007 user interface.  Participants should know how to use common Excel functions in basic formulas and should be able to create workbooks, enter and format data, insert worksheets and similar basic tasks. 6 hours.

Introduction and Chart Basics

  • What is a Chart and Why Would You Want One?
  • Anatomy of a Chart
  • Chart Types
  • Embedded Charts vs. Chart Sheets
  • Specifying Chart Data

Formatting Charts

  • Fills, Borders, and Backgrounds
  • Chart Series
  • Text on Charts: Titles, Legends, and Labels
  • Chart Axes

Trend lines

  • Understanding Trend lines
  • Using Error Bars

Using Shapes and Graphics

  • Inserting and Customizing Shapes and Other Graphics
  • Using Shapes with Charts

Interactive Charts

  • What is an Interactive Chart?
  • Interactive Chart Types

Charting Tips &Tricks

  • Lines, Backgrounds, and Other Chart Variations
  • In-cell Charting Techniques
  • Avoiding Common Charting Mistakes
Prerequisites:  Excel Level 2 or equivalent experience.

Revised 8/15/2011
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600