Course Outline
Charting In Power Point and Excel
Two Hour "Byte Size" Course

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

Program Objectives:   Students will learn various Charting Features utilizing Microsoft Power Point and Microsoft Excel and will learn how to share charts between the two programs. 
 

• Charting In Excel

• Setting Up The Data

• Category 'X' Axis

• Value 'Y' Axis

• Chart Types In Power Point And Excel
  Area And Bar Charts
  Column And Line Charts
  Pie Chart And XY Scatter Charts
  Doughnut And 3-D Surface Charts
  Radar Charts
  Combination And Bubble Charts
  Stock And Cylinder Charts
  Cone And Pyramid Charts
  Special Chart Types

• Creating The Default Column Chart

• Using the Chart Wizard Icon

• Charting Series In Columns

• Charting Series In Rows

• Changing The Location Of The Legend

• Charting Toolbar

• Moving And Resizing The Chart

• Chart Wizard Steps

• Enhancing The Chart

• Changing The Chart Type

• Changing The Chart Colors

• Adding Fill Effects To The Chart

• Walls To Transparent

• Changing The Appearance Of The Legend

• Changing The Chart Title

• Moving The Legend And Title

• Resizing The Legend And Title

• Changing Text Alignment And Font Size

• Format, Insert, And Chart Menus

• Previewing The Excel Chart

• Printing The Excel Chart

• Removing A Chart

• Additional Charting Features

• Charting Non-contiguous Data

• Data Labels On A Pie Chart

• Placing A Picture Behind The Chart Data

• Charting In Power Point

• Power Point Datasheet

• Permanently Remove A Data Series

• Temporarily Remove A Data Series

• Changing Chart Type

• Importing Excel Data Into Power Point

• Formatting Data By Rows

• Formatting Data By Columns

• Copying An Excel Chart Into Power Point

• Linking An Excel Chart To Power Point

• Updating A Linked Chart In Power Point

• Enhancing The Chart In Power Point

• Formatting The Axis Labels

• Changing Axis Rotation

• Duplicating A Power Point Slide

• Duplicating A Power Point Chart

• Adding A Data Table To A Chart