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  
London Bridge £129 + VAT save £170
London Bridge £149 + VAT save £150
Online £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
London Bridge £249 + VAT save £50
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
  • 458 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


"Friendly and informative"
OEUK
23rd April - Microsoft Excel : Advanced

Latest Reviews



"Easily explaining instructions and their purpose"
Hill Group UK
  • 23rd April


"The teacher somehow made excel fun! very personable and knowledgeable, put a lot of effort in to engage the room"
Hill Partnerships
  • 10th April


"- Good examples and shortcuts that were very useful."
All3Media
  • 10th April