Advanced level formulas for accountants

CPD Courses, 1 July 2019

In Summary

As AI becomes an ever-more regular part of our daily lives, we need to keep up and make sure that our accounting processes are streamlined and efficient too. It can be very time consuming to find the right calculation to use in your spreadsheet and even more time could be spent if the formula produces an error.

This course will help you develop the skills you need to carry out quick calculations, whether you’re trying to calculate loan repayments, or carry out what if analysis on your data. You’ll learn how to calculate future value, carry out one and two variable analysis, use reference functions, and create dynamic ranges and user defined functions.

Learn more

Related reading

Certificate in business analytics

Data and analytics

Certificate in Business Analytics (CertBA) - March 2022

Starts 21st March - register now. In this twelve-week course, build — or rebuild — your foundational insights in business analytics so you can identify, evaluate, and capture opportunities fast, make better predictions and estimates, and create value for your business.‚Äč

CPD Courses3 February 2022

Data and analytics

Certificate in Data Analytics

ACCA’s Certificate in Data Analytics demystifies analytics and empowers you with the knowledge to make data-driven decisions.

CPD Courses30 October 2020

Data and analytics


Designed specifically for accountants, this programme gives you everything you need to make the most of Excel.

CPD Courses4 July 2019