Microsoft Excel 2010 Expert

2 Day Course
Hands On
Official Microsoft Curriculum
Code DEX10MOSE

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

Modules

Hide 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

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