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
- 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.
This is part one of a two-part webinar series. To register for both parts together at a discounted price, please click here.
CPE Credit: Participants can earn up to 2 CPE credits in the Computer Software and Applications field of study for each webinar in this series.
Program Level: Basic
Advance Preparation: None
Instructional Method: QAS Self-Study for the recorded webinar
National Registry of CPE Sponsors: Clear Law Institute is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.