713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas

>
  
training schedule Course
 Schedules

Houston Schedule
>
 
 
San Antonio Schedule
>
  
 

>
>
>
 
 

Better Business Bureau

 

 

.


 

 

Microsoft® Office Excel 2003: Level 3

Training Course Content

Course Objective: 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.

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.

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.


Excel 2003 Course Outlines:

Excel Level 1 - Fundamentals of Excel
Excel Level 2 - Intermediate Functions and Features
Excel Level 3 - Advanced Tools and Collaboration Features
Excel Level 4 - Advanced Formulas and Functions
Excel Level 5 - Introduction to VBA Macros
Excel Level 6 - Advanced VBA Macros

   
   
     

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