Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel for Mac 2016: Macros

via LinkedIn Learning

Overview

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.

Syllabus

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

Taught by

Dennis Taylor

Related Courses

Reviews

Start your review of Excel for Mac 2016: Macros

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free