ICAEW.com works better with JavaScript enabled.
Exclusive

Leveraging maths and stats in Excel for deeper data insights

Author:

Published: 22 Jun 2023

Exclusive content
Access to our exclusive resources is for specific groups of students, users, subscribers and members.
As a finance function, we are often presented with vast quantities of data – how can we use the statistical capabilities within Excel to extract useful insights?

This webinar will showcase some of the key Excel statistics tools that can help to interpret trends and provide validity to estimations.

By using practical business examples, we will look at some of the standard features, the Analysis Toolpak Add-in, trend analysis, calendar phasing, normal distributions, and probability, showing that these capabilities can be accessible to accountants, without requiring advanced statistical know-how.

  • Discover the Analysis Toolpak add-in
  • Learn how to effectively turn data into persuasive insights using the principles of statistics.
  • Evidence your judgements by learning how to practically apply the mathematics we all learnt years ago.

This webinar will explore how to use Excel functions and features to help apply statistics to provide useful data insights. This webinar is for anyone looking to enhance their Excel analysis skills and capabilities. The webinar is aimed at general Excel users or creators of spreadsheets, per our Competency Framework, with some knowledge of Excel functions but limited exposure to its statistics functions.

First broadcast on 22 June 2023

Webinar resources

Allow StreamAMG video

This video is provided by StreamAMG. We ask for your permission before anything is loaded as they place a few cookies on our site. For more information on how we handle cookies, please see our privacy policy and cookies policy. To view this content on the website, please accept and continue.