Purchase any WEBINAR and get
10% Off
CODE: SAVE10
T&C applicable, please referFAQ
Validity : 22nd Aug'25 to 01st Sep'25
MS Excel: Dynamic Array Functions
- How a dynamic array function differs from a normal Excel Function
- Understanding the SPILL
- Creating dynamic filtering using the FILTER function
- Understanding the difference between the SORT and SORTBY functions
- Creating a unique list of items using the UNIQUE function
- Splitting data into multiple columns using TEXTSPLIT
- Automatically stacking data using VSTACK and HSTACK
- Selecting specific rows or columns using CHOOSECOLS and CHOOSEROWS
- Wrap a single row or column into multiple rows or column using WRAPROWS or WRAPCOLS
- Flatten arrays into a single column or row using TOCOL and TOROW
Overview of the webinar
Unlike most functions which provide a result in a single cell that can then be auto filled, dynamic array functions automatically produce a result that spills into adjacent cells.
Amongst the functions covered in this session are FILTER, SORT and SORTBY which produce filtered or sorted results that automatically update as the underlying data changes. A hugely powerful feature. Also covered is the UNIQUE function which is perfect for creating a unique list to be used in data validation. The other functions in this session cover splitting, stacking, selecting and manipulating data dynamically, thus avoiding manual intervention once the formulas are set up.
These functions are only available to Microsoft 365 subscribers, those using Excel 2021 or later.
Who should attend?
This webinar will provide valuable assistance to nearly all Excel users - it is not industry specific, but is perhaps more widely used among personnel in:
- Banking
- Finance
- Marketing
- Sales
- Investments
- Pharmaceutical
- Accounts
- Audit
- Human Resources
Why should you attend?
Generating spreadsheets that update automatically is a great productivity booster and also helps avoid errors caused by manual intervention. The dynamic array functions are a range of powerful new functions that help with this process.
Faculty - Ms.Lara Mellor
Lara Mellor has worked as a Microsoft Trainer since 1997. She is a subject matter expert in most of the Microsoft Applications. She has a mathematical background so specialises in packages that are logical and analytical such as Excel, Power BI and Project. She also is very excited by the fast paced developments with Microsoft’s AI tool Copilot. She is based in the North East of England and has delivered training courses, run webinars and provided one to one support (both online and face to face) to a large range of UK based companies but also internationally. Lara has also done a range of Excel analysis and development work for clients providing them with a finished working solution.