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.
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 materials distributed.
No assessments required.
Topic: Corporate Finance
Sub-Topic: Business Planning & Analysis
Proficiency Level: Foundation, Intermediate
CPD: Upto 4 hours