| Dates for this class: |
| No dates are available for this class. |
| Course Details [choose new course] [printable version] |
| Speaking with Excel Charts (MOC50102) |
| Course Number: MOC50102 |
| Category: Business & Office Applications |
| Duration: 1.00 day |
Description
Students will learn to effectively create interactive charts using Microsoft Excel. The charts
can be used for presentations and reports.
Outline
Why Use Charts
- The good the bad and the ugly
- Components of a chart
- Choosing a chart type
Creating Charts in Excel
- Create charts with the wizard
- Resizing and Moving
- Change the Chart type and subtype
- Add new data series
- Change the plot direction
- Change chart location
- Change Data Sources
Formatting Charts
- Format a chart
- Change background color
- Add chart titles and legends
- Format text objects
- Change Chart Orientation
Advanced Formatting Features
- Changing Value Axis
- Add and Format Gridlines
- Format Data Series
- Add Data Labels
- Create user defined charts
- Add trendlines
Doughnut and Pie Charts
- Using pie charts effectively
- Creating a simple pie chart
- 3d rotation and exploding pie charts
- Create a doughnut chart
Bar and Column Charts
- Using bar/column charts effectively
- Creating a bar chart
- 3d rotation formatting
- Create a column chart
Line and Area Charts
- Using Line and Area charts effectively
- Creating a Line and Area chart
- 3d rotation formatting
Scatter and Bubble Charts
- Using Scatter and Bubble charts effectively
- 3d rotation formatting
Creating Pivot Charts and Interactive Charts with Lists and Pivot tables