Basic Data Analysis for Accountants – eLearning

This activity is published by accountingcpd.

All year round, and on every accountingcpd purchase you make, get 10% off  as a CA ANZ member. Just use code CAANZ101.

Please note you will be directed to accountingcpd to purchase this product.

When using Excel 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.

Upon satisfactory completion of this activity you will be able to:
• Use basic filters and sort data on multiple levels.
• Extract subsets of data.
• Set up a pivot table and apply summaries and calculations to it.
• Create and modify a pivot chart.
• Use Data Analysis Expressions (DAX).


This course arms you with the knowledge and skills you need to be able to combine data sources and link tables together to perform powerful, flexible data analysis.

No prerequisites.

No materials distributed.

No assessments required.


Topic: Corporate Finance

Sub-Topic: Business Planning & Analysis

Format: eLearning

Proficiency Level: Foundation, Intermediate

CPD: Upto 4 hours