Using Excel Macros with an Intro to VBA

Global Wizdom is recognized by SHRM to offer Professional Development Credits (PDCs) for SHRM-CP or SHRM-SCP. This program is valid for 1 PDC for the SHRM-CP or SHRM-SCP.

Key Take Away:
Being able to create and edit a macro is one of the must-have skills for Excel Power Users. Having this knowledge will save you hours of time by allowing you to automate any Excel-based task or process. If you have never created macros or used VBA before, this webinar is for you.

Overview:
A macro is an action or a set of actions that you can use to automate routine tasks. Macros are recorded in the Visual Basic for Applications programming language.

The easiest way to create a macro is to record the steps. Excel stores information about each step you take as you perform a series of commands. The steps you do are saved in Visual Basic code. You then run the macro to repeat, or “playback,” the commands.

Areas Covered in the Session:
•  Using the Macro Recorder to Create a Macro
•  Saving a File as a Macro Enabled Excel Workbook
•  Running a Macro
•  Creating a Button to Run a Macro
•  Editing the Macro
•  Making Your Macros Available to All Your Workbooks