Microsoft Excel 2007 / 2010 Level 3

Course Aims:

This course is aimed at people who want expand their knowledge into some of the more advanced calculation and analytical capability of Microsoft Excel.

Course Pre-requisites:

Students who wish to attend this course must have a good knowledge of Excel 2007/2010 and be competent at working with basic formulas and functions, multiple sheets and multiple files.

Course Objectives:

On completion of this course delegates will be able to:

  • Manage and enhance large worksheets
  • Use Logical and Lookup functions
  • Set data restrictions using data validation
  • Use the Subtotal feature
  • Grouping information with Outline view

Course Content:

Introduction and Objectives

Using Logical, Lookup & Round Functions

  • Using the VLOOKUP/HLOOKUP Functions
  • Using IF, Nested Ifs, ISERROR, AND, OR & ROUND Functions

Using Range Names

  • Jumping to a Named Range
  • Assigning Names
  • Using Range Names in Formulas

Using Auditing Tools

  • Displaying the Auditing Toolbar
  • Displaying/Removing Dependent Arrows
  • Displaying/Removing Precedent Arrows
  • Removing Tracer Arrows
  • Tracing Cells Causing Errors

Working with Outlines

  • Applying, Expanding & Collapsing an Outline
  • Modifying & Clearing Outline Settings
  • Using Auto Outline

Using Data Validation & Subtotals

  • Validating Data
  • Creating a Custom Error Message
  • Removing a Data Validation
  • Creating Subtotals In a List


Using Conditional & Custom Formats

  • Applying, Changing, Adding & Deleting a Conditional Format


Using Worksheet Protection

  • Unlocking Cells In a Worksheet; Protecting & Unprotecting a Worksheet & Workbook, Setting Manual & Automatic Calculation

Creating/Revising PivotTables

  • Creating a PivotTable Report
  • Enhancing your Pivot Table
  • Adding & Selecting Fields
  • Refreshing a PivotTable Report
  • Adding, Moving, Deleting PivotTable Report Fields

Working with Advanced Filters and Database Functions

  • Use the Advanced Filter Feature to Display and Extract Data from Tables

Database Functions(Dsum, Daverage, Dcounta

Appendix – Custom Views

  • Creating, Displaying and Deleting Custom Views


Action planning

Review of Programme


Related Courses

Excel 2007/2010: Level 4

Microsoft® Certified Application Specialist: Using Microsoft® Office Excel 2007/2010

Dates available on arrangement

WWP Training Limited can also create this course for you on arrangement either at your workplace or at one of their locations.

Make Enquiry

Write A Review Of Microsoft Excel 2007 / 2010 Level 3

Make Enquiry Add To Wishlist
All prices include VAT where applicable