Microsoft Excel 2019 - Level III

This course continues to explore Excel functionality and introduces the student to the extensive variety of Excel templates that are available. The student will learn how to use macros to handle repetitive activities and how to attach them to buttons using the Developer Tab. Enhancing a spreadsheet with conditional formatting and graphics will be covered, as well as features such as formula auditing; calculation options, comments; and how to protect a worksheet. A few more functions will also be covered, including the VLOOKUP function and ARRAY functions. Prerequisite: Excel I and II or equivalent knowledge