Loading...

Excel LAMBDA Functions - Unravelling the Potential

Level
Intermediate: Requires some prior subject knowledge
CPD
1.5 hours
Group bookings
email us to discuss discounts for 5+ delegates
Excel LAMBDA Functions - Unravelling the Potential

Date to be confirmed

With a SmartPlan £153

With a Season Ticket £170

Standard price £340

Future dates are coming soon. Please let us know if you wish to be notified.

Notify me

Introduction

In 2023, mastering Microsoft Excel goes beyond the conventional formulas and functions.

LAMBDA functions have emerged as a game-changer, empowering users to create custom functions that cater to their unique data analysis and manipulation needs.

Whether you are a seasoned Excel user or just starting your journey, this virtual classroom seminar is your gateway to unravelling the potential of LAMBDA functions.

What You Will Learn

This live and interactive session will cover the following:

  • What are LAMBDA functions? And why should I care?
  • Create a simple LAMBDA
  • Make the LAMBDA function available like any other Excel function
  • Create a more advanced LAMBDA with optional arguments
  • An example of LAMBDA helper functions
  • How to share LAMBDA functions with other users, or other workbooks
  • Use the Advanced Formula Environment for a better editing experience

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.

Excel LAMBDA Functions - Unravelling the Potential