Data analysis: visualisations in Excel

Introduction

The objective of this course is to explore the ways to visualise data sets, such as univariate and bivariate data, in Excel and to familiarise yourself with the functions used in Excel to explore the relationship between variables. Univariate data here refers to data that consists of one variable, and bivariate data refers to data that consists of two variables.

Figure 1 Making sense of visualising and exploring data

Show description|Hide description

A colourful graphical illustration of different types of charts (e.g. pie chart, line graph). In the foreground is a histogram with a magnifying glass hovering over a section of the graph.

Figure 1 Making sense of visualising and exploring data

This course requires Microsoft Excel in some activities. Therefore, this course should be completed on a desktop or laptop rather than a mobile device. If you do not have access to Microsoft Excel, there are various other free options – such as Google Sheets, Apple Numbers or LibreOffice.

This OpenLearn course is an adapted extract from the Open University course B126 Business data analytics and decision making [Tip: hold Ctrl and click a link to open it in a new tab. (Hide tip)] .