On this course you'll learn how to work effectively with spreadsheets and use tools to quickly organise, present and visualise data. You'll learn how to use intermediate formulas and functions - eg SUMIF, IF, VLOOKUP etc. We end the course showing you the power of PivotTables to quickly summarise data!
Learn by watching short video lessons
The course is made up of short bite-sized video lessons.
Download practice files
You’ll be able to download the files used in the video lessons and try out what you’ve been shown. You’ll also be able to download additional exercises.
Get tutor support
You’ll get 1-to-1 email support relating to course topics from an EC-PC Tutor.
Requirements
You’ll need some existing skills using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Basic User course. To complete the course online you’ll need a Windows PC installed with Microsoft 365.
