The Knowledge Network
1510 Central Avenue
Albany, NY 12205
Phone (518)452-2675
Fax: (518)452-2872
Office Hours:
Mon-Fri 9:00am-6:00pm
learn@knowledgenetwork.org

Microsoft Excel 2003 - Level 3

Location: Colonie

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

Prerequisite(s) or equivalent knowledge: Excel 2003 - Level 1 & Excel 2003 - Level 2

Outline:

• Working with advanced formulas
  • Using names
  • Using decision-making functions
  • Creating nested functions
  • Using financial functions
     
• Lookups and data tables
  • Working with lookup functions
  • Using MATCH and INDEX
  • Creating data tables
     
• Advanced list management
  • Creating subtotals
  • Validating cell entries
  • Exploring database functions
  • Working with data forms
     
• Working with PivotTables and PivotCharts
  • Working with PivotTables
  • Rearranging PivotTables
  • Formatting PivotTables
  • Working with PivotCharts
     
• Exporting and importing
  • Exporting and importing text files
  • Exporting and importing XML data
  • Querying external databases
     
• Using analytical options
  • Working with Goal Seek and Solver
  • Working with the Analysis ToolPak
  • Working with scenarios
  • Working with views
     
• Working with macros
  • Running and recording a macro
  • Working with VBA code
  • Function procedures
     
• Interactive Web pages
  • Creating interactive Web spreadsheets
  • Publishing PivotTables on the Web
     
• Using SharePoint services
  • Document Workspaces