• Home
  • Statistics for Accountants in Excel – eLearning

Statistics for Accountants in Excel – eLearning

This activity is published by accountingcpd.

CA ANZ members are entitled to receive 10% off every purchase. Use code CAANZ101 at checkout to take advantage of this discount.

Save $180 and get 20 hours of CPD at your fingertips when you pick ANY 5 4-hr CPD courses for just $495 – use code CAANZ20 at checkout. 

Statistics for Accountants in Excel looks at the various ways you can use statistics and probability to enhance your role as an accounting and finance professional.
Content Description:
As accountants, we are all familiar with Excel. However, in a dynamic and ever-changing world, we need to be smarter about how we use the tools we have at our disposal. Technology is moving forward at an incredible pace and using programmes like Excel to their full potential is vital if you want to stay relevant in this new digital era.

Using statistics and probability in Excel can help you to enhance your role as an accounting and finance professional. The techniques covered in this course can help you to understand how to use statistics to summarise and properly describe the data with which you're working.

You will cover the basics of probability, so that you can understand how to predict more accurately the likelihood of certain business outcomes. You'll also touch on the various issues you might discover and then how to test explanations or hypotheses that you come up with.

Upon satisfactory completion of this activity you will be able to:
Understand the basics of probability in Excel.
Use statistics to summarise and describe data you’re working with.
Accurately predict the likelihood of business outcomes.
Learn how to use pivot tables, COUNTIF and HYPGEOM.DIST to count probability.
Use Excel tools to select samples, calculate confidence and estimate a population size.
Test explanations or hypotheses you come up with using Excel.

This course allows you to use statistics to help drive performance, improve decision making and deliver better services. You will be able to think in a more statistical way.
No prerequisites.

No materials distributed.

No assessments required.


Topic: Corporate Finance

Sub-Topic: Business Planning & Analysis, Internal Audit

Format: Self-paced

Proficiency Level: Foundation, Intermediate

CPD: 4 hours