| |
|
| |
Excel 97 - Level 3 Training Class
Course ID: 5978
|
|
| |
|
|
| |
|
|
| |
Excel 97 - Level 3 Training Seminar
Overview:
Students will learn the skills and concepts necessary to work with advanced features of Excel 97.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Customizing the work area
Working with existing toolbars
Creating a new toolbar
Creating and using styles
Creating templates
|
|
Lesson 2: Advanced formula construction
Nested functions
The IF function
The VLOOKUP function
Error handling and the Auditing features
|
Lesson 3: Pivot tables
Creating pivot tables
Working with pivot tables
Viewing pivot tables at different levels
|
Lesson 4: Multiple file linking
Working with workbooks
Linking individual cells
|
Lesson 5: Consolidating data and using analysis tools
Consolidating worksheets
Using the Goal Seeker and Solver utilities
Creating a scenario by using Scenario Manager
|
|
Lesson 6: Protect and display options
Using comments
Protecting the worksheet
Hiding information
Custom views
|
Lesson 7: Introduction to macros
Running a macro
Recording a macro
Viewing and editing VBA code
|
|
| |
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Excel 97 - Level 1
Excel 97 - Level 2
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Excel 97 - Level 3 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5978
| 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
|
|
| |
|
|
|
| |
| |
|
|
|
|