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 online help from an EC-PC Tutor if you need it. Support is available by email but if your query is not resolved your EC-PC Tutor can arrange a 1-to-1 remote session to put you back on track.
Duration
You’ll work through the video lessons at your own pace – you’ll get 12 months to complete the course so there’s plenty of time.
Certification
Once you have completed the video lessons we’ll send you a practical assessment. Pass the assessment and you’ll receive the following e-Certificate: EC-PC Microsoft Excel Intermediate User.
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.
Cost
Get this course as part of an EC-PC Club 365 subscription.