Excel for Mac 2016: Macros

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.

Introduction

• Introduction
• Using the exercise files

1. Getting Started

• Identifying the need for macros
• Working with existing macros
• Creating macros with the recording process
• Viewing and modifying VBA code

2. Running a Macro

• Running a macro from the Developer or View tabs
• Running a macro from a keystroke shortcut
• Running a macro from an object or picture

3. Expanding Macro Availability: Personal Macro Workbook

• Creating the personal macro workbook
• Closing and updating the personal macro workbook

4. Additional Macro Features and Capabilities

• 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

Conclusion

• Next steps