ICAEW
  • Login
  • Event listing
  • How to Book
  • Contact Us
  • All Events
  • Virtual
  • In Person
  • On Demand
0
Basket
Event Details

Leveraging maths and stats in Excel for deeper data insights

£15.00 + VAT
Available
Virtual
All Locations
All Categories
Jun
22
Thu
11:00
-
12:00 BST
Schedule Description: As a finance function, we are often presented with vast quantities of data – how can we use the statistical capabilities within Excel to extract usefu
Zoom Link: https://icaew.zoom.us/webinar/register/WN_zWvgkYpTSceP9E2_uTpW3Q
Zoom
Description
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?
Book here
  • Description
Date and time Location
22/06/2023 11:00 - 12:00 BST Zoom

Event Information

Supporting our series of blogs on the same subject, 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.

  1. Discover the Analysis Toolpak add-in
  2. Learn how to effectively turn data into persuasive insights using the principles of statistics.
  3. 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. 

About the speaker

John Tennent, CEO, Corporate Edge
John is a chartered accountant having trained with Deloitte. In 1996 He co-founded Corporate Edge, a consultancy providing practical business training, financial modelling and business process development.

John specialises in strategic financial planning, business modelling and investment appraisal. He is the co-author of the book, ‘The Economist Guide to Business Modelling’ and two other Economist books.

Costs

RateCost
ICAEW MemberNo Charge
Non-Member£15.00 + VAT
Excel Community SubscriberNo Charge

ICAEW members and non-members are welcome to join. This event is organised by the Excel Community. Please click here to join online.

FAQs

Should you experience any difficulties booking onto the event, please go to our events support page - how to book.

Disclaimer

The opinions expressed by external guest speakers in interviews or other publications included on this website are, by their nature, those of the speaker. They are not necessarily fully endorsed by the ICAEW or purport to reflect the official policies and views of the ICAEW or its members.

ICAEW's terms and conditions for events

  • Event terms and conditions
  • Data protection policy
This event requires participant information to register. Please login and/or fill in the participants information.

Guest Checkout

Guest Checkout
*Checkout without an account.
* Company Name
* Membership number
*Delegate Forename
*Delegate Surname
*Title
*Job Title
*Credentials
*Email address
*Date of birth
*Gender
*Phone number
*Mobile phone number
*Mobile phone carrier
By selecting a carrier, I wish to receive text messages and understand carrier charges may apply.

Log in

Create Account

Back
Suggested items - items that go well with your purchase
Add-on items - items that go well with your purchase
Add-on items - items that go well with your purchase
Add-on items - items that go well with your purchase
Add-on items - Additional items available
has been by to join for . You will need to follow the steps to register before they will officially be placed on this Team.
Basket
Item(s) £0.00
Grand Total £0.00

Contact us

  • Helplines and support
  • How to make a complaint
  • International offices
  • UK offices

Events

  • All events
  • Continuing professional development (CPD) courses

Information services

  • Library
  • Guide to services
  • Company research
  • Historical resources
  • Library collection
  • Library search

Legal

  • ICAEW policies
  • Cookies
  • Privacy policy
  • Reproducing ICAEW content
  • Copyright notice and disclaimer
  • Data protection policy
  • ICAEW website links policy
  • +44 (0)1908 248 250
© ICAEW 2017

This screen shows you the details for the selected product.

Click the "Add to Cart" button to add this product to your shopping cart. You can enter a quantity larger then 1 to add multiples of this product to your shopping cart.

If the product is full you will see a "Wait List" button. Click this button if you would like to be notified if/when capacity is added. If capacity is increased we will email you.  Upon receipt of the increased capacity notification, registration will be on a first-come, first-served basis.

If the product is not ready for purchase you will see a "Notify Me" button. You can click this button if you would like to be notified when this product is ready for purchase.

Some products can only be purchased through our partner. In this case you will see an "External Register" button. Click this button to purchase through our partner's website.

Powered by Configio