Search

17 December 2021

Analysing statistics with Excel

Category: MASTER COURSE

See how easily statistics come alive. This one-day course provides fast tips and best practice for creating robust, dynamic, and flexible statistical models.

Who should attend?
Based on real-world statistical data produced by analysts and researchers, this course will benefit professionals from both the private and public sector who want to build confidence in making more effective business decisions, looking to understand how to interpret statistics and attain a greater skill set with Excel. Laptops with a full installation of Excel will be provided.

The course material includes a variety of features in Excel and participants will gain the maximum benefit from this course if they are regular spreadsheet users and / or have already attended Data Analysis with Excel – Intermediate.

What you will gain
This one-day course is very hands-on where you learn real-world techniques to make statistics easy to understand. We work with industry standard statistical models in Excel without the need for any programming, which you can take away for your own use. Increasingly both private and public sector organisations are turning to statistics to help drive performance, improve decision making and deliver better services. Within this growing dependency on statistics, there is an increasing need for more professionals to be able to think in a more statistical way.

The course includes new ways in developing flexible and dynamic statistical models quickly and easily. Delegates will also gain skills in writing powerful formulas using a variety of unexplored statistical functions. 

By the end of the course you will:

  • Build confidence in modern-day statistical tools all within Excel (with no programming)
  • Write powerful Excel formulas and see the benefits and practicality of using stat models
  • Be able to gain quick insight into business data for better decision making

Programme outline

  • How to formulate robust stat models in Excel for optimum performance and output
  • Time saving techniques, keyboard hotkeys and shortcuts
  • Introduction to statistical terms and how to read stat models used in the real world: types and examples of quantitative data: continuous, categorical, count; real world distributions, e.g. normal, bimodal, uniform, skewed; key terms and calculations: mean; mode; median; percentile; deviation; range; ratio; probability; and risk
  • The benefits and best practice of statistical modelling in modern-day businesses: lots of dynamic and flexible spreadsheet models and examples for quick and easy output; streamline data heavy processes with: STDEVA, NORMDIST, STDEV, STDEVP, VAR, KURT, SKEW, LARGE, PERCENTILE, QUARTILE, RANK, CORREL... and more; discussion point: real world statistical data and how it can be used and improved
  • Associations, trends, regression: further advanced Excel techniques to generate statistical outputs; correlation vs causation; regression analysis; identify different types of data trends
  • Hypothesis testing: the role of chance and how to assess it; ‘F-test’ and a ‘T-test’; analysing cross-sectional data; interpreting the results from the ‘P-value’ of probability
  • Statistical charts and associated tools: designing a ‘histogram’ to visualise data flow; complexities in charting and data plotting; create an ‘Ogive’ chart and extract the results
  • Using Excel strategies for modelling, analysis, and distribution: options for surveying customers and staff: sampling strategies; understanding population and sampling; two techniques for analysing business trends via a 'frequency distribution table'
  • Bonus topics: using Excel add-in features and built-in statistical wizards; how to read an ‘ANOVA table’; a fully-automatic ‘statistical distribution dashboard’ to take away; homework topics for further study

All exercises and project files used on the course will be available to take home.

Information for Online Live dates
Please read the following guidance carefully, which applies only if you are attending this course online:

  • In addition to the Online Classroom, you will need to have your own version of Excel open to complete the exercises
  • It does prove to be challenging to follow-on with the exercises using only 1 screen as you will need to be regularly switching between open windows. We recommend to either:
  • Extend from a computer to a 2nd screen - please refer to this link for guidance on how to correctly setup a second monitor https://support.microsoft.com/en-us/help/4340331/windows-10-set-up-dual-monitors or
  • Use 2 computers, or
  • Use a tablet for the online classroom and a computer for the Excel
  • Please note that our courses are based on Excel for Windows and it is recommended that you are using at least Excel 2010 or a later version. MAC users are welcome but please note that there may be some tools and functionality that will differ from what is being presented. The presenter will accommodate for MAC versions on the course.

The course starts at 9.30am. Lunch and refreshments are included.

6 CPD hours where applicable

CIMA work in partnership with BPP Professional Education to offer CPD training courses

Booking Information

Date Location Price
17 December 2021 - 09:30 London Price: GBP 634.00
Member price: £571. Plus VAT on all prices.


Related Events

15/12/2021 09:30:00

Data analysis with Excel - intermediate

MASTER COURSE

  • Cost:
    GBP 634.00
    Member price: £571. Plus VAT on all prices.
  • Location:
    London
  • Speaker(s):

Harness the power of Excel. Discover how to: interpret, present and search for data from large quantities of information, synthesise information into a logical framework for analysis and summarise it in a meaningful format.

Find out more

10/12/2021 09:30:00

Data driven dashboard reporting - with Excel

MASTER COURSE

  • Cost:
    GBP 634.00
    Member price: £571. Plus VAT on all prices.
  • Location:
    London
  • Speaker(s):

Find out how to create impactful Excel reports with this one day course. Dashboards enable you to make sense of raw numbers by presenting them in visually rich charts and tables, giving valuable insights into the key performance indicators of the business. Find out how.

Find out more

Analysing statistics with Excel

CIMA members and students should log into MY CIMA before booking to receive the appropriate discount.

Book Now

In-house training 
We can develop tailored training programmes to enhance the finance and business skills of staff across your organisation. To discuss how we can meet your learning and development needs please email us.

Find out more 
If you have any queries please email cima@bpp.com or phone us on: +44 (0)3300 603400.

The venue for this course will be confirmed 14 days before the scheduled date. 

CIMA work in partnership with BPP Professional Education to offer CPD training courses.  

This course will be delivered by BPP Professional Education Limited (“BPP”).  Accordingly, when you sign up for this course, CIMA will pass on the contact details you have provided to BPP so that they can contact you to complete your booking and process payment.  BPP will process any personal information it collects about you in accordance with its privacy policy, which is available at: https://www.bpp.com/professional-education/privacy

The information provided to BPP will not be used by BPP for marketing purposes.

CIMA on demand 

Our catalogue of online CPD training courses designed to fit around your schedule.

Get any 5 courses for just £99 +VAT - limited time only.  

Find out more