Excel Advanced Statistical Analysis
Use some of the hidden statistical analysis tools within Excel to build complex data models.
Enquire Now
Course overview
Duration: 1 day (6.5 hours)
This advanced Excel course looks at some of the statistical analysis tools available and gives examples of when they might be used.
This course is aimed at advanced users of Excel who work with statistical data often and have a good knowledge of Maths.
Objectives
By the end of the course you will be able to:
- Use Goal Seek
- Create and view scenarios
- Use Forecast Sheet
- Create single and double input data tables
- Create models using the solver
- Install and use the Analysis Toolpak
- Create and use array formulas
- Use a range of advanced Financial and Statistical Excel functions
Content
Using what if analysis options
- Using Goal Seek
- Creating, saving and viewing scenarios
- Generating a Forecast sheet
Solver
- Creating models
- Projecting scenarios with Solver
Using data tables
- Creating single input data tables
- Creating double input data tables
- Projecting with data tables
Financial functions
- PMT
- FV
- NPV
Analysing data with Analysis ToolPak
- Installing the Analysis Toolpak
- Generating statistical analysis
- Visualising data using Histograms
Array formulas
- Using embedded Excel Array formulas
- Create an Array formula
- Multi and single cell Array formula
- Using TRANSPOSE to flip rows or columns
- Use the FREQUENCY Function
- Use an array to count unique entries in a range
Dynamic arrays
- Spilling data
- Using the new dynamic array functions
Advance functions in formulas
- Statistical functions:
- MEAN, MEDIAN and MODE
- RANK
- LARGE and SMALL
- MOD
- PERCENTILE
- Use the AGGREGATE function to sum data in ranges with errors
Testimonials
Frequently Asked Questions
Who is this Excel Advanced Statistical Analysis training course for?
What will I learn on the Excel Advanced Statistical Analysis course?
Do I need any prior Excel experience before attending this course?
How is the Excel Advanced Statistical Analysis course delivered?
Will I get practical, hands-on experience during the course?
What support do I get after completing the training?
Get in Touch
Still have questions about this course?
Click Enquire Now and our team will share full details on content, dates, and pricing — and help you decide if it’s the right fit for you or your organisation.
Enquire NowRelated Courses
Excel Module 4 – Advanced Formulas and Functions
Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time.
Power BI – Introduction
Learn how to use this powerful tool to import and clean data and create some amazing visuals.
Excel Power Query and Power Pivot
Learn how to work with and connect multiple data sets to effectively analyse and report on data.
Explore More Training Options
Public Training Programme
Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.
Engage with expert instructors and a diverse peer group in an interactive, online learning environment.
Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.
Check Public DatesFull Training Catalogue
We deliver a wide range of training across Leadership, Personal Development, Project Management, and IT applications. Many organisations choose us because they can source both technical and people-focused training from one trusted provider.
Courses can be tailored to your organisation’s needs, making it easier to upskill teams consistently across different areas. Whether you want to build management capability, strengthen project delivery, or boost everyday software skills, you’ll find relevant options in our catalogue.
