Скачать или смотреть Ben Weiner - "Dynamic Arrays in Excel"

Session Recorded on 26/06/2024 at the Southampton Excel User Group.

https://www.meetup.com/southampton-ex...

Event 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.

Speaker 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.