Webinar – Dynamic Arrays – Advanced Functions

Price: AU$25

This is the fourth in the series and the third to focus on dynamic array functions.

This session requires the subscription version of Excel.

We will examine some advanced functions that allow you to get around a few problems you may face with dynamic arrays. We will also cover some advanced techniques and learn about custom functions.

This session covers

  • the SCAN, REDUCE and MAP functions
  • using wildcards for totals
  • an OR condition technique for SUMIFS
  • using the # symbol on the end of functions
  • custom functions with and without LAMBDA

As always, I will share a few other tips along the way.

Date: 24/04/2024
Time: 1:00 PM AEST
Event: Dynamic Arrays - Advanced Functions
Topic: Dynamic Arrays - Advanced Functions
Public: Public
Registration: Click here to register.