Excel 2010: Virtual Training - Graphics & Charting

COURSE OUTLINE:

Description This two-hour virtual training will teach attendees how to create and modify a chart. Charts are visual representations of your data, and, as the old adage states, “A picture is worth a thousand words”. Add a chart to your worksheet and save yourself from having to use those thousand words to explain your worksheet data. Excel provides standard and custom charts types that can be used to describe your data more effectively.

Virtual classes are interactive training sessions delivered in real-time via the Web.

Prerequisites
Students should have completed Excel 2010: Level 2, or have equivalent knowledge, and should be confident of using worksheet formulas, functions and formatting.

Course Content


CREATING CHARTS

Using Charts
Creating Charts with the Chart Wizard
Moving and Resizing Charts
Identifying Chart Objects
Changing the Chart Type
Changing the Chart Type and Sub-type
Changing the Plot Direction
Removing/Adding a Legend
Moving the Legend
Charting Non-adjacent Ranges
Changing the Chart Range
Changing the Data Source
Changing the Chart Location
Printing a Chart

FORMATTING CHARTS

Formatting Charts
Adding Chart Titles
Formatting Chart Objects
Changing the Text Orientation
Adding a Data Table
Creating an Exploded Pie Chart
Adjusting the 3-D View
Deleting a Chart

DRAWING AN OBJECT

Working with Drawing Objects
Drawing Enclosed Objects
Drawing a Line
Selecting Filled and Unfilled Objects
Moving an Object
Adding Text to an Object
Selecting Text in an Object
Resizing an Object
Formatting Lines
Changing and Removing the Fill Color
Changing the Font Color
Deleting an Object

ADVANCED CHARTING

Adding and Removing Gridlines
Formatting Gridlines
Formatting an Axis
Changing the Axis Scaling
Formatting the Data Series
Adding Data - Different Worksheets
Using a Secondary Axis
Changing Data Series Chart Types
Adding a Trendline
Creating User-defined Charts
Applying User-defined Charts

USING ADDITIONAL EFFECTS AND OBJECTS

Adding a 3-D Effect
Applying a 3-D Setting
Adding a Shadow
Drawing a Text Box
Drawing an Arrow
Inserting Pictures
Formatting Graphics

USING AUTOSHAPES AND DIAGRAMS

Working with AutoShapes
Drawing a Callout
Drawing a Basic Shape
Drawing a Connector
Drawing a Flowchart Shape
Drawing a Block Arrow
Inserting a Diagram
Working with Diagrams