Microsoft® Office Excel 2007: Level 3

Training Course Content

Lesson 1: Streamlining Workflow

Topic 1A: Create a Macro

Topic 1B: Edit a Macro

Topic 1C: Apply Conditional Formatting

Topic 1D: Add Data Validation Criteria

Topic 1E: Update a Workbook's Properties

Topic 1F: Modify Excel's Default Settings

Lesson 2: Collaborating with Others

Topic 2A: Protect Files

Topic 2B: Share a Workbook

Topic 2C: Set Revision Tracking

Topic 2D: Review Tracked Revisions

Topic 2E: Merge Workbooks

Topic 2F: Administer Digital Signatures

Topic 2G: Restrict Document Access

Lesson 3: Auditing Worksheets

Topic 3A: Trace Cells

Topic 3B: Troubleshoot Errors in Formulas

Topic 3C: Troubleshoot Invalid Data and Formulas

Topic 3D: Watch and Evaluate Formulas

Topic 3E: Create a Data List Outline

Lesson 4: Analyzing Data

Topic 4A: Create a Trendline

Topic 4B: Create Scenarios

Topic 4C: Perform What-If Analysis

Topic 4D: Analysis ToolPak Overview

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 Excel Data

Topic 6B: Import a Delimited Text File

Lesson 7: Using Excel with the Web

Topic 7A: Publish a Worksheet to the Web

Topic 7B: Import Data from the Web

Topic 7C: Create a Web Query

Additional Items

Formulas, Shortcuts, XML Overview, Tips, etc.

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 2007 Training Class Outlines:
Level 1 - Fundamentals
Level 2 - Intermediate
Level 3 - Advanced
Level 4 - Introduction to Macros