Skip to main content

The global body for professional accountants

3
UNITS

Recorded webinar | ACCA

Microsoft Excel workshop: Modern Excel formulas for accountants

Learn modern Microsoft Excel formulas to create smarter financial reports, simplify complex spreadsheets and build more reliable models with confidence.

Overview

Person in office

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.

 

. 

We’ll 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.

Alan Murray

Alan Murray is an Excel trainer, founder of Computergaga.com and author of the Advanced Excel Success and Advanced Excel Formulas books. He has been helping people in Excel for over 23 years. He loves training and the joy he gets from knowing he is making peoples working lives easier. Alan’s Computergaga YouTube channel has over 650 videos and over 50 million views. He also runs the monthly London Excel Meetup Group, where people learn, network, and enjoy each other’s company.

The webinar handout material will be available on the webinar platform when you log in to view the session.

If you wish to view or download handout materials, before starting the webinar, they will also be available through your document library on https://events.accaglobal.com

This event was recorded on 23 Sept 2026

Pricing and booking information

Price

Price (excluding VAT) 110 GBP

Location

United Kingdom

Date & time

On demand

Enquiries

Email enquiries UKCL@accaglobal.com

Book on ACCA opens in a new tab

Course provider

ACCA logo