April 5, 2023


Webinar


4 Total CPE Credits

product-artwork-1759331

K2’s Introduction to Excel Macros

  • Instructor

    Thomas Stephens

Learning Objectives

 

  • Create a macro in Excel using the Macro Recorder tool
  • Manage the fundamental elements of macros in Excel, including accessing macro functionality, naming macros, shortcut keys, storing and deleting macros, absolute vs. relative cell references in macros, and macro security
  • Identify the usefulness of the Macro Recorder and list four key limitations of the Macro Recorder; additionally, modify Excel’s Quick Access Toolbar and the Ribbon to provide shortcuts to macros
  • List the nine key elements of macros written using Visual Basic for Applications and utilize the Visual Basic Editor;  manage macros through copy/paste and delete processes
  • Create variables in macros and identify the purpose of branching and conditional logic routines such as IF/THEN/ELSE, DO/WHILE, and CASE

Major Topics

  • Computer Software & Applications
  • Excel Macros

CPE Credits Available

4
Total CPE
4
Computer Software & Applications

Things to Know About This Course

Course Level

  • Basic

Prerequisites

None

Advanced Preparation

None

Intended Audience

Business professionals seeking to extend Excel’s functionality with simple, yet highly-effective, macros  

Provider

ACPEN

Register For This Event

  • ASCPA Member

    $ 129 129
    Join
  • ASCPA Non-Member

    $ 159 159
    Your Price

Please login to register.