How to use Microsoft Excel
These e-learning courses on Excel will help you navigate and understand how to use all it's functionality to make analysing your data simpler and more effective.
Who are these courses for?
These courses have been designed for anyone who needs to analyse data as part of their role.
About these courses
These courses will need to be completed in order, as each one builds on the skills and understand from the previous part.
Part one - The basics
This first course will help you to understand the basics principles of using Excel and how to structure and format your data.
Part two - Formulas and graphs
This part will help you understand the basics of Excel data analysis including creating basic formulas, how to use advanced formulas and how to create custom charts to display your data.
Part three - Analysing demographic data using pivot tables and charts
The part will help your understand how to analyse survey findings using demographic data, how to segment your data and why it's important.
Part four - Using formulas as an alternative to pivot tables
In this part you will learn about the formulas you can use, when to use them to best effect and how to recode variables in the formula.
Part five - Aggregating datasets and data visualisation
Taking the final part, you will learn how to aggregate a dataset and how to report on your data using different graphs.