MS Excel - Expert

This Expert level course is aimed at learners who want to get the most out of MS Excel and who have a very good practical knowledge of using MS Excel.

By the end of this course you will be to

  • create dynamic ranges
  • use ISERR, ISBLANK and ISNA functions 
  • use DSUM, DMIN, DMAX and DCOUNT
  • take macros to another level by exploring the Visual Basic Editor and turning off screen flashing
  • explore further features with pivot tables such as filtering fields and calculated items

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

You can also access our Quick Tip Videos, that only last a few minutes, under Tips and Tricks.


Expand all