      |
Excel
2003 Advanced
Course
Length
Full
day
Prerequisites
Excel 2003
Introduction or equivalent experience
Course
Description
This
course is designed for the user interested in advanced features of
Excel. Users will learn how to link cells, sheets, and workbooks; sort,
filter, outline, and validate data. You will also learn how to use a
variety of Excel's functions, use the Goal Seek and Scenario Manager
features, create a series, create custom views, create macros, and use the Formula
Auditing toolbar.
Course Topics
-
Link individual cells and workbooks
-
Create a linking formula
-
Create a linking function for a multi-sheet range
-
Sort rows by one, two, three, and four columns
-
Sort using a custom sort order
-
Use a list to create a custom sort order
-
Outline a worksheet
-
Collapse and expand an outline
-
Ungroup an outline level
-
Use Auto Outline
-
Create subtotals and a grand total
-
Use the IF and Nested IF Functions
-
Use an AND condition and OR condition with the IF Function
-
Use the ROUND, LOOKUP, PMT, and DATE Functions
-
Use Goal Seek and Scenario Manager
-
Create a scenario summary report
-
Create a validation rule and a validation list
-
Trace precedent and dependent cells
-
Remove precedent and dependent arrows
-
Evaluate a formula
-
Use the Trace Error button and circle invalid data
-
Convert text to columns
-
Specify the macro security level
-
Create, run, and edit a macro
-
Edit
macro options
-
Create, edit, and delete a macro button on a worksheet
-
Add a
button to a toolbar and assign an existing macro
-
Add a
custom menu item and assign an existing macro
-
Delete
a macro
-
Create a database
-
Add new, find, edit, and delete database records
-
Use AutoFilter and specify custom AutoFilter criteria
-
Use the Advanced Filter command
-
Create a custom view
-
Create a list and a series
What
Participants Receive
Each participant
receives a guide containing step-by-step instructions
with practice exercises, and a
laminated reference card.
|
