Great Shelford, Cambridge / Online
1 day course
Please contact us for dates and pricing

This 1 day Microsoft Excel Expert training course is designed for users needing to extend their knowledge of formulae and functions to help them understand and interpret larger and more complex levels of data analysis. You may have previously attended our Excel Advanced Formulae and Functions course or already have a thorough knowledge of the common Excel functions.

Our trainers will guide you through the more complicated but informative formulas and uncover the hidden gems that will help you analyse sophisticated data and take your skillset to the next level.

By the end of this course you will be familiar with using more complex formulae such as MATCH, INDEX and OFFSET and new functions including XLOOKUP function, as well as producing more advanced charts to help you support higher levels of data analysis.

Course Outline

Functions

  • INDEX
  • MATCH
  • VLOOKUP / HLOOKUP / XLOOKUP
  • ROW / COLUMN / ADDRESS
  • OFFSET
  • INDIRECT
  • FORECAST
  • SWITCH
  • REPLACE
  • PMT
  • SUBTOTAL
  • SUMPRODUCT
  • FIND
  • DATEVALUE
  • VALUE

Array functions

  • FREQUENCY
  • TRANSPOSE

Tools

  • Data tables
  • Scenarios
  • Goal seeking
  • Conditional data validation
  • Forecast sheet

Charts

  • Waterfall
  • Funnel
  • Stock

Book This Course

Public Course Dates

This course is taught at our training centre in Cambridge.  Check our current available dates for this course below and register your place. Please note that payment is not made by the booking form below – Instead, you will be sent an invoice with instructions on how to pay and confirm your place shortly afterwards.

Company Group Training

We also provide group training for companies on dates that work for them. This can be done via our training centre, on-site or virtually. Please submit your details here for more information.

Online Training

This course is also taught virtually. To enquire about virtual remote training please submit your details here.

Related Courses

Microsoft Excel Power Query

Microsoft Power BI

Microsoft Excel Advanced Formulae & Pivot Tables

Microsoft Excel Introduction

Microsoft Excel Intermediate

Microsoft Excel Advanced Formulae & Functions

Microsoft Excel Advanced Validate & Summarise

Microsoft Excel Dashboards Made Easy

Microsoft Excel Expert Formulae

Microsoft Excel VBA