CPD Certified

MS Excel 365 - Advanced

This advanced MS Excel course is for anyone who needs to take their Excel skills to the next level. We assume learners will already be familiar with using a keyboard, mouse, computer and assistive technology. By the end of this course you will be able to 

  • Understand and use logical functions such as IF, IFERROR, NOT and AND & OR
  • Work with Mathematical and Statistical functions such as CountA, CountIF, CountBLANK, Round, SUMIF, INT, Rank and Small and Large functions
  • Use Lookup Functions such as V, H and Xlookups, Index, Match, Indirect and Unique
  • Work with Text functions, use dates and times in calculations, create and edit Charts. 
This course also covers the desktop and web versions.


Estimated Course duration is 3 - 4 hours.  Each lesson take on average 3-5 minutes to complete.


Expand all