 |
Training |
Excel Level 2
Course Description
Students will learn
the skills and concepts necessary to create charts and to use the
list-management capabilities of Excel.
Prerequisites
Excel Level 1
or equivalent knowledge.
Study Method:
Flexible
Learning: Group
Training
What Next?
Excel
Level 3
Course Content
Lesson 1: Creating Charts
Creating
a Chart Sheet
Creating
an Embedded Chart
Comparing
Chart Sheets with Embedded Charts
Lesson 2: Modifying
Charts
Chart
Types
Modifying
Embedded Charts
Adding
and Deleting Chart Items
Moving
and Sizing Chart Items
Lesson 3: Formatting a
Chart
Formatting
Chart Text
Formatting
Labels
Formatting
the Chart
Printing
a Chart Sheet
Lesson 4: Using Graphic
Objects
Adding
Graphic Objects
Formatting
Graphic Objects
Using
Graphic Objects to Enhance Worksheets and Charts
Lesson 5: Sorting Data
Single-level
Sorting
Multiple-level
Sorting
Sorting
Options
Importing
Data
Design
Considerations
Lesson 6: Filtering Data
Filtering
a List
Custom
Criteria
Multiple-condition
Criteria
Managing
a Filtered List