Data analytics software
We have introduced data analytics software into ACA exams, specifically the Audit and Assurance and Corporate Reporting exams.
Use of spreadsheet functionality
The examinable skills in the Financial Management, Business Strategy and Technology and Strategic Business Management include structuring and assimilating data, statistical calculations and financial functions.
Spreadsheet functionality
-
Data assimilation and visualisation
To structure and assimilate data, a variety of spreadsheet logical functions could be used. These functions can be combined to filter, sort and restructure data provided in a pre-populated spreadsheet. This enables data to be scrutinised to identify trends and patterns that can be presented to management in a variety of formats appropriate to the purpose in context.
-
Statistical analysis
Spreadsheet statistical functions enable students to carry out statistical calculations quickly without extensive mechanical calculations, or the need to memorise statistical formulae. This gives a focus on understanding the data provided and interpreting the statistical results.
-
Financial functions
Financial functions in spreadsheets are useful in determining common measures in finance such as IRR. They save time in performing extended calculations. This will not just enable the calculations to be made in the first instance, but a variety of adjustments to the base data can be made, for example to test sensitivity and gain an understanding of the key variables impacting risk, as would be the case in data analysis in the workplace.
Within the Financial Management, Business Strategy and Technology and Strategic Business Management exams you may be examined in the following ways:
- Data will be provided in the question, and you should populate the spreadsheet based on the data in the question.
- A spreadsheet will be provided in the exam with pre-populated data for you to structure, assimilate, interpret and evaluate.
Below is a list of functions you need to be familiar with based on which exam you are sitting.
|
Functions |
Business Strategy and Technology |
Financial Management |
Strategic Business Management |
|
Data assimilation and visualisation |
|||
|
AVERAGE |
✓ |
✓ |
✓ |
|
COUNTIF |
✓ |
|
✓ |
|
COUNTIFS |
✓ |
|
✓ |
|
IF* |
✓ |
|
✓ |
| IFS | Added in 2023 | Added in 2023 | |
|
RANK |
✓ |
|
✓ |
|
SUM |
✓ |
✓ |
✓ |
|
SUMIF |
✓ |
|
✓ |
| SUMIFS | Added in 2023 | Added in 2023 | |
| TREND | Added in 2023 | Added in 2023 | |
|
Statistical analysis |
|||
|
CORRELATION |
Added in 2023
|
✓ |
✓ |
|
STD DEV |
✓ |
✓ |
✓ |
|
Financial functions |
|||
|
IRR |
|
✓ |
✓ |
|
MIRR |
|
|
✓ |
| XIRR | Added in 2023 | ||
|
NPV |
|
✓ |
✓ |
|
POWER |
|
✓ |
✓ |
|
PV |
|
✓ |
✓ |
|
RATE |
|
✓ |
✓ |
|
|
|
|
|
|
General |
|||
|
Absolute cell references (eg, $A$1 is a fixed reference to cell A1) |
|||
|
Formatting (eg, to 0 decimals, Currency £ and Percentage % ) |
|||
*Nested IF statements could be used in Business Strategy and Technology and Strategic Business Management
Spreadsheet functionality in exams
Support and guidance
To support you with these changes we have developed a series of videos on basic spreadsheet functions to aid your understanding for the Financial Management, Business Strategy and Technology and Strategic Business Management exams.
Data analytics software
ICAEW has introduced data analytics software into ACA exams, starting with the Audit and Assurance exam and Corporate Reporting.
You will need to be familiar with how the software works and its various functions. It is therefore important that you work through the relevant explanatory guidance notes, using the practice datasets that we have created. You should then attempt the practice questions.