Excel 2002:
Power User

Topic-Level Outline

Days: 1

Prerequisites: Excel 2002: Advanced or equivalent experience

Unit 1 : Advanced formulas, functions, and arrays

Topic A: 0 Text functions

A-1: Using text functions

Topic B: Information functions

B-2: Using IS functions

B-3: Using the CELL function

Topic C: 0 Using array formulas

C-1: Using an array formula

Topic D: 0 Labels

D-1: Using labels in formulas

Unit 2 : Advanced editing and formatting

Topic A: 0 The Paste Special command

A-1: Copying formulas and values

A-2: Copying a validation

A-3: Applying a mathematical operation to copied data

A-4: Transposing rows and columns

A-5: Linking data

Topic B: 0 The Go To Special dialog box

B-1: Finding formulas that result in errors

B-2: Finding precedent and dependent cells

Topic C: 0 Advanced formatting features

C-1: Applying an AutoFormat

C-2: Applying conditional formatting

C-3: Merging styles

Unit 3 : Advanced graphics

Topic A: 0 Creating a custom chart

A-1: Creating a cone chart

A-2: Creating a B&W column chart

A-3: Creating a line-column chart

Topic B: 0 Working with pictures

B-1: Inserting clip art

B-2: Inserting a picture as a chart background

B-3: Creating a user-defined chart type

Unit 4 : Analyzing data

Topic A: 0 Using add-ins

A-1: Using the Conditional Sum Wizard

A-2: Using the Lookup Wizard

Topic B: 0 Solver models and reports

B-1: Saving a problem model

B-2: Loading a problem model

B-3: Creating an Answer report

Topic C: 0 Statistical analysis tools

C-1: Analyzing data covariance

C-2: Measuring correlation of data

C-3: Calculating a moving average

Unit 5 : Sharing information

Topic A: 0 Embedding and linking

A-1: Inserting an embedded object

A-2: Inserting a linked object

Topic B: 0 Working with other users

B-1: Sharing a workbook

B-2: Merging workbooks

B-3: Tracking changes in a workbook

Unit 6 : Advanced customization

Topic A: 0 Custom lists

A-1: Creating and using a custom list

A-2: Modifying a custom list

Topic B: 0 Changing default settings

B-1: Limiting iterations

B-2: Changing the default font and file location

B-3: Opening a file automatically

Topic C: 0 Automating Excel

C-1: Using the AutoRecover feature

C-2: Using the AutoCorrect feature

Topic D: 0 Arranging and splitting windows

D-1: Arranging windows

D-2: Splitting a window