Macros-automated actions or sets of actions in Excel-can spare you some of the tedium associated with repetitious command sequences and data manipulation tasks. In this course, learn how to create and use macros to automate tasks in Excel 2016 for Mac. Discover when it's appropriate to use macros, how to create macros by recording keystroke and command sequences, and how to expand a macro for more than one task. Learn how to launch macros with keystroke shortcuts and buttons, record a formatting macro and alter VBA code, and expand macro functionality with If statements and interactive techniques. Plus, watch the step-by-step execution of macro code.


* Working with existing macros
* Creating macros with the recording process
* Viewing and modifying VBA code
* Running a macro from the Developer or View tabs
* Running a macro from a keystroke shortcut
* Running a macro from an object or picture
* Creating and updating the Personal macro workbook
* Recording a formatting macro
* Expanding a macro with an IF statement
* Creating interactive macros
* Stepping through macros