Back
Responsive image

Microsoft Excel Adv | Training Course

Gain the confidence to tackle complex challenges and scenarios in Excel.
Learn time-saving hints and tips from professional Microsoft Excel experts.

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

  Course Dates Venue   Price  
Online £149 + VAT save £150
London Bridge £149 + VAT save £150
Online £179 + VAT save £120
London Bridge £179 + VAT save £120
Online £199 + VAT save £100
London Bridge £199 + VAT save £100
Online £229 + VAT save £70
London Bridge £229 + VAT save £70
Online £249 + VAT save £50

Microsoft Excel Adv | Training Course

Course Takeaways
Course Info

Course Offering

Course Takeaways
Takeaways

What will I learn?

  • Expanded functions for advanced calculations
  • Minimise audit risk with data validation
  • Analyse data efficiently with Pivot Tables
  • What If Analysis with Goal Seek and Scenarios
  • Clever time saving techniques
  • 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
  • 409 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

You Might Like These Too

Microsoft Excel VBA

from £379 + 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.

  • Automate tasks with Macros
    Create custom functions and procedures
    Manipulate objects and properties
    Expressions, variables, and functions
    Working with forms and controls

Power BI Business Analytics

from £329 + VAT

2 day course
Learn to present and visualise data like a pro on this Power Bi course.

Master how to create interactive and visually appealing dashboards and reports.

  • Understand Power BI concepts and features
    Connect to various data sources easily
    Create visually appealing and interactive visuals
    Query and shape your data for analysis
    Generate comprehensive reports

Microsoft Powerpoint Intro

from £149 + VAT

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

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

  • PowerPoint interface and navigation
    Layouts and slide design
    Making text look great
    Using images, charts and graphs
    Mastering transitions and animations


"Trainer was really great at giving the information in a clear way! Really helpful staff!"
MediaLabGroup
24th April - Microsoft Excel : Advanced

Latest Reviews
Microsoft Excel : Advanced
"Lisa Griffin is so good in this and she is an excellent person and have huge knowledge in the subject. I learnt a lot today. It was a pleasure attending the course"
Lewisham Homes
  • 23rd November
Microsoft Excel : Advanced
"Great trainer, interesting and useful sessions, effective materials, lovely staff and venue"
NHS Resolution
  • 22nd July
Microsoft Excel : Advanced
"Very good at explaining what was being used and why it was being used as well as how it could be applied to the real world using great examples"
Project Centre
  • 24th June