Skip to content
Underscore Logo Underscore Logo Underscore Logo
  • HOME
  • ABOUT
  • SERVICES
    • Consultancy
    • Resourcing
      • Clients
        • Integrated Project Resourcing
      • Associates
    • Talent Development
      • Training Courses
      • Public Training Programme
      • L&D Consultancy
      • Bespoke Programmes
      • Psychometrics
  • INSIGHTS
    • Blog
    • White Papers
    • Podcast
    • Case Studies
  • CONTACT US
  • HOME
  • ABOUT
  • SERVICES
    • Consultancy
    • Resourcing
      • Clients
        • Integrated Project Resourcing
      • Associates
    • Talent Development
      • Training Courses
      • Public Training Programme
      • L&D Consultancy
      • Bespoke Programmes
      • Psychometrics
  • INSIGHTS
    • Blog
    • White Papers
    • Podcast
    • Case Studies
  • CONTACT US
  • HOME
  • ABOUT
  • SERVICES
    • Consultancy
    • Resourcing
      • Clients
        • Integrated Project Resourcing
      • Associates
    • Talent Development
      • Training Courses
      • Public Training Programme
      • L&D Consultancy
      • Bespoke Programmes
      • Psychometrics
  • INSIGHTS
    • Blog
    • White Papers
    • Podcast
    • Case Studies
  • CONTACT US

Excel – Advanced Statistical Analysis

Excel – Advanced Statistical AnalysisEleanor Bruce2023-02-23T11:43:43+00:00
  • Overview

  • Objectives

  • Content

  • Book

  • 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 the 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

Advanced 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
  • Book

Click here to view our Public Programme dates.

Alternatively please get in touch to discuss bespoke programme options.

Back to all courses
  • About
  • Contact Us
  • Privacy Notice
  • Insights and Resources
  • Talent Development
  • Resourcing

Get Social

Image of Underscore logo, consisting of the word underscore written in white text, with an orange underline, representing an underscore, the company name.
Page load link
This website uses cookies and third party services. Ok
Go to Top