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.


In this course, you have started to familiarise yourself with the spreadsheet software Excel, which is widely used in workplaces, and useful in many different fields and contexts: for example, in business, medicine, marketing, tax and auditing, accounting and finance.

You have also studied the basics of data analysis. The focus here was on the several ways to visualise and summarise data using tools available in Microsoft Excel, such as frequency tables, histograms, and scatter diagrams or plots. The main objective of data analysis and statistical modelling is to help make more evidence-based decisions. The various data visualisation tools studied in this course are only the first step toward starting the decision-making process using data.

The next step could be to study descriptive statistics, which gets you closer to a comprehensive analysis of the data. You could then become more confident when examining and summarising data and using Excel tools such as measures of location and measures of dispersion to numerically analyse data.

A second OpenLearn course on data analysis, Data analysis: hypothesis testing [Tip: hold Ctrl and click a link to open it in a new tab. (Hide tip)] , is now also available should you wish to take your studies further.

This OpenLearn course is an adapted extract from the Open University course B126 Business data analytics and decision making.