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

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

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


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

  • Pivot Tables in Excel

  • Charting In Excel

  • Chart Styles
         Area Chart
         Bar Chart
         Column Chart
         3-D Column Chart
         Line Chart
         3-D Line Chart
         Pie Chart
         3-D Pie Chart
         XY Scatter Chart
         Doughnut Chart
         3-D Surface Chart
         Radar Chart
         Combination Chart
         Bubble Chart
         Stock Chart
         Cylinder Chart
         Cone Chart
         Pyramid Chart
         Special Chart Types

  • Setting Up Data For Charting

  • Charting Terminology

  • Using the Chart Wizard To Create A Chart

  • Moving The Chart On The Page

  • Resizing The Chart

  • Enhancing The Appearance Of The Chart

  • Changing The Chart Type

 

 

  • Changing The Chart Colors

  • Using Fill Effects To Embellish The Chart

  • Changing The Chart Title

  • Moving The Title Or Legend

  • Resizing The Title Or Legend

  • Printing The Excel Chart (With The Data)

  • Printing The Excel Chart (Without Data)

  • Removing A Chart

  • Restoring A Chart

  • Editing A Data Series

  • Editing An Axis

  • Moving A Chart to Another Sheet

  • Adding Drawing Objects To A Chart

  • Adding A Data Table To A Chart

  • Formatting A Data Table In A Chart

  • Inserting A Picture Into A Chart

  • Creating A Combination Chart

  • Adding A New Data Series To A Chart

  • 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

 

Please Click Here to Register for Class
 

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

(2) CPE Credits

Copyright PC Easy November, 2004