Excel 2003: Power User

Course Outline

Duration: 1 Day

Prerequisites: Excel 2003: Intermediate or equivalent experience

Description: This course is designed to give experienced Excel users proficiency in how to use formulas, functions, arrays, and add-ins for manipulating and analyzing data.

Course Content:

Unit 1: Advanced formulas, functions, and arrays

Topic A: Text functions

Topic B: Information functions

Topic C: Using array formulas

Topic D: Labels

Unit 2: Advanced editing and formatting

Topic A: The Paste Special command

Topic B: The Go To Special dialog box

Topic C: Advanced formatting features

Unit 3: Advanced graphics

Topic A: Creating a custom chart

Topic B: Working with pictures

Unit 4: Analyzing and sharing information

Topic A: Using add-ins

Topic B: Solver models and reports

Topic C: Statistical analysis tools

Topic D: Embedding and linking

Unit 5: Advanced customization

Topic A: Custom lists

Topic B: Changing default settings

Topic C: Automating Excel