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
London Bridge £179 + VAT save £120
Online £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
London Bridge £249 + VAT save £50
Online £279 + VAT save £20
London Bridge £279 + VAT save £20
Online £299 + VAT
London Bridge £299 + VAT
Online £299 + VAT

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
  • 453 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 £379 + 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


"Communication and explanation"
GGF
10th April - Microsoft Excel : Advanced

Latest Reviews
Microsoft Excel : Advanced
"Everything we went over was really useful! I hope to do more Media Training courses in the future"
Penguin Random House
  • 10th April
Microsoft Excel : Advanced
"I was worried the Excel course would be a bit dry, but Kevin made it really engaging and informative. I learnt a lot and found out some useful hacks and tools which will hopefully improve the speed of certain tasks. Thank you! The training centre as a whole was great, the food was fab too!"
Usborne Publishing Ltd
  • 10th April
Microsoft Excel : Advanced
"The course was a very good and Lisa was amazing and very patient with me. Appreciate the help."
United Living Group
  • 27th March