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 Intermediate


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 Intermediate 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 basic understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to take their knowledge of the basic features further in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

What You Get
  • Launch price from just $29 (RRP $99 - see below)
  • SEVEN 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 File Tasks

This module contains:
  • Saving and File Management
  • Converting and Encrypting Files
  • File Properties and Digital Signatures
  • File Accessibility and Compatibility

MODULE 2: Working with Functions and Formulas

This module contains:
  • Formulas with Absolute References
  • Autosum Functions (SUM & AVERAGE)
  • IF and Nested Functions
  • Working with Named Ranges
  • Array Functions (SUMIF & AVERAGEIF)
  • Formula Auditing
  • Text Functions

MODULE 3: Managing Tables in Microsoft Excel

This module contains:
  • Creating Excel Tables
  • Working with Records and Filters
  • Advanced Filters

MODULE 4: Data Tools in Excel

This module contains:
  • Text to Columns
  • Flash Fill
  • Remove Duplicates
  • Data Validation
  • Consolidate

MODULE 5: Doing More with Charts in Excel

This module contains:
  • Trendlines
  • Error Bars
  • Working with Axis Options
  • Advanced Chart Formatting

MODULE 6: Sparklines

This module contains:
  • Creating Sparklines
  • Editing Sparklines

MODULE 7: Excel Styles and Themes

This module contains:
  • Working with Themes
  • Creating Custom Styles
  • Applying Cell Styles
Move to next Microsoft Excel section

Frequently Bought Together

These courses are frequently purchased together.
Includes Functions and Formulas, Tables, Data Tools, More Charts, Sparklines
(This Course)
$18.00   $51.00
Includes Grouping, What If, Pivot Tables, Lookups, Introduction to Macros
View the Course
$18.00   $51.00
Add Both to Cart
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
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
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