Excel 2003 Training (Advanced)

Description:

This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, 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.

Outlines:

• Unit 1: Working with advanced formulas
  • Topic A: Using names
  • Topic B: Using 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: Microsoft Office Specialist exam objectives maps
  • Topic A: Specialist exam objectives
  • Topic B: Expert exam objectives

--------------

Please note that the material taught at some locations may differ slightly from the outline shown above. Please contact your local ExecuTrain office if you have any questions about specific course content.