August 24, 2018


In-Person

Alabama Society of CPAs
1041 Longfield Ct, Montgomery, Montgomery County, Alabama 36117-8056


4 CPE

K2's Introduction to Excel Macros

August 24, 2018
In-Person
4 CPE

K2's Introduction to Excel Macros

Learning Objectives

  • Upon completing this course, you should be able to:
  • 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

  • Creating your first macro in less than two minutes
  • Understanding macro fundamentals
  • Working with the macro recorder
  • Introducing Visual Basic for Applications
  • Useful macro techniques for accountants

CPE Credits Available

4 CPE
4
Other

Alabama Society of CPAs

1041 Longfield Ct, Montgomery, Montgomery County, Alabama 36117-8056

Get Directions

Things to Know About This Course

Course Level

  • Basic

Professional Area of Focus

  • Software

Prerequisites

None

Advanced Preparation

None

Intended Audience

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

Provider

K2 Enterprises

This event has ended.