Data analysis: visualisations in Excel

Evidence comes in the form of qualitative or quantitative data about the world around you. It is not always obvious, however, how to structure, aggregate, analyse or interpret the data to help you make decisions. In this free course, you will look at how to use data to make decisions in a systematic way using Microsoft Excel.Microsoft Excel is a spreadsheet software that you will most likely encounter numerous times either in a professional context or outside the workplace. In this course you will explore its functions, which will enable you to analyse data and explore relationships between variables. You will learn to summarise, describe and visualise both univariate and bivariate data in tabular and graphical form. This OpenLearn course is an adapted extract from the Open University course B126 Business data analytics and decision making.

• 1 Excel spreadsheets
• 1.1 Using Excel
• 1.2 Opening an Excel file
• 1.3 Adding the Data Analysis ToolPak in Excel
• 1.4 Decimal points and dates
• 1.5 Using shortcut keys in Excel
• 1.6 Use of Excel spreadsheets
• 2 Univariate data visualisation
• 2.1 Frequency tables
• 2.2 Types of frequency distribution
• 2.2.1 Concepts involved in frequency tables
• 2.2.2 Ungrouped frequency distribution tables
• 2.2.3 Grouped frequency distribution tables
• 2.2.4 Relative frequency distribution tables
• 2.2.5 Cumulative frequency distribution tables
• 2.3 Histograms: a graphical visualisation of frequency tables
• 2.4 Frequency density
• 3 Bivariate data
• 3.1 Contingency tables
• 3.2 Scatter diagrams