Excel Intermediate Course
Get instant access to our learning portal today
- Work at your pace
- Choose your time & place
- Earn y our certificate
Excel Intermediate Self Led Videos
- Do you want to save time with Excel by learning loads of shortcuts and tips?
- Do you want to impress your boss with your Excel knowledge?
- Does that promotion mean you need to understand how to structure data and filter?
- Have you completed our Excel Introduction course, and are keen to build on your new found knowledge?
Our Intermediate Excel Course will build on your existing knowledge enabling you to work with Formula, Tables, Charts, and multiple sheets.
Each step is exampled in clear videos. There is a workfile, so you can practice alongside the video, and an answer file so you can check what you are doing. Each video is less than 15 minutes long. There are 18 videos in this course. If you did one video every day, you could complete the course in less than a month! Once you have watched the videos, complete the quiz. You will need 80% to get a certificate. Don’t worry if you don’t do it first time, you can always go back to the videos and have another go.
The subjects covered in this course are:
Using Absolute Cells in a formula
Working with different sheets including linking formula, grouping sheets and copying
Using Tables and why they are so important
Filtering and sorting a table
Using conditional formatting to make data stand out in your table
Creating and formatting charts
Using the IF formula