Microsoft Excel 2010 Advanced

Course Details

This Excel course is aimed at those who wish to gain an advanced understanding of Excel 2010 and learn how to use features such as Pivot Tables and Macros.

Our Microsoft Excel courses are delivered in over 50 locations nationwide. The course is accredited by Microsoft and includes all course materials, a manual and a certificate.

Course Contents


Grouping & Outlining and Subtotals

  • Outlining and Grouping Data
  • Using the Subtotals Tool

What-If Analysis

  • Exploring Scenarios 
  • Goal Seek and Data Tables 
  • Using Solver


  • Getting Started with PivotTables 
  • Displaying Data in a PivotTable 
  • Formatting a PivotTable 
  • Using the Classic PivotTable Layout 
  • Slicers

Charting Pivoted Data

  • Getting Started with Pivot Charts 
  • Using the PivotChart Tools Tabs 
  • Formatting a PivotChart

Advanced Excel Tasks

  • Excel and Hyperlinks
  • Using Custom AutoFill Lists 
  • Sharing Workbooks

Creating Lookup Functions

  • Using the VLOOKUP Function 
  • Using the LOOKUP Function

Introduction to Macros

  • Recording and Playing Macros
  • Copying and Deleting Macros 
  • Visual Basic and Macros


What are the prerequisites for this course?

We recommend having a good understanding of Microsoft Excel.

What am I provided on the course?

You will be provided with an official courseware folder, detailed user-friendly manual, pre/post course email support, refreshments and a certificate of completion.

Who will be instructing me?

You will be a taught by a qualified, knowledgeable instructor with years of experience in their field.

When should I arrive to the venue?

You should aim to arrive at 9am.

How can I contact you?

If you would like more information about any course please feel free to either contact us on 01159 031 029 or you can email us at