Excel 2003:
Power User

Topic-Level Outline

Days: 1

Prerequisites: Excel 2003: Advanced or equivalent experience

Unit 1 : Advanced formulas, functions, and arrays

Topic A: 0 Text functions

A-1: Using text functions

Topic B: 0 Information functions

B-1: Using IS functions

B-2: Using the CELL function

Topic C: 0 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: 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 and sharing information

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

Topic D: 0 Embedding and linking

D-1: Inserting an embedded object

D-2: Inserting a linked object

Unit 5 : 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 at startup

Topic C: 0 Automating Excel

C-1: Using the AutoRecover feature

C-2: Using the AutoCorrect feature

C-3: Applying smart tags to cells