| Excel 97 Advanced
Level II |
 |
Course Length/Prerequisites
This one-day course requires Excel 97 Introduction or equivalent.
Who Should Attend?
This course is designed for personnel who are already using Excel 97
and who wish to increase their efficiency by using some of the more
advanced features of the product. Students who have experience using
Excel 97 — but who have no formal training in its use — should
consider taking the Excel 97 Fast Pace course.
Course Objectives
Upon completion of this hands-on workshop, students will be able to:
Course Content
Absolute and Relative References
Definitions and Use
Summary
Naming Ranges and Cells
Creating and Using Named Ranges
Using the Range Finder
Summary
Outlining
Definition and Use
Creating, Using and Deleting an Outline
Printing and Charting Summary Information
Copying Summary Information
Summary
Working with a List (Database)
Definitions
Creating a List
Guidelines For Using Lists
Editing a List Using the Data Form
Filtering Records
AutoFilter — Top Ten
Custom Filtering Criteria
Sorting
Summary
Summarizing Lists
Subtotals
Creating a Pivot Table
Modifying Pivot Tables
Insert a Calculated Field in a Pivot Table
Grouping Column/Row Headings
Sharing Lists
Working with an External Database File
Microsoft Query
Summary
COUNTIF and SUMIF Functions
Definitions and Use
Summary
Protection
Definitions
Protecting a Workbook File from Being Accessed
Protecting a Workbook
Protecting a Worksheet from Content Changes
Summary
Styles
Creating, Applying, Modifying and Deleting Styles
Copying a Style Between Workbooks
Changing the Normal Style
Summary
Templates
Templates Defined
Creating Templates
Using Templates
Editing Templates
Creating and Using Autotemplates
Other Autotemplates
Excel Supplied Templates
Summary
