Microsoft Excel 2007 Specialist

2 Day Course
Hands On
Official Microsoft Curriculum
Code DEX07MOSS

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

Modules

Hide all

Creating and Manipulating Data (5 topics)

  • Insert data by using AutoFill
  • Ensure data integrity
  • Modify cell contents and formats
  • Change Worksheet Views
  • Manage worksheets

Formatting Data and Content (4 topics)

  • Format worksheets
  • Insert and modify rows and columns
  • Format cells and cell content
  • Format data as a table

Creating and Modifying Formulas (8 topics)

  • Reference data in formulas
  • Summarize data using a formula.
  • Summarize data using subtotals.
  • Conditionally summarize data by using a formula
  • Look up data by using a formula.
  • Use conditional logic in a formula.
  • Format or modify text by using formulas.
  • Display and print formulas

Presenting Data Visually (6 topics)

  • Create and format charts
  • Modify charts
  • Apply conditional formatting
  • Insert and modify illustrations
  • Outline data
  • Sort and filter data

Collaborating and Securing Data (5 topics)

  • Manage changes to workbooks
  • Protect and share workbooks
  • Prepare workbooks for distribution
  • Save workbooks
  • Set print options for printing data, worksheets, and workbooks

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.

Additional Learning

The courses below may help you meet the knowledge level required to take this course.

Course PDF

Print

Sections