In Part 1 of this practical webinar, you will learn the concept of Excel macros, including the Visual Basic for Applications (VBA) macro. You will learn step-by-step how to use the Record Macro feature and Excel’s Personal Macro Workbook. After participating is this webinar, you will be equipped to use macros immediately.

You will see each technique demonstrated at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2019. You will identify differences in Excel 2016, 2013, or 2010 and will receive detailed handouts. You will also receive an Excel workbook that includes the examples presented during the webinar.

Who Should Attend:

Practitioners seeking to understand the concept of macros and gaining experience with VBA macros and the Record Macro feature.

Topics Typically Covered:

• Automate the cleanup of an accounting report in Microsoft Excel with a recorded macro
• Record a macro to automate using Center Across Selection
• Record a contact information macro
• Streamline repetitive tasks by way of Excel’s Quick Access Toolbar
• Compare Center Across Selection to Merged cells for centering text across two or more columns
• Add clickable shapes to Excel spreadsheets as a visual means of launching Excel macros
• Uncover macro-related commands within Excel’s user interface

Learning Objectives:

• Apply Visual Basic for Applications (VBA) macros in Excel.
• Define how to use the Record Macro feature.
• Apply the Hide and Unhide commands in an Excel Personal Macro Workbook as needed.