CONTINUING EDUCATION FOR TAX & FINANCIAL PROFESSIONALS

Western CPE will be closed on July 3rd and 4th to celebrate Independence Day.

Icon_Webcast
Webcast
Icon_Level
Basic
Credits
CPE Credits
4 Credits: Computer Software & Applications

Course Description

You have used Excel for years and Lotus before that. During this time, you have said repeatedly, “One day, I’ll learn how to write macros.” Well, that time has arrived because this four-hour program will introduce you to the wide world of macros and Visual Basic for Applications (VBA) in Excel.

Designed for those with little, if any, experience working with macros, this course will teach the fundamentals of creating and working with macros in Excel. More specifically, you will learn how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.

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 critical limitations of the Macro Recorder; additionally, modify Excel’s Quick Access Toolbar and the Ribbon to provide shortcuts to macros
  • List the nine essential 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 Specifics

Course ID
WC1222281637
Revision Date
April 11, 2022
Prerequisites

None

Advanced Preparation

None

Compliance information

NASBA Provider Number: 103220

Course Instructor

Thomas G. (Tommy) Stephens, Jr. Headshot
K2 Enterprises (Thomas G. (Tommy) Stephens, Jr., CPA, CITP, CGMA)

Thomas (Tommy) G. Stephens, Jr., CPA, CITP, CGMA, received a Bachelor of Science in Business Administration (Major in Accounting) from Auburn University in 1985. In 1994, Mr. Stephens opened his public accounting practice in the metropolitan Atlanta area. In his practice, Mr. Stephens provided accounting, tax, and consulting services to individuals and a wide variety of small and emerging businesses. He developed a successful consulting practice providing installation and support services of small business accounting software. Additionally, he has authored and presented continuing professional education courses to accounting and finance professionals. Mr. Stephens has lectured nationally on subjects such as …

K2 Enterprises (Thomas G. (Tommy) Stephens, Jr., CPA, CITP, CGMA) Read More »

Introduction to Excel Macros

CPE CREDITS
4 Credits: Computer Software & Applications

$196.00


Webcasts are available for viewing Monday – Saturday, 8am – 8pm ET.

Icon_Webcast
Webcast
Icon_Level
Basic
Credits
CPE Credits
4 Credits: Computer Software & Applications

Course Description

You have used Excel for years and Lotus before that. During this time, you have said repeatedly, “One day, I’ll learn how to write macros.” Well, that time has arrived because this four-hour program will introduce you to the wide world of macros and Visual Basic for Applications (VBA) in Excel.

Designed for those with little, if any, experience working with macros, this course will teach the fundamentals of creating and working with macros in Excel. More specifically, you will learn how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.

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 critical limitations of the Macro Recorder; additionally, modify Excel’s Quick Access Toolbar and the Ribbon to provide shortcuts to macros
  • List the nine essential 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 Specifics

Course ID
WC1222281637
Revision Date
April 11, 2022
Prerequisites

None

Advanced Preparation

None

Compliance information

NASBA Provider Number: 103220

Course Instructor

Thomas G. (Tommy) Stephens, Jr. Headshot
K2 Enterprises (Thomas G. (Tommy) Stephens, Jr., CPA, CITP, CGMA)

Thomas (Tommy) G. Stephens, Jr., CPA, CITP, CGMA, received a Bachelor of Science in Business Administration (Major in Accounting) from Auburn University in 1985. In 1994, Mr. Stephens opened his public accounting practice in the metropolitan Atlanta area. In his practice, Mr. Stephens provided accounting, tax, and consulting services to individuals and a wide variety of small and emerging businesses. He developed a successful consulting practice providing installation and support services of small business accounting software. Additionally, he has authored and presented continuing professional education courses to accounting and finance professionals. Mr. Stephens has lectured nationally on subjects such as …

K2 Enterprises (Thomas G. (Tommy) Stephens, Jr., CPA, CITP, CGMA) Read More »

Introduction to Excel Macros

CPE CREDITS
4 Credits: Computer Software & Applications

Webcasts are available for viewing Monday – Saturday, 8am – 8pm ET.

$196.00