- Accessing Microsoft Excel
- Opening an Excel file
- Adding the Data Analysis Tool Pack in Excel
- Decimal points and dates
- Using shortcut keys in Excel
- Use of Excel spreadsheets
Programme overview
This programme introduces the fundamentals of data analysis and visualisation using Microsoft Excel. You will explore how qualitative and quantitative data can be structured, analysed, and interpreted to support effective decision making in both professional and everyday contexts.
Throughout the programme, you will develop practical skills in using Excel to organise data, identify relationships between variables, and present information clearly using tables and graphical visualisations. You will also learn how to summarise and analyse both univariate and bivariate data, helping you build confidence in working with data in a systematic and meaningful way.
As Microsoft Excel is widely used across many industries, this programme provides valuable transferable skills that can be applied within a range of workplace and business environments. Please note that access to Microsoft Excel, or a similar spreadsheet program, will be required for this course.
Curriculum
Excel spreadsheets: a tool for organising and starting to process data
- Frequency tables
- Types of frequency distribution
- Concepts involved in frequency tables
- Ungrouped frequency distribution tables
- Grouped frequency distribution tables
- Relative frequency distribution tables
- Cumulative frequency distribution tables
- Histograms: a graphical visualisation of frequency tables
- Frequency density
- Contingency tables
- Scatter diagrams
Course learning outcomes
After studying this course, you should be able to:
- explore the functionalities of Excel that are used for problem solving in a business context
- demonstrate the numeracy skills required for gathering and organising data for decision making related to a specific problem
- use graphical techniques (histograms and scatter diagrams) to provide a visual summary of available data
- recognise data presentation and communication techniques used in a range of traditional and electronic media
- describe the relationship between two variables (independent and dependent variables).
Key features
Flexible Online Learning
Study at your own pace with online course materials that can be accessed anytime, making learning easy to fit around work and personal commitments.
Data Visualisation Techniques
Learn how to present and communicate data effectively using graphical techniques such as histograms and scatter diagrams.
Interactive Learning Activities
Access quizzes, activities, and course exercises designed to support understanding and help reinforce key concepts throughout the course.
Explore more courses
Hybrid Working: Digital Communication and Collaboration
In this course, learners develop communication and digital collaboration skills for modern workplaces while building confidence in online communication, teamwork, and managing their digital presence effectively in professional environments.
Getting started with SPSS
In this course, learners explore statistical data handling in psychological research using SPSS, developing skills in organising, interpreting, and analysing data while building confidence in key statistical concepts.
Supporting Children’s Development: Special Needs
In this course, learners explore children’s development, behaviour, special educational needs, and disabilities while building understanding of how children grow, learn, and develop confidence within educational and everyday settings.
Exploring Learning Disabilities: Supporting Belonging
In this course, learners explore learning disabilities and experiences of individuals, families, and support workers while building understanding of inclusion, belonging, and everyday support needs through real-life discussions.
