Overview
This class is geared toward the above average user who wants to increase their productivity and effectiveness with Excel charts and graphs.
Audience
Prerequisite: Excel Basics, MS Excel Level 1 or equivalent experience.
Length
4 hours
Outline
- 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