Skip to content
Skip to main content

About this free course

Download this course

Share this free course

Data analysis: visualisations in Excel
Data analysis: visualisations in Excel

Start this free course now. Just create an account and sign in. Enrol and complete the course for a free statement of participation or digital badge if available.

Data analysis: visualisations in Excel


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.

A graphical illustration of different types of charts (e.g. pie chart, line 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)] .