Course Details

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 course Alan Murray covers 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

CPD Club

Enjoy all of the premium features of the ultimate resource for the UK Accounting Community.

Join CPD Club

CPD Course Speaker

Computergaga

Alan Murray

Alan Murray is an experienced Excel trainer and Microsoft MVP. With over 23 years of experience as an Excel trainer, he helps users build confidence and expertise in Excel and Power BI - empowering them to solve problems, automate tasks, and work more efficiently.

Alan is the author of the ‘Advanced Excel Formulas’ and ‘Advanced Excel Success’ books and has a YouTube channel – named Computergaga – with 118,000+ subscribers and over 50 million views.

He organises the London Excel Meetup group to provide a community event for professionals to network, share, and develop their Excel skills.

Alan loves showing people what’s possible with the tools they already have. His training approach is relaxed, practical, and always focused on the needs of the people in the room. Everyone should feel confident using Excel and empowered to ask any question - no matter how simple or advanced.