| Course |
Excel
Intermediate - Charting Data |
| Length |
Three
Hours |
| Audience |
"A
picture is worth a thousand words” and your Excel data is
no exception! Once you have mastered Excel on an introductory level,
learn to represent your data graphically to make it easier to understand
with Excel’s charting capabilities. Discover how to create
charts and then make changes. Learn to use various chart
types including bars, pies, columns and more. |
| Prerequisites |
This
course is for those people who have mastered Excel on at least an
introductory level. Windows Basics, Excel Basics and Excel Formula Building
or comparable experience is required. |
| Topics
|
Module
1: Chart Basics
- Different
way of creating a basic chart
- Examining
chart types and their uses
- Using chart
sheets or embedded charts
- Saving charts
|
|
|
Module 2: Formatting Charts
- Enhancing
titles and legends
- Managing
axis information
- Adding or
changing colors
- Moving and
sizing chart items
|
|
|
Module 3: Making Changes
- Changing
data ranges
- Changing
the chart type
- Previewing
and printing charts
|
|
|
Module 4: Adding Graphic Items
- Using new Chart tools
- Adding Text
Boxes
- Adding arrows
- Formatting
graphic items
|
