Excel 2003: Advanced

Course Outline

Duration: 1 Day

Prerequisites: Excel 2003: Intermediate or equivalent experience

Description: 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.

Course Content:

Unit 1: Working with advanced formulas

Topic A: Using names

Topic B: Decision-making functions

Topic C: Creating nested functions

Topic D: Using financial functions

Unit 2: Lookups and data tables

Topic A: Working with lookup functions

Topic B: Using MATCH and INDEX

Topic C: Creating data tables

Unit 3: Advanced list management

Topic A: Creating subtotals

Topic B: Validating cell entries

Topic C: Exploring database functions

Topic D: Working with data forms

Unit 4: Working with PivotTables and PivotCharts

Topic A: Working with PivotTables

Topic B: Rearranging PivotTables

Topic C: Formatting PivotTables

Topic D: Working with PivotCharts

Unit 5: Exporting and importing

Topic A: Exporting and importing text files

Topic B: Exporting and importing XML data

Topic C: Querying external databases

Unit 6: Using analytical options

Topic A: Working with Goal Seek and Solver

Topic B: Working with the Analysis ToolPak

Topic C: Working with scenarios

Topic D: Working with views

Unit 7: Working with macros

Topic A: Running and recording a macro

Topic B: Working with VBA code

Topic C: Function procedures

Unit 8: Interactive Web pages

Topic A: Creating interactive Web spreadsheets

Topic B: Publishing PivotTables on the Web

Unit 9: Using SharePoint services

Topic A: Document workspaces

Appendix A: Smart Documents

Topic A: Discussing smart documents

Appendix B MOS exam objectives maps

Topic A: Core exam objectives

Topic B: Expert exam objectives