Manchester Office Tel:  0161 408 0435

London OfficeTel: 0203 693 3945 


In House Microsoft Excel Intermediate Training Course

Microsoft  Excel Training Courses


You will also learn how manage an Excel database including sorting, filtering and creating subtotals. You will learn to simplify formulas by creating and applying cell names as well as applying advanced charting techniques


This course package includes free Training Needs Analysis (TNA) for Microsoft Excel  using Gmetrix testing software to assess training  requirements. For more details, see our TNA page or call us 0161 408 0435.


Versions: 2007, 2010, 2013


Course Type: In- House, Instructor led.


Duration: 1 day


Target Audience

The target student for this course should be comfortable using a personal computer and Microsoft Windows . You should have some experience using Microsoft Excel, preferably our Microsoft Excel Introduction Training Course.


Course Content


(Content may vary depending on software version)

Module 1: Advanced Formula Tasks

Module 4: Sorting, Outlining and Grouping Data

Understanding Relative and Absolute Cell References

Using Sort and Filter

Using Multiple Cell References

Outlining Data

Using 3D References

Showing and Hiding Outline Details

Using Array Formulas

Grouping Data


Creating Subtotals

Module 2: Working with Named Ranges

Removing Outlining and Grouping

Understanding Named Ranges

Advanced Filtering

Defining Named Ranges


Editing Named Ranges


Deleting Named Ranges

Module 5: Managing Data

Using Named Ranges in Formulas

Consolidating Information


Removing Duplicates

Module 3: Using Advanced Functions

Configuring Data Validation

Using the PMT Function

Transposing Data

Using the FV Function

Converting Text to Columns

Using VLOOKUP and HLOOKUP Functions


Using IF, AND, OR Functions

Module 6: Charting Data


Creating Sparklines


Inserting Charts


Create a combination chart with a secondary axis


Add a Trend or Moving Average Line

Related Courses


In House Training Courses