Excel Intermediate Course

£55.00

Get instant access to our learning portal today

  • Check Mark Work at your pace
  • Check Mark Choose your time & place
  • Check Mark Earn y our certificate

Description

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