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 of Microsoft Excel 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?

PRICES AND DATES FOR YOUR
MICROSOFT EXCEL 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
Aug 27, 2019
Birmingham Queensway
£199
Book Now
Sep 9, 2019
Leeds West One
£199
Book Now
Sep 9, 2019
Manchester Piccadilly
£199
Book Now
Sep 17, 2019
Tower Bridge
£199
Book Now
Sep 24, 2019
Bristol Easton BS5
£199
Book Now
Oct 21, 2019
London Victoria
£186
Book Now
Microsoft Excel Intermediate
Aug 28, 2019
Birmingham Queensway
£199
Book Now
Sep 10, 2019
Manchester Piccadilly
£199
Book Now
Sep 18, 2019
London Victoria
£199
Book Now
Sep 25, 2019
Bristol Easton BS5
£199
Book Now
Oct 23, 2019
Leeds West One
£186
Book Now
Microsoft Excel Advanced
Aug 29, 2019
Birmingham Queensway
£199
Book Now
Aug 29, 2019
London Victoria
£199
Book Now
Sep 11, 2019
Manchester Piccadilly
£199
Book Now
Sep 11, 2019
Leeds West One
£199
Book Now
Sep 19, 2019
Tower Bridge
£199
Book Now
Sep 26, 2019
Bristol Easton BS5
£199
Book Now
Microsoft Excel Professional
Aug 30, 2019
London Victoria
£199
Book Now
Sep 12, 2019
Leeds West One
£199
Book Now
Sep 19, 2019
Birmingham Queensway
£199
Book Now
Sep 20, 2019
Tower Bridge
£199
Book Now
Sep 27, 2019
Bristol Easton BS5
£199
Book Now
Oct 3, 2019
Manchester Piccadilly
£199
Book Now
Microsoft Excel VBA Introduction
Sep 2, 2019
Birmingham Queensway
£249
Book Now
Sep 4, 2019
Tower Bridge
£249
Book Now
Sep 16, 2019
Manchester Piccadilly
£249
Book Now
Sep 23, 2019
Bristol Easton BS5
£249
Book Now
Sep 25, 2019
London Victoria
£249
Book Now
Oct 9, 2019
Leeds West One
£249
Book Now
Microsoft Excel VBA Advanced
Sep 3, 2019
Birmingham Queensway
£249
Book Now
Sep 5, 2019
Tower Bridge
£249
Book Now
Sep 17, 2019
Manchester Piccadilly
£249
Book Now
Sep 26, 2019
London Victoria
£249
Book Now
Sep 27, 2019
Bristol Easton BS5
£249
Book Now
Oct 10, 2019
Leeds West One
£249
Book Now
Microsoft Excel Dashboards
Sep 2, 2019
Tower Bridge
£249
Book Now
Sep 4, 2019
Birmingham Queensway
£249
Book Now
Sep 18, 2019
Manchester Piccadilly
£249
Book Now
Sep 23, 2019
London Victoria
£249
Book Now
Oct 4, 2019
Bristol Easton BS5
£249
Book Now
Oct 7, 2019
Leeds West One
£249
Book Now
Microsoft Excel Business Intelligence (BI) - Reporting and Charting
Sep 3, 2019
Tower Bridge
£249
Book Now
Sep 5, 2019
Birmingham Queensway
£249
Book Now
Sep 19, 2019
Manchester Piccadilly
£249
Book Now
Sep 24, 2019
London Victoria
£249
Book Now
Oct 8, 2019
Leeds West One
£249
Book Now
Microsoft Excel for Accounting: Introduction
Sep 4, 2019
Leeds West One
£249
Book Now
Sep 10, 2019
Tower Bridge
£249
Book Now
Sep 11, 2019
Birmingham Queensway
£249
Book Now
Sep 25, 2019
Manchester Piccadilly
£249
Book Now
Oct 1, 2019
London Victoria
£249
Book Now
Microsoft Excel for Accounting: Advanced
Sep 5, 2019
Leeds West One
£249
Book Now
Sep 11, 2019
Tower Bridge
£249
Book Now
Sep 12, 2019
Birmingham Queensway
£249
Book Now
Sep 26, 2019
Manchester Piccadilly
£249
Book Now
Oct 2, 2019
London Victoria
£249
Book Now
Microsoft Excel for Accounting Fast Track
Sep 13, 2019
Manchester Piccadilly
£249
Book Now
Sep 20, 2019
London Victoria
£249
Book Now
Oct 2, 2019
Leeds West One
£249
Book Now
Oct 9, 2019
Tower Bridge
£249
Book Now

Want a later date?

Move to next Microsoft Excel section

DELEGATE FEEDBACK
FOR OUR MICROSOFT EXCEL COURSES

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
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
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
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
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
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
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
Adam Mercer
, Course:
Excel Intermediate
May 15 2019

"The trainer was great - I really enjoyed the course! Thanks"
  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
Alan Nicol
, Course:
Excel Bespoke
May 14 2019

"Keyboard shortcuts were very useful"
  Course rating of 3 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

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