Data analysis for accountants: getting started

CPD Courses, 1 July 2019

In Summary

As a finance professional you will use Excel to analyse data, but how often do you overlook Excel's useful features? You may be familiar with creating tables, and filtering and sorting your data, but what more could you be doing to get more insight from your data?

This course looks at both basic and advanced features of Excel's PivotTable tool, which can be used to rearrange and summarise huge data sets efficiently, negating the need for complex formulas. You will also explore PowerPivot, one of Excel's most popular Power Tools. Equipped with its own language, Power Pivot enables you to analyse data across multiple tables or data sets, from different data sources.

Learn more

Related reading

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

Data and analytics

Statistics for accountants in excel

In a dynamic and ever-changing world, we need to be smarter about how we use the tools we have at our disposal. 

CPD Courses1 July 2019