CPDStore

Excel formulas have evolved. With new automatically expanding ranges, dynamic arrays, and powerful functions like LET, LAMBDA, and the innovative TRIMRANGE, the way we build formulas has fundamentally changed. This session is essential for anyone who wants to harness the power of modern Excel formulas. Never drag a formula again, and write cleaner, smarter formulas that are dynamic, robust, and easy to maintain.

In this webinar Alan Murray will cover the following topics:

• Take advantage of dynamic arrays: How functions like SEQUENCE, UNIQUE, and XLOOKUP replace older formulas
• Never drag a formula again with BYROW, BYCOL, and SCAN.
• Simplify and speed-up formulas with LET.
• Create single cell reports with GROUPBY and FILTER.
• Exploring TAKE, DROP, and TRIMRANGE to work with ranges dynamically

By attending this webinar, you will...

• Be able to use the latest Excel functions such as XLOOKUP, BYCOL, DROP, and TRIMRANGE.
• Understand how dynamic arrays work and when to use them
• Write cleaner, more flexible formulas that adapt to changing data
• Learn techniques that reduce formula errors and are easier to maintain
• Feel more confident using new Excel functions in real-world scenarios

This webinar will be of most interest to experienced Excel users in finance roles—such as accountants, analysts, and management accountants—who want to modernise their formula skills to create robust, error-free, and fast formulas.

Course level: Advanced