| |
|
| |
Excel 2000 - Level 2 Training Class
Course ID: 5960
|
|
| |
|
|
| |
|
|
| |
Excel 2000 - Level 2 Training Seminar
Overview:
Students will learn the skills and concepts necessary to create charts and to use the list-management capabilities of Excel 2000.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Sorting Data
Single-level Sorting
Multiple-level Sorting
Sorting Options
Design Considerations
|
|
Lesson 2: Filtering Data
Filtering a List
Custom Criteria
Multiple-condition Criteria
Managing a Filtered List
|
Lesson 3: Using Pivot Tables
Creating Pivot Tables
Modifying Pivot Tables
Grouping and Summarizing Data in a Pivot Table
Creating Interactive Pivot Tables for the Web
Database Functions
|
Lesson 4: Creating Charts
Creating a Chart Sheet
Creating an Embedded Chart
Comparing Chart Sheets with Embedded Charts
|
Lesson 5: Modifying Charts
Chart Types
Modifying Embedded Charts
Adding and Deleting Chart Items
Moving and Sizing Chart Items
|
|
Lesson 6: Formatting a Chart
Formatting Chart Text
Formatting Labels
Formatting the Chart
Printing a Chart Sheet
|
Lesson 7: Using Graphic Objects
Adding Graphic Objects
Formatting Graphic Objects
Using Graphic Objects to Enhance Worksheets and Charts
| |
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Excel 2000 - Level 1
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Excel 2000 - Level 2 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5960
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|