Overview:
Excel formulas have evolved dramatically in recent years, yet many finance professionals still rely on techniques developed a decade or more ago. Modern Excel introduces powerful capabilities that can simplify reporting, reduce formula complexity, and create more flexible spreadsheet solutions that are easier to maintain and audit.
In this session, we’ll explore the next generation of Excel formulas and how accountants can use them to work more efficiently with financial data. From dynamic arrays and modern lookup techniques to formula design improvements and single-cell reporting solutions, you’ll learn practical methods that reduce manual effort and help build more reliable spreadsheet models.
During the session we will cover:
• Modernise Formula Approaches - Replace older Excel techniques with modern functions that improve flexibility, efficiency and maintainability.
• Create Dynamic Financial Reports – Explore techniques including GROUPBY, PIVOTBY and modern formula combinations to summarise, analyse and report on financial data.
• Cleaner, Smarter, Formula Solutions – No more dragging formulas, fragile VLOOKUPs and nasty nested Ifs. It’s time for the next generation of formulas.
• Improve Spreadsheet Reliability – Design more robust spreadsheet solutions that reduce risk and support long-term usability.
By the end of the session, you'll be able to build cleaner, more scalable spreadsheet solutions and confidently apply Excel's modern formula toolkit to everyday accounting and finance tasks.