Loading...

Moving On Up - Getting to the Next Level with Excel Functions & Formula Knowledge

Level
Advanced: Requires substantial subject knowledge
CPD
3 hours
Group bookings
email us to discuss discounts for 5+ delegates
Moving On Up - Getting to the Next Level with Excel Functions & Formula Knowledge

Session

4 Apr 2025

9:30 AM ‐ 12:30 PM

With a SmartPlan £144

With a Season Ticket £160

Standard price £320

All prices exclude VAT

Introduction

This virtual classroom seminar will uncover more advanced level Excel functions and techniques.

This live session is useful for regular Excel users who want to go to the next level in their Excel formula knowledge.

It is ideal for those who create reports in Excel or work with formulas regularly.

What You Will Learn

This live and interactive session will cover the following:

  • The brilliant SUMIFS and COUNTIFS functions - multiple examples
  • The INDEX function - the versatile lookup function
  • XLOOKUP function - the successor to VLOOKUP
  • How to harness the power of dynamic arrays and tables in your formulas
  • Use formulas with charts and in conditional formatting rules

Recording of live sessions: Soon after the Learn Live session has taken place you will be able to go back and access the recording - should you wish to revisit the material discussed.

Moving On Up - Getting to the Next Level with Excel Functions & Formula Knowledge