Microsoft Excel 2010 Specialist

2 Day Course
Hands On
Official Microsoft Curriculum
Code DEX10MOSS

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

Modules

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

Prerequisites

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

Print

Sections