Continuous Professional Development

Basic business statistics using excel

Group of people collaborating on a work desk

Course Summary

Do you need to interpret and produce reports that provide basic summary statistics and charts? In this self-directed, online course, you will learn about which charts and statistics are most appropriate to display in relation to your particular data.

The course will use example data for the purposes of both demonstrations and exercises, offering you an opportunity to learn by doing as well as developing an understanding of the underpinning theory. The course will also provide an introduction to advanced statistical methods to give you an understanding of other analytical tools that are available. 

NOTE: This is a self-directed course delivered online. Please use the token code to register.

This course is funded by the 2014-2020 European Structural and Investment Fund as part of the Advancing Manufacturing Challenge Fund.

The course is divided into the following parts.

  • Data and variables
  • Graphs and charts
  • Summary statistics
  • Summary tables
  • Summary of Parts A-D
  • Awareness of further concepts

 By taking part in this course, participants will:

  • Understand essential concepts in summary statistics and common options for graphically displaying data and relationships between variables
  • Gain confidence, through practice, in interpreting and presenting summary statistics and graphical displays that are typically found in business reports and publications
  • Practice using Excel to produce summary statistics, tables, and graphs, including using pivot tables where needed

This course is aimed at all levels of professional and administrative staff who need to interpret and produce basic summary statistics and charts in business reports and documents. The course assumes no prior knowledge of statistics, however, some experience of using Excel is assumed.

This course is being delivered in partnership with the University of Strathclyde and will feature Ian Dwyer from the Department of Mathematics and Statistics.

Register to attend

Dates & Venues

DateAvailable now
LocationSelf-directed online learning
Duration1 hour approximately
Course tokenAMCFSTATS22

In collaboration with

University of Strathclyde Logo in Grey

Funded by