Format: All lectures will be via our Digital Campus

Overview

The use of spreadsheets like MS Excel and/or Google Sheets is paramount in business applications and the understanding and use of such tools is a vital skill these days for any job that analyses data for strategic planning, business information and analytics. The aim of this course is to introduce participants to the tools available in MS Excel and/or Google Sheets for the analysis and presentation of data. Quantitative analysis will focus on relevant statistical tools and these will be explored using spreadsheets.

Learning Objectives

• Understand the type of data to collect for statistical analyses
• Understand the different statistical tools used in quantitative analysis
• Learn how to use the different quantitative tools available in MS Excel and/or Google sheets
• Learn how to present information using different graphical tools available in MS Excel and/or Google Sheets.