K2's Introduction to Excel Macros

Course Details

Date

Friday, December 9, 2022

12:00pm – 3:30pm (Registration: 12:00pm)

Location

Facility Pending

Webinar

Field of Study

Technology

CPE Credit

4 hours CPE credit

Level of Knowledge

Beginning

Vendor

K2 Enterprises

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

Course Pricing

WYOCPA Member Fee
$160.00

Non-Member Fee
$210.00

Late Registration Fee (will be added after December 4, 2022)
$100.00

Your Price
$210.00

View All Professional Development Courses