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

MICROSOFT EXCEL ADVANCED

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

Already
purchased?

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

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: Grouping & Outlining and Subtotals

This module contains:
  • Outlining and Grouping Data
  • Using the Subtotals Tool

MODULE 2: What-If Analysis

This module contains:
  • Exploring Scenarios
  • Goal Seek and Data Tables
  • Using Solver

MODULE 3: PivotTables

This module contains:
  • Getting Started with PivotTables
  • Displaying Data in a PivotTable
  • Formatting a PivotTable
  • Using the Classic PivotTable Layout
  • Slicers

MODULE 4: Charting Pivoted Data

This module contains:
  • Getting Started with PivotCharts
  • Using the PivotChart Tools Tabs
  • Formatting a PivotChart

MODULE 5: Advanced Excel Tasks

This module contains:
  • Excel and Hyperlinks
  • Using Custom AutoFill Lists
  • Sharing Workbooks

MODULE 6: Creating HLOOKUP and VLOOKUP Functions

This module contains:
  • Using the VLOOKUP Function
  • Using the LOOKUP Function

MODULE 7: Introduction to Macros in Excel

This module contains:
  • Recording and Playing Macros
  • Copying and Deleting Macros
  • Visual Basic and Macros
Move to next Microsoft Excel section

Frequently Bought Together

These courses are frequently purchased together.
EXCEL ADVANCED
Includes Grouping, What If, Pivot Tables, Lookups, Introduction to Macros
(This Course)
$18.00   $51.00
EXCEL PROFESSIONAL
Includes Conditional Formatting, Form Controls, Advanced Lookups, Functions & Pivots
View the Course
$18.00   $51.00
BOTH COURSES
$35.00
Add Both to Cart
$35.00
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
          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