Excel 2003: Level 3

Class Outline:

Description:
This course covers advanced-level features and functions of Excel 2003. Students will learn how to create nested functions, export/import data, perform what-if analyses, use the Goal Seek and Solver utilities, record and run macros, and use SharePoint services. This course is approved courseware for Microsoft Office Specialist certification.

Table of Contents:

Unit 1 : Working with advanced formulas
Topic A: Using names
A-1: Defining names
A-2: Using the Create Names command
A-3: Using the Apply Names command
Topic B: Using decision-making functions
B-1: Using the IF function
B-2: Using the SUMIF function
Topic C: Creating nested functions
C-1: Using nested IF functions
C-2: Using the ROUND function
Topic D: Using financial functions
D-1: Using the PMT function

Unit 6 : Using analytical options
Topic A: Working with Goal Seek and Solver
A-1: Using Goal Seek to solve for a single variable
A-2: Using Solver to solve for multiple variables
Topic B: Working with the Analysis ToolPak
B-1: Installing the Analysis ToolPak
B-2: Using the Sampling analysis tool
Topic C: Working with scenarios
C-1: Creating scenarios
C-2: Switching among scenarios
C-3: Merging scenarios from another worksheet
Topic D: Working with views
D-1: Creating views
D-2: Switching among views