Excel 2003 Advanced

CW-052C Excel 2003 Advanced

Synopsis: Designed for the student who has the skills to work with large or multiple worksheets, this class presents advanced formulas, lookup and data tables, PivotTables, list management, analytical options, macros and interactive Web pages.

Prerequisite: Successful completion of Excel 2003 Intermediate class or equivalent experience.

Length of Course: Self-paced, average 12-18 hours per course

Required Text: Clackamas Community College custom courseware will be provided at the first class.

Chapter 1 Getting Started with Access Databases and Tables

  1. Working with advanced formulas
    1. Using names
    2. Using decision-making functions
    3. Creating nested functions
    4. Using financial functions

  2. Lookups and data tables
    1. Working with lookup functions
    2. Using MATCH and INDEX
    3. Creating data tables

  3. Advanced list management
    1. Creating subtotals
    2. Validating cell entries
    3. Exploring database functions
    4. Working with data forms

  4. Working with PivotTables and PivotCharts
    1. Working with PivotTables
    2. Rearranging PivotTables
    3. Formatting PivotTables
    4. Working with PivotCharts

  5. Exporting and importing
    1. Exporting and importing text files
    2. Exporting and importing XML data
    3. Querying external databases

  6. Using analytical options
    1. Working with Goal Seek and Solver
    2. Working with the Analysis ToolPak
    3. Working with scenarios
    4. Working with views

  7. Working with macros
    1. Running and recording a macro
    2. Working with VBA Code
    3. Function procedures

  8. Interactive Web pages
    1. Creating interactive Web spreadsheets
    2. Publishing PivotTables on the Web

  9. Using SharePoint services
    1. Document Workspaces