Microsoft Office Excel 2003 Level 3
Start Date: November 12 2009
End Date: November 12 2009
Time: 9:00am - 4:30pm
Fee:
Venue:
McKimmon Conference and Training Center
1101 Gorman Street
Raleigh, NC  27695
919.515.2277
Course Overview:

Microsoft® Office Excel 2003 Level 3

Why you should attend:  This course covers advanced-level features and functions of Excel 2003. You 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.

Suggested Prerequisites:  Windows Introduction and Excel Basics or equivalent knowledge.

Attend and You Will Learn

Lesson 1: Working with Advanced Formulas

  • Using names
  • Using decision-making functions
  • Creating nested functions
  • Using financial functions

Lesson 2: Lookups and Data Tables

  • Working with lookup functions
  • Using MATCH and INDEX
  • Creating data tables

Lesson 3: Advanced List Management

  • Creating subtotals
  • Validating cell entries
  • Exploring database functions
  • Working with data forms

Lesson 4: Working with PivotTables and PivotCharts

  • Working with PivotTables
  • Rearranging PivotTables
  • Formatting PivotTables
  • Working with PivotCharts

Lesson 5: Exporting and Importing

  • Exporting and importing text files
  • Exporting and importing XML data
  • Querying external databases

Lesson 6: Using Analytical Options

  • Working with goal seek and solver
  • Working with the Analysis ToolPak
  • Working with scenarios
  • Working with views

Lesson 7: Working with Macros

  • Running and recording a macro
  • Working with VBA code
  • Function procedures

Lesson 8: Interactive Web Pages

  • Creating interactive Web spreadsheets
  • Publishing PivotTables on the Web
Schedule: