ACPD logo

Data Analysis for Accountants: Statistics

(5 reviews)
by Paula Guilfoyle

This course explores the various ways you can use statistics and probability to enhance your role as an accounting and finance professional. Gain an understanding of basic probability functions and testing your hypotheses using Excel.

£100+vat
4 CPD hours
120 days' access

This course will enable you to

  • Understand the basics of probability functions in Excel
  • Use statistics to summarise and describe data you’re working with
  • Learn how to use pivot tables, COUNTIF and HYPGEOM.DIST to count probability
  • Categorise random variables and use binomial distributions and Poisson variables
  • Use Excel tools to select samples, calculate confidence and estimate a population size
  • Test explanations or hypotheses you come up with using Excel
  • About the course

      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. 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 related to sample size and then how to test explanations or hypotheses that you come up with.

    Look inside

    Contents

    How it works

    Author

    Paula Guilfoyle

    Paula practiced in Industry for over 15 years, working with both small and large private companies, before moving on to teach Excel and Power BI to accountants and professionals.

    Reviews

    3.2
    (5 reviews)
    5
    4
    3
    2
    1
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.

    You might also like

    Take a look at some of our bestselling courses

    alt

    2025 Autumn Budget

    alt

    2025 Winter Update: UK Tax

    alt

    2025 Tax Bulletin: December

    alt

    The Accountant as Company Secretary

    Got a team of 2 or more?

    Develop and retain a talented finance team with our team subscriptions.

    Use ACPD101 for 10% off any purchase.