Microsoft Excel
Who we are and what we do
Excel training can be delivered in-house at your offices, online via the web or by attending one of our Public (open) courses held in St Albans and Milton Keynes.
Which course do I need?
Should you or your team need help choosing the best level of training, our FREE skills assessment can be used or alternatively, speak to one of our advisors who will discuss the best options for you. If you are organising training for more than 5 people, speak to us about our FREE skills assessment PORTAL which allows you to view all your staff's results in one place, saving hours of admin time.
1-day courses
Foundation
Learn how to:
- Create spreadsheets from scratch
- Create basic formulae
- Apply print settings and create basic Charts
- Apply formatting to enhance presentation
Intermediate
Learn how to:
- Create PivotTables & Charts
- Analyse lists of data
- Create popular functions such as VLOOKUP, IF & SUMIF
Advanced
Learn how to:
- Create a variety of advanced statistical, logical and lookup functions
- Advanced PivotTable feature
- Use data tools to 'clean up' data lists
- Apply worksheet/workbook protection
- Apply data entry rules and restrictions
- Create multiple conditional formats
- Record a basic macro
Looking for something more advanced?
Whether you need training in VBA programming, Financial Modelling or PowerPivots, our suite of more advanced Excel courses will help. If you can't find what you are looking for, please contact us and we’ll be happy to help.
Something more advanced
PowerPivots
This course is designed for those who wish to understand how to analyse and present their data more efficiently by using PowerPivots.
Run In-House View OutlineExpert
This course is an advanced course and is aimed at those who use Excel regularly. It covers features and functions that tackle issues arising from complex spreadsheet models.
Run In-House View OutlineFinancial Modelling
This course is aimed at those that are required to build financial models as part of their day to day roles. You will learn how to build and use financial models based on best practice modelling principles.
Run In-House View OutlineVBA Stage 1
This course is designed to introduce the macro recorder and the VBA editing environment.
Run In-House View OutlineVBA Stage 2
This course is designed for those who wish to further develop their understanding of VBA gained from attending our Stage 1 course.
Run In-House View OutlineVBA Stage 3
This course is designed for those who wish to gain a practical approach to developing VBA solutions and consolidate their existing knowledge.
Run In-House View OutlineOur Excel Trainers
Why Choose Us
- Expert Trainers
- Accredited Learning Provider
- Cyber Essentials Certified
- Post-Course Lifetime Support
We love:
- Helping people learn
- Helping people to save time
- Helping people to be more productive
- Helping businesses save money
Sprint Sessions
Create your own package to suit your teams' needs from our suite of options below.

Overview
To become an effective user of Excel and to get the best out of your data and calculating totals this course is for you.
The magic of Excel lays in the use of formulas and how to fix or leave them moveable.
During this hands on session, you will gain valuable skills about how to create different types of calculations using formulae and functions.
Required knowledge or experience:
This session is designed for new users to Excel spreadsheets or for those who would like a refresher on the basics. It is essential you have hands on practice of using a computer and mouse.
Learn how to:
- Use arithmetical operations to create simple calculations including percentages
- Create simple formula using brackets
- Use quick functions to calculate the Total, Mean, Highest and Lowest of a range of data
- Use moveable and fixed cells in calculations
- Automatically fill a range of cells with a series of data
- Edit and interpret existing spreadsheet data

Group training
(up to 10 delegates)

1 to 1 training

Drop-ins

Online Sessions
(Virtual Classroom)
For training taking place in your offices, all we need is a room with table and chairs and we look after the rest, even providing laptops and a projector should you not have spare IT equipment to use.
Our commitment to quality
We are an accredited training provider with the Learning and Performance Institute which gives you the assurance that we can conform to a professional Code of Practice.







