Microsoft Excel 2010 Specialist

2 Day Course
Hands On
Official Microsoft Curriculum

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


Collapse all

Managing the Worksheet Environment (3 topics)

  • Navigate through a worksheet
  • Print a worksheet or workbook
  • Personalise environment by using Backstage

Creating Cell Data (3 topics)

  • Construct cell data
  • Apply AutoFill
  • Apply and manipulate hyperlinks

Formatting Cells and Worksheets (6 topics)

  • Apply and modify cell formats
  • Merge or split cells
  • Create row and column titles
  • Hide and unhide rows and columns
  • Manipulate Page Setup options for worksheets
  • Create and apply cell styles

Managing Worksheets and Workbooks (3 topics)

  • Create and format worksheets
  • Manipulate window views
  • Manipulate workbook views

Applying Formulas and Functions (6 topics)

  • Create Formulas
  • Enforce precedence
  • Apply cell references in formulas
  • Apply conditional logic in a formula
  • Apply named ranges in formulas
  • Apply cell ranges in formulas

Presenting Data Visually (4 topics)

  • Create charts based on worksheet data
  • Apply and manipulate illustrations
  • Create and modify images by using the Image Editor
  • Apply Sparklines

Sharing worksheet data with other users (2 topics)

  • Share spreadsheets by using Backstage
  • Manage Comments

Analysing and Organising Data (3 topics)

  • Filter data
  • Sort data
  • Apply conditional formatting


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