Advanced Microsoft Excel 2003

Duration: 12 hours

Description: This course is designed for students who have experience in the basic concepts of Excel and would like a more thorough understanding of the advanced features. The class will cover scenarios, goal seeking, solver and data tables. In addition, they will work with views, sharing workbooks, report manager, auditing tools, macros and pivot tables.

Objective: To provide an understanding of the advanced features of Excel.

Course Content:

Consolidating Worksheets

Using Scenarios and Goal Seeking

Using Data Tables

Solving Problems

Using Auditing Tools

Working with Views

Sharing Workbooks

Importing and Exporting Data

VLOOKUP Function

HLOOKUP Function

If Function

Nested If Function

ISERROR Function

Using AND/OR with IF

Using the ROUND Function

Limit the Precision of Numbers

Creating / Revising Pivot Tables

Using Macros

Recording Macros

Editing Macros

Using Custom Toolbars and Buttons

Creating a Macro Button