As you have learned in the lesson, MS Excel Macros and VBA Editor provide powerful automation capabilities that allow you to record, edit, and create custom functions and procedures. Macros help automate repetitive tasks, while the VBA (Visual Basic for Applications) Editor enables you to write custom code to extend Excel's functionality and create sophisticated automated solutions.
In this lab, you will practice creating and editing macros, working with the VBA Editor, and building automated solutions to streamline common Excel tasks.
Open the Macros VBA Exercise.xlsx
file in the your-code
directory and follow the instructions given in the tab "Exercises".
Macros VBA Exercise.xlsx
with your responses.
Upon completion, add your deliverables to git. Then commit git and push your branch to the remote.