Microsoft Excel 2010 Expert

2 Day Course
Hands On
Official Microsoft Curriculum

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


Collapse all

Sharing and Maintaining Workbooks (3 topics)

  • Apply workbook settings, properties, and data options
  • Apply protection and sharing properties to workbooks and worksheets
  • Maintain shared workbooks

Applying Formulas and Functions (4 topics)

  • Audit formulas
  • Manipulate formula options
  • Perform data summary tasks
  • Apply functions in formulas

Presenting Data Visually (5 topics)

  • Apply advanced chart features
  • Apply data analysis
  • Apply and manipulate PivotTables
  • Apply and manipulate PivotCharts
  • Demonstrate how to use the slicer

Working with Macros and Forms (2 topics)

  • Create and manipulate macros
  • Insert and manipulate form controls


This course has strict prerequisites – delegates should have already attended the relevant Levels 1, 2 and 3 courses or have equivalent knowledge. This course is NOT a fast track course for learning the exam material but a course for turning knowledge in to exam readiness.

Course PDF