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

Your First Name:

Your Surname:

Your Email Address:


Hamburger menu
bookings:   0333 6000 111
service:       0333 6000 555
Microsoft Excel
Microsoft Excel


Online course to run and re-run at any time
Microsoft Excel Professional


Log In
Move to next Microsoft Excel section

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

About our online Microsoft Excel course

CPD accredited course

Note: this Microsoft Excel Professional course is CPD certified.
This means that not only has it been rigorously assessed in terms of content and quality, but it comes with a FREE CPD Certification certificate, as well as an Activia diploma of completion.

Who will benefitUsers with a solid understanding of, and experience with, Microsoft Excel 2007, 2010, 2013 or 2016 who want to increase their ability in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction, Intermediate and Advance courses.

What You Get
  • Launch price from just $29 (RRP $99 - see below)
  • SIX full modules in this course
  • CPD certified with downloadable certificate on completion
  • Buy the Enhanced course to get your own workbook and exercises
  • View the whole course, or just selected topics, over and over
  • Pay online and start learning in just five minutes

Read on to find out how our great new online courses can bring real improvements to your skills!

Move to next Microsoft Excel section
Add to cart

How many licenses do you want?           Please enter a number higher than zero
(Enter the number into the box and click Add to Cart)

Add to Cart
Add to Cart
Add to Cart
Want to Buy?
Buy Now
Already Purchased?
Log In

Microsoft Excel

Course Outline

MODULE 1: Advanced Conditional Formatting

This module contains:
  • Editing Standard Formatting Rules
  • Using Formulas in Conditional Formatting

MODULE 2: Using Form Controls and Templates

This module contains:
  • Using Form Controls
  • Creating Templates

MODULE 3: Advanced Lookup Functions

This module contains:
  • Using the Index Function
  • Using the Match Function
  • Using Index and Match Together
  • Using Index and Match with Array Formula
  • Using the Indirect Function

MODULE 4: Advanced Functions in Excel

This module contains:
  • Using Error Functions
  • Using Logical Functions
  • Using Array Formulas
  • Using Rounding Functions

MODULE 5: Advanced Pivot Table Tools

This module contains:
  • Importing Pivot Table Data
  • Calculated Fields in Pivot Tables
  • Showing Pivot Data as a Percentage
  • Creating Custom Pivot Tables Styles

MODULE 6: Introduction to User Defined Functions Using VBA

This module contains:
  • Creating a User Defined Function
  • Creating an Interactive Procedure
  • Create and Share a Function Add-in
Move to next Microsoft Excel section
SAVE MONEY! Get all 4 courses together
Includes Intro, Intermediate, Advanced & Professional courses
Diploma multi-pack: Full Excel Multi-Pack
Multi-course package. Four A1 packs in one
$279.00     $89.00     Click to add to cart
Enhanced multi-pack: Full Excel Multi-Pack
Four full Diploma courses PLUS downloadable workbook & exercises
$339.00     $116.00     Click to add to cart

Related Courses

Here are our other Microsoft Excel courses, so why not take a look, and see what you can learn!

Move to next Microsoft Excel section

How It Works

You can start learning in just 5 minutes, and here's how to do it:

  • Buy the course(s) of your choice, providing your email address as part of the process
  • You will be emailed an activation link which you should click to set up your training
  • Work through the course by viewing each module in turn
  • Complete the questions after each module and download your Diploma when you have finished
  • If you have purchased the Enhanced course:
    • Download the workbook and exercises
    • Use the workbook to follow the video demonstrations
    • Use the exercises to complete the Skill Sharpeners
    • Review and redo as often as you like
Return to top

Stay in touch

Back to top
Get your Attendance Certificate
Microsoft Courses
Business Skills Courses
Personal Development Courses
Our Training Centres
How to Contact Us
Information & Resources
Time Management
Communication Skills
Online Training FAQ
VIDEO: How to Use It
Time Management
Communication Skills
Building Relationships
Anger Management
Managing Your Stress
Free Microsoft Office Course
Microsoft Access
Microsoft Excel
Microsoft Outlook
Microsoft Powerpoint
Microsoft Project
Microsoft Word
Microsoft Access
Microsoft Excel
Microsoft Office (incl. 365)
Microsoft Outlook
Microsoft Powerpoint
Microsoft Project
Microsoft Publisher
Microsoft Visio
Microsoft Word
Crystal Reports
Performance Management
Management Skills
Supervision & Teams
Training & Coaching
Accounts and Finance
Project Management Essentials
PRINCE2® Project Management
HR and Recruitment
Train the Trainer
Presentation Skills
Sales Management
Negotiation Skills
Business Writing Skills
Minute Taking Made Easy
Professional Telephone Skills
Touch Typing
Customer Service
Receptionist Skills
Time Management
Communication Skills
Building Relationships
London Victoria (SW1) NEW
Tower Bridge (E1)
Bristol (BS5) NEW
Milton Keynes (MK9)
Reading (RG1)
Slough (SL1)
Birmingham (B4)
Leicester (LE1) NEW
Nottingham (NG1)
Manchester Piccadilly (M1) NEW
Leeds West One (LS1) NEW
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