Responsive image

Microsoft Excel Adv | Training Course

Automate and streamline your workflow to boost your productivity.
Gain time-saving hints and tips from professional Microsoft Excel experts.

SMALL COURSE SIZES   |   EXCEL EXPERTS   |   PROFESSIONAL TRAINING   |   LONDON LOCATION

Microsoft Excel Adv | Training Course

Course Takeaways
Course Info

Course Offering

Course Takeaways
Takeaways

What will I learn?

  • Use VLOOKUP functions
  • Formula auditing tools
  • Advanced Pivot tables
  • What If analysis
  • Reducing your audit risk
  • Free digital course assets
  • Free post-course helpdesk support
Course Takeaways
Learner Reviews

How good is the course?

  • Average Score 4.8 out of 5
  • Delicious lunch provided
  • Certificate of Achievement
  • 295 reviews

Expanding your functions toolbox

• Nesting formulas

• Using AND & OR

• VLOOKUP

• IFERROR/IFNA

• INDEX & MATCH


Reducing your audit risk

• Data validation

• Using Trace Precedents

• Using Trace Dependents

• Removing Arrows

• Error checking

• Evaluate Formula

Questions & answers

Effectively analysing your data

• Creating Pivot Tables

• Changing the look of your pivot

• Grouping your data

• Updating Pivot Tables with new data

• Filtering your data with a Slicer

• Linking slicers to more than one Pivot Table

• Using a timeline

• Creating a Pivot chart


What If Analysis

• Goal Seek

• Scenarios

Questions & answers

  Course Dates Venue   Price  
London Bridge £129 + VAT save £170
Online £149 + VAT save £150
London Bridge £179 + VAT save £120
Online £199 + VAT save £100
London Bridge £229 + VAT save £70
Online £299 + VAT

You Might Like These Too

Microsoft Excel VBA

from £349 + VAT

2 day course
Harness the power of VBA to manage large and variable amounts of data.

Learn best practice for writing and editing VBA code and improve your data's usability.

  • Understand the VBA environment
    Debug code using VB editor
    Objects and Collections
    Message boxes, input boxes, forms
    Code execution and fix errors

Power BI Business Analytics

from £349 + VAT

2 day course
Learn to analyse and publish data from a variety of sources using this powerful software.

Create boards, visualisation and dashboards that can then be published.

  • Connect to data sources
    Use power query to transform data
    Create dashboards with tables/charts
    Perform custom calculations
    Create, format and shape reports

Microsoft Powerpoint Intro

from £129 + VAT

1 day course
Quickly and easily create professional, engaging presentations using Powerpoint.

Learn tips and tricks from experts to make your presentations shine.

  • Understand the interface
    Create the perfect slide
    Work with text
    Visual enhancements
    Transitions, animations and notes

What Do Our Learners Think About Our Courses?

Tom Interview
Premiere Intro

 Learner Stories

Tom's Course

Tom works in Internal Communications for an NHS service provider. Listen to his experience about attending our online Adobe Premiere Intro course.

Meija Interview
Social Media Marketing Intro

 Learner Stories

Meija's Course

Meija works for the MOD, in marketing and communications and here tells us about attending her online Social Media Marketing course with Alice.

Katie Interview
Social Media Marketing Intro

 Learner Stories

Katie's Course

Katie works for the Ministry of Defence as a Digital Content Editor and here tells us about attending her online Social Media Marketing course with Kirsty.



"Kevin had a great tone of voice, which made him sound excited to be talking about Excel, and that helped make it interesting. We also had a good pace, moving fast so we learnt a lot in a short amount of time"
Aco Technologies PLC
4th June - Microsoft Excel : Advanced

Latest Reviews



"I found Kevin approachable and he always kept checking that we were all OK and when not he went through things again and also tried to share screens etc. The time flew past . Which is a great indication the content was relevant and interesting."
ACO Technologies
  • 4th June


"Answering Questions to all Excel Questions not just questions relevant to the course. Also answering questions on other systems which have Excel working behind the scenes such as Power BI"
Ed Broking Limited
  • 9th April


"Pacing, tailoring the course to the participants and flexibly adding and amending the content according to people's interests and needs."
Class Publishing
  • 9th April
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients