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 £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
London Bridge £299 + VAT
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
  • 552 reviews

Expanding your functions toolbox

• Using 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


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


Using What If Analysis

• Goal Seek

• Scenarios


Questions and answers


This course is also available as a private course. If you wish we can tailor the content for your team. Please contact us for more details.

You Might Like These Too

Microsoft Excel VBA

Price on quotation

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 £429 + 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 £179 + 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


"Very proficient trainer who was engaging and well prepared to answer questions"
Ecclesiastical
14th February - Microsoft Excel : Advanced

Latest Reviews



"Working through examples/practicing was really helpful"
AEG Europe
  • 14th February


"Very clear and thorough, didn't rush the examples. Came for Intermediate course and came back for Advanced 1 week later"
AXS
  • 31st January


"Great course. Lisa was really entertaining and made sure we understood everything before moving on something else. Really helpful !!"
Pollen And Grace
  • 31st January