Skip Ribbon Commands
Skip to main content

EK-084678 - Microsoft Office Excel 2010 Advanced, Level 3


Duration: 1 Day




Delivery Method:

Software Assurance Value:

Microsoft CPE:

Course Information

Course Description

​This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

Course Objectives


Course Audience

​Anyone with solid Excel 2010 knowledge who desires to utilize some of the more advanced tools and features of Excel 2010.

Course Outline

Streamlining Workflow

  • Update Workbook Properties
  • Create a Macro
  • Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria
Collaborating with Other Users
  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Administer Digital Signatures
  • Restrict Document Access
Auditing Worksheets
  • Trace Cells
  • Troubleshoot Invalid Data and Formula
  • Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline
Analyzing Data
  • Create a Trendline
  • Create Sparklines
  • Create Scenarios
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the
  • Analysis ToolPak
Working with Multiple Workbooks
  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links
Importing and Exporting Data
  • Export Excel Data
  • Import a Delimited Text File
Integrating Excel Data with the Web
  • Publish a Worksheet to the Web
  • Import Data from the Web
  • Create a Web Query
Structuring Workbooks with XML
  • Develop XML Maps
  • Import and Export XML Data

Course Prerequisites

​Before starting this course, students are recommended to take the Excel 2010 Level 2 course or have equivalent knowledge.

Course Schedule
This course is not scheduled yet.