0845 450 6120

Microsoft Excel Advanced 2010/2013

This Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.

Please note that this course covers both 2010 & 2013 versions


Special Offer   Multiple Delegate / Course Discounts Available - Contact Us for Details



Learning Objectives

  • At the end of this course you will have a complete understanding of the higher functions of Excel.
  • You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.


A sound working knowledge of Excel

Course Content

Using logical functions

Naming ranges
- Creating named ranges
- Using named ranges in formulas
The IF function (recap)
Creating nested IF functions
AND and OR functions
Combining logical functions

Working with lookups

The VLOOKUP function
The HLOOKUP function

Advanced list management

Using data validation
- Setting criteria for entry of text, values and dates
- Creating a dropdown list
Using database functions
- Setting up criteria

PivotTables and PivotCharts

Using the PivotTable Wizard
Rearranging PivotTables
Using the PivotTable toolbar
Creating PivotCharts
Using Slicers to manipulate PivotTables

Using analytical options

Using Goal Seek
Using the Solver add-in
Working with scenarios
- Creating and saving scenarios
- Viewing scenarios


Creating macros
Using the macro recorder
Viewing and editing macro VBA code

One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include