Excel 97 User
Specialist
|
 |
Course Length/Prerequisites
This three-day course requires Windows 95 or Windows NT 4.0 Introduction
or equivalent experience. Knowledge of basic concepts such as the use
of folders and sub-folders for storing spreadsheets as well as moderate
typing skills are required.
Course Objectives
This course is designed for students who wish to prepare for the Excel
97 User Specialist exam. The User Specialist exam of the Microsoft Office
User certification program covers the following skills:
Create workbooks
Modify workbooks
Print workbooks
Format worksheets
Create and apply Ranges
Use functions
Use draw
Use charts
Save spreadsheets as HTML
Upon completion of this hands-on workshop, students will be able to
perform the required tasks listed above. Students who wish to achieve
certification in the MS Office User program will be prepared to challenge
the User Specialist exam.
Course Content
Getting Started
What is Excel?
Starting Excel
The Excel 97 Window
Worksheet versus Workbook
Moving around a Worksheet
Entering Data in a Worksheet
File Handling
Setting the Default File Location
Saving a Workbook
Closing a Workbook
Opening a Previously Saved Workbook
Creating a New Workbook
Saving in HTML Format
Creating a Hyperlink to Open Other Workbooks and Files
Working with Ranges, Columns and Rows
The Concept of a Range
Selecting Ranges
Sorting
Column Width and Row Height
Moving and Copying to Build a Worksheet
Using the Clipboard to Move and Copy
Copying to Adjacent Ranges Using the Fill Handle
Using Drag-and-Drop to Move and Copy
Inserting and Deleting Cells, Rows and Columns
Formatting a Worksheet
Types of Formatting
Alignment
Formatting Numbers and Dates
Formatting Characters (Font)
Borders and Patterns
Copying Cell Formats
Clearing Cell Formats and Contents
AutoFormats
Functions and Formulas
Functions Defined
The SUM Function
The Paste Function Button
The AVERAGE, MIN and MAX Functions
Using the Formula Palette
The NOW and TODAY Functions
IF Function
Absolute, Relative, and Mixed References in Formulas
Creating and Using Range Names in Formulas
Creating and Modifying Objects
Importing Graphics
Creating Graphics
Creating Charts
Parts of a Chart
Creating a Chart
Chart Type
Selecting Parts of a Chart
Moving, Sizing and Deleting Chart Items
Customizing Chart Items
Adding Drawn Items to a Chart
Printing Worksheets
Print Preview
Setting Printing Options
Printing
Improving Productivity
Searching for Files from the Open Dialog Box
Using AutoComplete
Using AutoCorrect
Using Split Screen and Freeze Panes
Using View|Zoom
Creating a Series with the Fill Handle
Adding Comments to Cells
Working with Toolbars
The Tools|Options Dialog Box
