Excel 2010 Level 3

1 Day Course
Hands On
Code DEX10L3

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Hide all

Streamlining Workflow (6 topics)

  • Create a Macro
  • Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria
  • Update a Workbook's Properties
  • Modify Excel's Default Settings

Collaborating with Others (7 topics)

  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Administer Digital Signatures
  • Restrict Document Access

Auditing Worksheets (5 topics)

  • Trace Cells
  • Troubleshoot Errors in Formulas
  • Troubleshoot Invalid Data and Formulas
  • Watch and Evaluate Formulas
  • Create a Data List Outline

Analyzing Data (4 topics)

  • Create a Trendline
  • Create Scenarios
  • Perform What-If Analysis
  • Perform Statistical Analysis with the Analysis ToolPak

Working with Multiple Workbooks (4 topics)

  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links

Importing and Exporting Data (2 topics)

  • Export Excel Data
  • Import a Delimited Text File

Using Excel with the Web (3 topics)

  • Publish a Worksheet to the Web
  • Import Data from the Web
  • Create a Web Query

Structuring Workbooks with XML (2 topics)

  • Develop XML Maps
  • Import and Export XML Data

Prerequisites

To ensure your success, we recommend you first take the following courses or have equivalent knowledge: - Microsoft Office Excel® 2010 Level 1 - Microsoft Office Excel® 2010 Level 2

Course PDF

Print

Sections