Using Statistical Functions to Analyse Data in Microsoft Excel

Overview:

This module is designed to equip participants with the skills and knowledge necessary to effectively use statistical functions to analyse data. Whether you are a beginner or have some experience with data analysis, this module will provide you with a comprehensive understanding of key statistical functions and how to apply them in various contexts.

Target Audience:

This module is ideal for:

  • Beginners with little to no Excel experience
  • Professionals looking to refresh their basic Excel skills
  • Anyone wanting to improve their productivity with spreadsheets

By the end of this course, you'll be able to:

  • Understand the fundamental concepts of statistical analysis

Topics include:

  • Using the Statistical functions to perform a wide range of data analysis tasks,
  • Count the number of cells within a range that meet a specified condition or criteria. (CountIF)
  • Add the values in a range that meet a specified condition or criteria.(AddIF)
  • Calculate the average of cells that meet a specified condition or criteria. (AverageIF)
  • Count the number of cells across multiple ranges that meet multiple specified conditions or criteria. (CountIFs)
  • Add the values in a range based on multiple specified conditions or criteria across different ranges.(AddIFs)
  • Calculate the average of cells based on multiple specified conditions or criteria across different ranges. (AverageIFs)

All Microsoft Excel Modules

Automate Decisions with Logical Functions

Search and Retrieve Data from tables with Lookup Functions

Analyse and Visualise Date with Pivot Tables

Add Automation to Your Workbooks with Macros

Transform Your Data with Power Query

Use AI in Excel to Turbo Charge Your Excel Experience

First Steps in Microsoft Excel

Creating Basic Formulas

Manipulate Data Using Tables

Data Visualisation with Charts

Using Statistical Functions to Analyse Data


Back to Training Courses
Submit
Thank you! Your message has been sent.
Unable to send your message. Please fix errors then try again.
Smiling professional man giviing okay gesture and holding a laptop

Contact Us

To find out more about our products and services or to discuss how we can help  improve communications and collaboration using Microsoft 365 apps within your organisation, give us a call on the telephone number below or complete the contact form.

  01274 024 353

Last Updated : 04/08/2024