Microsoft® Office Excel® 2010: Level 3

Course Specifications

Course number: EXL-301
Course length: 1.0 day(s)

Performance-Based Objectives:

Upon successful completion of this course, students will be able to:

  • enhance productivity and efficiency by streamlining the workflow.
  • collaborate with other workbook users.
  • audit worksheets.
  • analyze data.
  • work with multiple workbooks.
  • import and export data.
  • integrate Excel data with the web.
  • structure workbooks with XML.

Course Content

Lesson 1: Streamlining Workflow

  • Topic 1A: Update Workbook Properties
  • Topic 1B: Create a Macro
  • Topic 1C: Edit a Macro
  • Topic 1D: Apply Conditional Formatting
  • Topic 1E: Add Data Validation Criteria

Lesson 2: Collaborating with Other Users

  • 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 Invalid Data and Formula Errors
  • Topic 3C: Watch and Evaluate Formulas
  • Topic 3D: Create a Data List Outline

Lesson 4: Analyzing Data

  • Topic 4A: Create a Trendline
  • Topic 4B: Create Sparklines
  • Topic 4C: Create Scenarios
  • Topic 4D: Perform a What-If Analysis
  • Topic 4E: Perform a Statistical Analysis with the Analysis ToolPak

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: Integrating Excel Data with the Web

  • Topic 7A: Publish a Worksheet to the Web
  • Topic 7B: Import Data from the Web
  • Topic 7C: Create a Web Query

Lesson 8: Structuring Workbooks with XML

  • Topic 8A: Develop XML Maps
  • Topic 8B: Import and Export XML Data