 |
Microsoft
Excel ’97 - Level 2 |
Course Description
|
This
course will take Excel users through some of the advanced
spreadsheet functions that Excel has to offer.
The database functions will be featured as well as advanced
charting and setting up and using macros.
There are a number of powerful features like the Scenario
Manager and Goal Seek that will be taught and will give the student
added proficiency with the program.
|
Course
Objectives
|
Ø
To help Excel users learn
the other powerful features that Excel has to offer.
Ø
Spreadsheets are great for
doing what-if analysis. See
how to use the Scenario Manager and the Goal Seek function to do the
what-if analysis.
Ø
This course will cover areas
of Excel that people may not commonly use but it may be the
functions that help to develop powerful spreadsheets and achieve
your goals.
Ø
There is a special section
on macros. Find out how macros easy it is to set up macros and they
can help performance within Excel spreadsheets.
|
|
Course
Length
|
Recommended
Prerequisites
|
|
1 day
|
No
prerequisites for this course.
A good working knowledge with Windows 95/98 would be
beneficial.
|
|
|
Table of Contents
I Showing Formula’s and Comments
A. Showing Formulas
B. Using Comments
II The Scenario Manager
A. The Concept
B. Using the Scenario Manger
III Goal Seeking
A. The Concept
B. Using Goal Seek
IV Using Named Ranges
A. The Concept
B. Creating Named Ranges
C. Applying Names to Formulas
V Advanced Worksheet Management
A. Using Paste Special
B. Hiding/Unhiding Rows and Columns
VI Databases
A. The Concept
B. Using a Data Form for List Creation
C. Sorting Data in a List
D. Finding Records
E. Filtering the Database
F. Data Subtotals
VII Using the Data Series Command
VIII Charts
A. Using the Chart Wizard
B. Editing a Chart
C. Adding data to an existing chart
IX Graphics for Worksheets
A. Activating the Drawing Toolbar
B. Using the Drawing toolbar
C. Moving & Sizing Objects
X Working with Macro’s
A. Macros Defined
B. Creating Command Macros
C. Running a Macro
D. Adding Macros as an Application Button
X Conditional Formatting
A. The Concept
B. Setting up Conditional Formatting
|
