Excel Advanced

£25.00

Get instant access to our learning portal today

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

Description

 

Excel Advanced Self Led Videos 

 

Do you need to improve your Excel skills for your job?  Or maybe you are looking for a promotion but your Excel skills are not good enough.  Maybe you  have seen your manager’s spreadsheets and don’t understand the formula.  This course will take your Excel knowledge to the next level, and demystify topics like Vlookup, Pivot Tables and If functions.   

 

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.  You can go back over the videos as many times as you like.  Keep practicing and soon it will become part of your everyday knowledge. 

 

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: 

 

  • What is vlookup 
  • Using true/false in vlookup 
  • If Functions
  • Nested IF 
  • Multiple If 
  • IFS 
  • Sumifs/countifs/averageifs 
  • Pivot Tables