-
Discover how to create and use macros to automate simple, repetitive tasks in Excel 2016 for Mac.
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.
Overview
Syllabus
-
Introduction
- Introduction
- Using the exercise files
- Identifying the need for macros
- 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 the personal macro workbook
- Closing and updating the personal macro workbook
- Recording a formatting macro and altering VBA code
- Expanding macro functionality with the IF statement
- Creating interactive macros and stepping through macros
- Watching VBA code being created
- Next steps
