Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Excel Training Courses: All Versions & Skill Levels
Excel Training Courses: All Versions & Skill Levels
 

MICROSOFT EXCEL TRAINING COURSES

Your place for learning about spreadsheets

Training courses for Excel 2007 to 2016, delivered UK-wide in 11 Activia training centres or at your offices. Also online 24/7 to suit your needs.

Free Online Course for Subscribers

We're running a monthly prize draw for everyone who subscribes to our newsletters, with a FREE online course up for grabs. So subscribe now for your chance to win!


Sign Up
See Our Latest Reviews on TrustPilot:

Excel Training for all

Excel courses will show you how to take your skills to new levels.
Find out why you should use Activia to deliver your Microsoft Excel training.
The video lasts around one minute, so your time will be well spent!
[Note: you need to enable sound.]

Excel Courses Available

At Activia Training we have one of the largest ranges of Excel courses available, ensuring you can always find exactly what you are looking for, whether it's a standard course or a specialist course which covers specific applications of Excel.

Excel courses available:

  • Microsoft Excel Introduction
  • Microsoft Excel Intermediate
  • Microsoft Excel Advanced
  • Microsoft Excel Professional
  • Excel VBA Introduction
  • Excel VBA Advanced
  • Excel Dashboards
  • Excel Business Intelligence (BI)
  • Excel for Accounting: Introduction
  • Excel for Accounting: Advanced
  • Excel for Accounting Fast Track

We can also provide bespoke content which combines the modules you need from different courses.

Key Components of Excel Courses

Excel has expanded over the years, and now has many different features. Depending on your job role, you'll need to use Excel in different ways.
However, there are a number of functions that are popular across many job roles, for example:

  • Formatting
  • Functions and Formulas
  • Filtering and Sorting
  • Pivot Tables
  • Lookups
  • Macros

Versions Covered

Our courses cover the 2010, 2013, 2016 and Office 365 versions of Microsoft Excel.

Stop Press: New Excel for Accounting Courses

We are very pleased to announce the launch of THREE new Excel for Accounting course !

Excel for Accounting: Introduction teaches you about functions, formulas, grouping and protecting your data, and how to enhance your spreadsheets with charts. It also shows you how to use LOOKUPs.

Excel for Accounting: Advanced takes you to the highest level, starting with logical funtion, financial modelling and specialist financial functions, and moving on to custom charts, Macros, advanced Pivot Tables and LOOKUPs,

And if you already have a good knowledge of Excel up to Intermediate level, our Excel for Accounting: Fast Track course combines the second half of the Introduction course and the first half of the Advanced course, to take you through the "essentials" in a single day.

How Would You Like to Learn Microsoft Excel?

Classroom training

Classroom training

Classroom training is proven to give the best learning experience and knowledge retention. You have the benefit of a relaxed but professional learning environment, an experienced trainer and the opportunity to ask questions, so you are 100% sure you understand all the course content.

Online courses

Online courses

If your budget, and/or time, are limited, you can now choose the e-learning route: online courses at lower cost, and with the flexibility to study in your own time, at your own pace. The course content is exactly the same as we cover in the classroom, so you are still getting tried and tested Activia courses.

Want to see prices and options for delivery of your training?

Blended learning FREE E-learning with Classroom Courses

With our latest Microsoft Excel courses, when you attend a classroom session you get 12 months' access to a free online course, so you can reinforce the knowledge you have gained.
After the course, you will be emailed a sign-in link after you have provided course feedback and downloaded your attendance certificate.
This link gives you free access to our e-learning course for a whole year.
Note: These e-learning courses match exactly what you cover in class.
We hope you have fun, on the day of the course and with your reviewing and revising afterwards!

Move to next Microsoft Excel section

COURSE OUTLINES & LINKS

Browse the outlines and click for more details on each course

Microsoft Excel Introduction

Logo for Excel Training : Excel Introduction
COURSE OUTLINE     [Duration: one day]

  • Getting Started with Microsoft Excel
  • The Excel Interface
  • Microsoft Excel Basics
  • Editing your Workbook
  • Printing and Viewing your Workbook
  • Working with Charts in Excel

Click for FULL COURSE DETAILS

Microsoft Excel Intermediate

Logo for Excel Training : Excel Intermediate
COURSE OUTLINE     [Duration: one day]

  • Advanced File Tasks
  • Working with Functions and Formulas
  • Managing Tables in Microsoft Excel
  • Data Tools in Excel
  • Doing More with Charts in Excel
  • Sparklines
  • Excel Styles and Themes

Click for FULL COURSE DETAILS

Microsoft Excel Advanced

Logo for Excel Training : Excel Advanced
COURSE OUTLINE     [Duration: one day]

  • Grouping & Outlining and Subtotals
  • What-If Analysis
  • PivotTables
  • Charting Pivoted Data
  • Advanced Excel Tasks
  • Creating HLOOKUP and VLOOKUP Functions
  • Introduction to Macros in Excel

Click for FULL COURSE DETAILS

Microsoft Excel Professional

Logo for Excel Training : Excel Professional
COURSE OUTLINE     [Duration: one day]

  • Advanced Conditional Formatting
  • Using Form Controls and Templates
  • Advanced Lookup Functions
  • Advanced Functions in Excel
  • Advanced Pivot Table Tools
  • Introduction to User Defined Functions Using VBA

Click for FULL COURSE DETAILS

Microsoft Excel VBA Introduction

Logo for Excel Training : Excel VBA Introduction
COURSE OUTLINE     [Duration: one day]

  • Recording and Running Macros in Excel
  • Introduction to the Excel VBA Editor
  • Creating Procedures and Functions
  • Working with the Excel Object Model
  • Controlling Program Flow

Click for FULL COURSE DETAILS

Microsoft Excel VBA Advanced

Logo for Excel Training : Excel VBA Advanced
COURSE OUTLINE     [Duration: one day]

  • Advanced Procedures
  • Advanced Variables
  • Interacting with Office Applications
  • Debugging and Error Traps
  • Creating Custom User Forms
  • Workbook and Worksheet Events

Click for FULL COURSE DETAILS

Microsoft Excel Dashboards

Logo for Excel Training : Excel Dashboards
COURSE OUTLINE     [Duration: one day]

  • Introduction to Dashboards
  • Inserting Graphics for a Dashboard
  • Specialist Functions and Formulas
  • Dashboard Navigation
  • Preparing your Workbook's Layout and Structure
  • Using Excel Objects for Specialist Dashboard Views
  • Using Macros and VBA with Dashboards

Click for FULL COURSE DETAILS

Microsoft Excel Business Intelligence (BI) - Reporting and Charting

Logo for Excel Training : Excel Business Intelligence (BI)
COURSE OUTLINE     [Duration: one day]

  • Importing and Linking Data
  • Data Manipulation with Pivot Tables
  • Advanced Reporting Functions
  • Automating Reports with Controls
  • Advanced Charting Features

Click for FULL COURSE DETAILS

Microsoft Excel for Accounting: Introduction

Logo for Excel Training : Excel for Accounting: Introduction
COURSE OUTLINE     [Duration: one day]

  • Working with Functions and Formulas
  • Outlining, Grouping and Sub Totals
  • Protecting Your Spreadsheet
  • Presenting Data with Charts
  • Formatting Financial Data
  • Data Tools: Managing Your Data
  • Formula Auditing
  • LOOKUP Functions

Click for FULL COURSE DETAILS

Microsoft Excel for Accounting: Advanced

Logo for Excel Training : Excel for Accounting: Advanced
COURSE OUTLINE     [Duration: one day]

  • Logical and Error Functions
  • WhatIf Analysis & Financial Modelling
  • Specialist Financial Functions
  • Using Pivot Tables
  • More About Charts
  • Introduction to Macros
  • Advanced LOOKUP Functions
  • Advanced PivotTable Tools

Click for FULL COURSE DETAILS

Microsoft Excel for Accounting Fast Track

Logo for Excel Training : Excel for Accounting Fast Track
COURSE OUTLINE     [Duration: one day]

  • Formatting Financial Data
  • Data Tools: Managing Your Data
  • Formula Auditing
  • LOOKUP Functions
  • Logical and Error Functions
  • WhatIf Analysis & Financial Modelling
  • Specialist Financial Functions
  • Using Pivot Tables

Click for FULL COURSE DETAILS

Want to see prices and options for delivery of your training?

Move to next Microsoft Excel section

NEXT CLASS DATES

Microsoft Excel Introduction
Oct 22, 2019
Leeds West One
£199
Book Now
Oct 23, 2019
Manchester Piccadilly
£199
Book Now
Oct 29, 2019
Birmingham Queensway
£199
Book Now
Nov 4, 2019
Bristol Easton BS5
£199
Book Now
Nov 8, 2019
London Victoria
£199
Book Now
Nov 14, 2019
Tower Bridge
£199
Book Now
Microsoft Excel Intermediate
Oct 23, 2019
Leeds West One
£199
Book Now
Oct 24, 2019
Manchester Piccadilly
£199
Book Now
Oct 28, 2019
London Victoria
£199
Book Now
Nov 15, 2019
Tower Bridge
£199
Book Now
Nov 19, 2019
Birmingham Queensway
£199
Book Now
Dec 4, 2019
Bristol Easton BS5
£199
Book Now
Microsoft Excel Advanced
Oct 24, 2019
Leeds West One
£199
Book Now
Oct 31, 2019
Birmingham Queensway
£199
Book Now
Nov 6, 2019
Bristol Easton BS5
£199
Book Now
Nov 14, 2019
Manchester Piccadilly
£199
Book Now
Dec 12, 2019
Tower Bridge
£186
Book Now
Microsoft Excel Professional
Oct 31, 2019
Tower Bridge
£199
Book Now
Nov 1, 2019
Birmingham Queensway
£199
Book Now
Nov 8, 2019
Bristol Easton BS5
£199
Book Now
Nov 21, 2019
London Victoria
£199
Book Now
Dec 5, 2019
Leeds West One
£199
Book Now
Microsoft Excel VBA Introduction
Oct 30, 2019
Manchester Piccadilly
£249
Book Now
Nov 4, 2019
London Victoria
£249
Book Now
Nov 8, 2019
Bristol Easton BS5
£249
Book Now
Nov 18, 2019
Leeds West One
£249
Book Now
Nov 25, 2019
Birmingham Queensway
£249
Book Now
Nov 27, 2019
Tower Bridge
£249
Book Now
Microsoft Excel VBA Advanced
Oct 31, 2019
Manchester Piccadilly
£249
Book Now
Nov 5, 2019
London Victoria
£249
Book Now
Nov 19, 2019
Leeds West One
£249
Book Now
Nov 26, 2019
Birmingham Queensway
£249
Book Now
Nov 28, 2019
Tower Bridge
£249
Book Now
Dec 20, 2019
Bristol Easton BS5
£229
Book Now
Microsoft Excel Dashboards
Nov 6, 2019
London Victoria
£249
Book Now
Nov 20, 2019
Leeds West One
£249
Book Now
Nov 25, 2019
Tower Bridge
£249
Book Now
Nov 27, 2019
Birmingham Queensway
£249
Book Now
Dec 11, 2019
Manchester Piccadilly
£249
Book Now
Microsoft Excel Business Intelligence (BI) - Reporting and Charting
Oct 29, 2019
Manchester Piccadilly
£249
Book Now
Nov 7, 2019
London Victoria
£249
Book Now
Nov 21, 2019
Leeds West One
£249
Book Now
Nov 26, 2019
Tower Bridge
£249
Book Now
Nov 28, 2019
Birmingham Queensway
£249
Book Now
Microsoft Excel for Accounting: Introduction
Oct 22, 2019
Birmingham Queensway
£249
Book Now
Nov 5, 2019
Manchester Piccadilly
£249
Book Now
Nov 13, 2019
London Victoria
£249
Book Now
Nov 26, 2019
Leeds West One
£249
Book Now
Dec 3, 2019
Tower Bridge
£249
Book Now
Microsoft Excel for Accounting: Advanced
Oct 24, 2019
Tower Bridge
£249
Book Now
Nov 6, 2019
Manchester Piccadilly
£249
Book Now
Nov 14, 2019
London Victoria
£249
Book Now
Nov 27, 2019
Leeds West One
£249
Book Now
Dec 5, 2019
Birmingham Queensway
£249
Book Now
Microsoft Excel for Accounting Fast Track
Nov 13, 2019
Leeds West One
£249
Book Now
Nov 20, 2019
Tower Bridge
£249
Book Now
Dec 6, 2019
Manchester Piccadilly
£249
Book Now
Dec 11, 2019
London Victoria
£249
Book Now

Want a later date?

Move to next Microsoft Excel section

DELEGATE FEEDBACK

AVERAGE REVIEW: 4.7 out of 5  BASED ON 1,990 REVIEWS
Simon Walker
, Course:
Excel for Accounting: Advanced
Jul 22 2019

"Well run course with good training resources"
  Course rating of 4 stars
Rachael Longley
, Course:
Excel Advanced
Jul 19 2019

"One on one training delivered was useful, as the trainer answered some questions that i had."
  Course rating of 3 stars
Sian Egdell
, Course:
Excel Intermediate
Jul 18 2019

"Great teacher very knowlegable "
  Course rating of 4 stars
Alice Plunkett
, Course:
Excel Intermediate
Jul 17 2019

"The course was very useful and informative. Steve was lovely, and clearly had a huge depth of knowledge. His ability to teach everyone with different objectives, and keep the course interesting was very good."
  Course rating of 4 stars
Stacey Taylor
, Course:
Excel Intermediate
Jul 17 2019

"Trainer was friendly and energetic and very knowledgable."
  Course rating of 4 stars
Michelle Howarth
, Course:
Excel Introduction
Jul 16 2019

"Was well managed and presented"
  Course rating of 3 stars
Veronika Kozielova
, Course:
Excel Professional
Jul 15 2019

"I was very happy with teachers ability to explain complex topics covered by professional course."
  Course rating of 4 stars
Alison Hewitt
, Course:
Excel Advanced
Jun 26 2019

"Jamie is an excellent trainer, not only does he clearly have an in depth knowledge of his subject area but he presents information in a clear and concise way and is able to answer any and all questions."
  Course rating of 4 stars
Louise Fisher
, Course:
Excel Bespoke
Jun 25 2019

"Fantastic course was able to understand and follow everything"
  Course rating of 4 stars
Indu Rehal
, Course:
Excel Introduction
Jun 25 2019

"Trainer was very good and very welcoming"
  Course rating of 3 stars
Samantha Matthews
, Course:
Excel Intermediate
Jun 25 2019

"Enjoyed the course. Jamie was very easy to understand and I came away with lots of helpful material he had created"
  Course rating of 3 stars
Jazmin Francis
, Course:
Excel Intermediate
Jun 18 2019

"Steve was great! Asset to the company! "
  Course rating of 4 stars
Natasha Gajadhar
, Course:
Excel Intermediate
Jun 11 2019

"Really enjoyed the course our trainer was brilliant! "
  Course rating of 4 stars
Laura Repton
, Course:
Excel Intermediate
Jun 4 2019

"It was useful to have a small group as the trainer could answer individual questions and tailor his training to our needs."
  Course rating of 3 stars
Vicki Whitmore
, Course:
Excel Advanced
May 30 2019

"Great trainer, enjoyed the day. "
  Course rating of 4 stars
Jo Pakenham
, Course:
Excel Advanced
May 24 2019

"I really enjoyed the training course and thought the trainer had extensive knowledge of excel. "
  Course rating of 4 stars
Catherine Kay
, Course:
Excel Advanced
May 24 2019

"Fantastic trainer, one of the best I have met. Calm, welcoming, super-knowledgeable."
  Course rating of 4 stars
Mary Garavan
, Course:
Excel Bespoke
May 22 2019

"Excellent service, super office support and trainers were brilliant"
  Course rating of 4 stars
Jade Babet
, Course:
Excel Intermediate
May 21 2019

"excellent engaging trainer"
  Course rating of 4 stars
Joe Parker
, Course:
Excel Intermediate
May 15 2019

"I big thank you to the trainer who was excellent"
  Course rating of 3 stars
Christopher Leslie
, Course:
Excel Intermediate
May 15 2019

"Very good. Nice environment. Easy to get to."
  Course rating of 4 stars
Annika Rose Dixon
, Course:
Excel Intermediate
May 15 2019

"Really enjoyed the course - nice insight and well tailored to the group of mixed abilities"
  Course rating of 4 stars
Adam Mercer
, Course:
Excel Intermediate
May 15 2019

"The trainer was great - I really enjoyed the course! Thanks"
  Course rating of 4 stars
Alan Nicol
, Course:
Excel Bespoke
May 14 2019

"Keyboard shortcuts were very useful"
  Course rating of 3 stars
Thomas Whitaker
, Course:
Excel Advanced
May 9 2019

"The course detail and reference guide from Jamie (trainer) was very useful."
  Course rating of 4 stars
Julie Naylor
, Course:
Excel Advanced
May 9 2019

"Really enjoyed the course and found the trainer very knowledgable"
  Course rating of 4 stars
Louise Davis
, Course:
Excel Advanced
May 9 2019

"Jamie was brilliant. Relaxed attitude and he went through what he was asking of us, with us."
  Course rating of 4 stars
Thomas Whitaker
, Course:
Excel Advanced
May 9 2019

"The additional course detail and reference guide from Jamie (trainer) was very useful."
  Course rating of 4 stars
Nick Capsey
, Course:
Excel Advanced
May 8 2019

"Very good course and conducted very well by Dave "
  Course rating of 4 stars
Chloe Eggerton
, Course:
Excel Advanced
May 8 2019

"Dave was a very knowledgeable enthusiastic instructor who guided all students through the course, catering for all attendees ability's in a calm friendly manor. "
  Course rating of 5 stars
Mathew Andrew Benton
, Course:
Excel Advanced
May 8 2019

"A good course, very informative and learnt a lot of new features and skills."
  Course rating of 4 stars
Sarah Wells
, Course:
Excel Advanced
May 7 2019

"The trainer was lovely."
  Course rating of 4 stars
Ravinder Dhillon
, Course:
Excel Bespoke
May 3 2019

"Thank you and a big thank you to the Trainer for all the help."
  Course rating of 4 stars
Helen Askew
, Course:
Excel Advanced
May 2 2019

"Excellent course and delivery."
  Course rating of 4 stars
Mathew Andrew Benton
, Course:
Excel Intermediate
Apr 26 2019

"useful and informative"
  Course rating of 4 stars
Justin Matthews
, Course:
Excel Advanced
Apr 25 2019

"Great delivery of the course, would use Activia again for training purposes."
  Course rating of 3 stars
Lorna Vince
, Course:
Excel Intermediate
Apr 24 2019

"Generally found the course very interesting - just need to practice using what was learnt"
  Course rating of 4 stars
Rebecca McEvoy
, Course:
Excel Intermediate
Apr 16 2019

"Dave was an EXCELLENT trainer, I cannot praise him enough."
  Course rating of 5 stars
Rachel Sutherland
, Course:
Excel Bespoke
Apr 12 2019

"Very professional trainer (Dave) was very engaging and explained things very clearly. Made it enjoyable!"
  Course rating of 4 stars
Via Bunn
, Course:
Excel Bespoke
Apr 12 2019

"I feel that I learned a lot of the stuff I needed to, the tutor was great"
  Course rating of 4 stars
Kathleen Ingles
, Course:
Excel Professional
Apr 10 2019

"Jamie was very helpful and knowledgeable , would definitely recommend to others!"
  Course rating of 4 stars
Susanne Fletcher
, Course:
Excel Introduction
Apr 10 2019

"Excellent trainer. Very patient and helpful."
  Course rating of 4 stars
AMANDA HEYWOOD
, Course:
Excel Introduction
Apr 10 2019

"GREAT COURSE REALLY ENJOYED IT"
  Course rating of 4 stars
Christopher Jones
, Course:
Excel Bespoke
Apr 8 2019

"Dave taught at a good pace and was thorough in explaining the subjects."
  Course rating of 4 stars
Via Bunn
, Course:
Excel Bespoke
Apr 8 2019

"Dave explained the whole course very well and helped when it was needed."
  Course rating of 5 stars
Emma Holmes
, Course:
Excel Bespoke
Apr 8 2019

"Dave was lovely and very helpful - he even took the time to go through all queries we had and help us with existing problems we had within our work"
  Course rating of 4 stars
Laavannya Paramanathan
, Course:
Excel Advanced
Apr 4 2019

"The trainer was very helpful and knowledgeable about the course content, and could answer any questions asked. "
  Course rating of 1 stars
Carly Dale
, Course:
Excel Intermediate
Apr 2 2019

"great training course. Gave me my confidence back in excel"
  Course rating of 4 stars
Samantha Care
, Course:
Excel Bespoke
Mar 29 2019

"Instructor was fab!"
  Course rating of 3 stars
Simon Oshea
, Course:
Excel Advanced
Mar 28 2019

"Thanks very much for great tutors."
  Course rating of 5 stars
Bushra Raj
, Course:
Excel Intermediate
Mar 27 2019

"A good interactive course. The trainer was helpful."
  Course rating of 3 stars
Paul Taylor
, Course:
Excel Advanced
Mar 27 2019

"The trainer Dave was extremely friendly, professional, knowledgeable and committed to a high standard of delivery."
  Course rating of 5 stars
Pamela Ring
, Course:
Excel Advanced
Mar 21 2019

"I would recommend Tony, our instructor. He is patient, friendly and knows his materials thoroughly."
  Course rating of 5 stars
Gail Izzard
, Course:
Excel Bespoke
Mar 19 2019

"The trainer Steve was excellent. He gauged the mood and level of the delegates understanding and knowledge very well. We got a lot out of the day and each one of us felt it was very useful. "
  Course rating of 5 stars
Michelle McGrath
, Course:
Excel Bespoke
Mar 15 2019

"Really interesting and I learnt alot. Thanks"
  Course rating of 5 stars
Angela Ward
, Course:
Excel Intermediate
Mar 15 2019

"Tony, was an excellent trainer, explained things very clearly."
  Course rating of 5 stars

Want to see prices and options for delivery of your training?

Move to next Microsoft Excel section

GENERAL INFORMATION

What we do, and how we work, to make sure you get the most from the courses you attend
Blended learning

FREE Online Revision

With our latest Microsoft Excel courses, you get free online revision for 12 months after your class so you can reinforce the knowledge you have gained.
Access is simple: go to www.activia.co.uk/login/ and log in using your email address. This will give you free access to our e-learning revision modules, which match exactly with what you cover in class.
We hope you have fun, on the day of the course and with honing your knowledge afterwards!

Larger Class Sizes for Microsoft Excel

On our Public courses, you benefit from our maximum class sizes of only 8 delegates. (Actually, it's often less.)

But if you want training for larger groups at your offices, we can deliver exactly the same content (though with a little less interactivity) for classes of up to 18 delegates, provided they have their own PCs or laptops. You will still have the exercises to download, and the same access to free e-learning revision, after the course.

These "large class" courses are great if you need a lot of people to be trained in a short space of time, and the lower cost per delegate allows you to get more people upskilled within a limited budget.

[Note: Bespoke options are not available for these courses.]

If you'd like to find out more, please get in touch to discuss.

Excel Training at All Levels

If you want great training in Microsoft Excel, you need look no further. Our courses start at Introduction level, and go right through to Advanced VBA. We also have specialist courses on Dashboards and Business Intelligence for those who need them.

We have scheduled public (open) classes running at all our UK centres, or can run a private (closed) class for you at your offices, all at excellent prices. If you want a course tailored to your own needs, we do this at no extra charge.

And if your time or budget dictate that you want to learn online, then we have e-learning which covers all four main levels of training.

All this at our great low prices too: so as we say, you need look no further!

Free Tools from Activia

With Activia, you can check your skill level with our unique, free Test Your Skills tool, which ensures you book on the correct course.   This is invaluable when putting together training programmes or bespoke courses for numbers of delegates.

You can also build your own Microsoft Excel course using our great, free Bespoke Course Creator to suit your own or your company project requirements, including just the subjects you want to learn.



GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

Stay in touch
          TrustPilot
CPD
ILM
ISO9001


Back to top
Site Cookies
We have placed cookies on your device to help make this website better.

You can change your cookie settings in your browser. Otherwise, we’ll assume you’re OK to continue.

I'm fine with this