Excel, Charts and Graphs

This half day course will teach you how to create and use Excel charts and graphs to maximize efficiency.


This class is geared toward the above average user who wants to increase their productivity and effectiveness with Excel charts and graphs.


Prerequisite: Excel Basics, MS Excel Level 1 or equivalent experience.


4 hours


  • Creating Charts and Graphs
    • Creating a Chart
    • Chart Tools
  • Understanding Chart Objects
    • Labels
    • Axes
    • Backgrounds
    • Editing Chart Objects
  • Different Chart Types
    • Line Charts
    • Bar Charts
    • Pie Charts
    • Other Chart Types
    • Changing Chart Types
    • Custom Chart Types
  • Using Trendlines
    • Linear Trendlines
  • Formatting Charts
    • Shape Styles
    • Layouts
  • Creating Dynamic Charts
    • Adding Links to a Chart
  • Creating a PivotTable
    • Creating a PivotTable
  • Creating a PivotChart
    • PivotChart Limitations
    • Creating a PivotChart from a PivotTable
    • Creating a PivotChart from a Database List
  • Charting Tips and Tricks
  • Excel Shortcut Keys
  • Excel Key Tips