In Person Event - Dynamic Arrays in Excel
Details
This event will take place at the office of The Niche Partnership
Threefield House, Threefield Ln, Southampton SO14 3LP
***PARKING INFORMATION: Do not park in the Threefield House car park as this is reserved for employees only. Parking here will result in fines. The closest public car park is College Street Car Park, a few minutes walk away.***
Agenda
- 6:00 – 6:30 Meet & Greet
- 6:30-7:30 Dynamic Arrays in Excel by Ben Weiner
Summary:
Traditional Excel formulas could only return a single value, but with the introduction of Dynamic Array formulas its now possible to return multiple values into a range of cells using just one formula.
I will go over new dynamic array functions, including FILTER, SEQUENCE, SORT, UNIQUE, as well as showing how these formulas can be combined with traditional formulas to make dynamic calculations that expand over multiple cells as the data changes.
If you currently find yourself having to repeat one formula over a large dataset and having to drag down those formulas every time your data expands, then come along and find out how dynamic arrays can help you create more flexible calculations.
Bio:
A qualified CIMA Chartered Management Accountant and Microsoft Excel Expert I have been working in finance for over ten years. Initially working in accounting roles in the past few years he has moved in financial analysis using advanced Excel features to analyse financial data and build financial models, accounts and budgets and forecasts.
- 7:30-8:30 Pizza and Networking
Thanks to our sponsor The Niche Partnership for hosting this events at their office and for providing the pizza.
In Person Event - Dynamic Arrays in Excel