1
Type Speaker CPD Hours Level
3 AdvancedInformation
Accreditation Information
SRA Competency D

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.

Book now

Added to basket

Learn Live | 29.11.2021

N/A | 9:00am - 12:00pm


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

Checkout
Continue Shopping
Nov
29
2021
 
9:00am - 12:00pm

Add
Prices (ex VAT)
Smart
Plan Information
Season
Ticket Information
Standard
Individual licence
£121.50
£135
£270
Group bookings
Discounts are available for multiple places. If you have 5 or more people interested in participating in this virtual learning session please email us at information@mblseminars.com for more information.

Related Events