Houston, Texas

San Antonio, Texas

Course Links

training schedule
  •  Houston
  •  San Antonio
training schedule
training schedule


training schedule
training schedule
training schedule





Microsoft® Office Excel 2003: Level 3

Training Course Content

Lesson 1: Streamlining Workflow

Topic 1A: Create a Macro
Topic 1B: Run a Macro
Topic 1C: Customize Access to Excel Commands
Topic 1D: Update a Workbook's Settings
Topic 1E: Modify Excel's Default Settings
Topic 1F: Adjust Macro Settings

Lesson 2: Collaborating with Others

Topic 2A: Protect Workbooks, Sheets, Cells
Topic 2B: Share a Workbook
Topic 2C: Set Revision Tracking
Topic 2D: Review Tracked Revisions
Topic 2E: Merge Workbooks
Topic 2F: Additional Protection Items
Topic 2G: Add Data Validation Criteria

Lesson 3: Auditing Worksheets

Topic 3A: Trace Cell Precedents
Topic 3B: Trace Cell Dependents
Topic 3C: Locate Errors in Formulas
Topic 3D: Locate Invalid Data and Formulas
Topic 3E: Watch and Evaluate Formulas

Lesson 4: Analyzing Data

Topic 4A: Create a Trendline
Topic 4B: Create Scenarios
Topic 4C: Perform What-If Analysis
Topic 4D: Develop a PivotTable Report
Topic 4E: Develop a PivotChart Report
Topic 4F: Review Analysis ToolPak
Topic 4G: Group and Outline Data

Lesson 5: Working with Multiple Workbooks

Topic 5A: Create a Workspace
Topic 5B: Consolidate Data
Topic 5C: Link Cells in Different Workbooks
Topic 5D: Edit Links

Lesson 6: Importing and Exporting Data

Topic 6A: Export to Microsoft Word
Topic 6B: Import a Word Table
Topic 6C: Import Text Files

Lesson 7: Additional Features

Topic 7A: Formulas, Shortcuts, Tips and more.


Level 3 Course Summary: Students will automate basic Excel tasks through macros, use advanced analysis tools with more complex data sets, collaborate on worksheets in a team environment, and share Excel data with other applications.

Level 3 Prerequisites: To ensure your success, we recommend that you have experience with intermediate level formulas, charting, and data filtering. Students can obtain this level of skill through our Level 1 and 2 courses. Contact us to discuss if this level is right for you.

Delivery Method: Instructor led, group-paced, hands-on classroom training with activities. Additionally, manuals are provided for each student for after class reference.

Excel 2003 Course Outlines:
Level 1 - Fundamentals
Level 2 - Intermediate
Level 3 - Advanced
Level 4 - Exploring Macros
Level 5 - Advanced Macros & VBA


                                                         |   Home   |   Email Us   |   Privacy Notice   |   Site Map   |