Course Outline
Charting In Excel
Two Hour "Byte Size" Course
All Versions

P.O. Box 225                 
East Petersburg, PA 17520-0225

Phone:717-560-3552
E-Mail:
Registrar@pceasy.com


Program Objectives: Students will learn various Charting Features utilizing Microsoft Excel. 

  • Pivot Tables

  • Charting in Excel

  • Setting Up Data for Charting

  • Chart Types

    • Area/Bar

    • Column/Line
    • Pie/XY Scatter
    • Doughnut/3-D Surface
    • Radar
    • Combination/Bubble
    • Stock/Cylinder
    • Cone/Pyramid
    • Special Chart Types
  • Using the Chart Wizard Icon

  • Legend Tab

  • Charting Toolbar

  • Moving/Resizing the Chart

  • Enhancing the Chart

  • Changing the Chart Type

  • Changing the Chart Colors

  • Using Fill Effects

  • Walls to Transparent

  • Changing the Chart Title

  • Moving/Resizing the Title or Legend

  • Changing Text Alignment/Font Size

  • Format, Insert, and Chart Menus

  • Previewing/Printing the Chart

 

 

 

  • Removing a Chart

  • Additional Charting Features

  • Charting Non-contiguous Data

  • Data Label on a Pie Chart

  • Placing a Picture Behind Chart Data

  • Formatting a Chart

  • Editing a Data Series

  • Data Series Options

  • Editing a Data Point on a Column Chart

  • Editing an Axis Scale

  • Changing Color/Patterns/Font & Font Size

  • Adding Cell Contents to a Chart

  • Adding Drawing Objects to a Chart

  • Inserting a Picture into a Chart

  • Moving a Chart to Another Sheet

  • Creating a Combination Chart

  • Primary Versus Secondary Axis

  • Adding a New Data Series to a Chart

  • Adding a Trendline

  • Adding New Data Within a Present Data Series

  • Append New Data to an Existing Data Series (Manually)

  • Append New Data to an Existing Data Series (Macro)

  • Printing Multiple Charts on a Page

  • Creating a Histogram

  • Creating a Pareto Chart

  • Creating a Cumulative Percentage Chart


 

Course Prerequisite
Must have a general knowledge of Excel at a Basic Level

(2) CPE Credits

Copyright PC Easy June, 2009