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.