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 and DSUM and DCOUNT. You will also take macros to another level by exploring the Visual Basic Editor and turning off screen flashing. Lastly you will 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.