Introduction To Excel Macros (On-Demand - K2E)
Overview
You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this seminar will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA).
There’s no need to be intimidated by Excel macros! Instead, attend this session to learn how to create helpful macros to automate many business processes without writing VBA code. You’ll be amazed at how easy Excel macros can be!
Access expires 180 days from purchase date |
Course Description
Applicable for
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 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
Content
- getting started with Excel macros by using the Macro Recorder
- fundamentals of writing VBA code
- saving and sharing macros
- getting started with User-Defined Functions
Course Content Created: 2023
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.About This Product
On-Demand Courses by K2E. For over three decades, the team of professionals at K2E has created and presented the finest in technology-focused education. Today, their focus remains unchanged – delivering outstanding value to customers with every interaction.
Please note that not all on-demand courses include downloadable materials such as course notes or slides.
How to get started
Upon completion of purchase, go to mylms.bccpa.ca and log in using your CPABC Online Services credentials. Click “Go to your Courses and Materials” to go to your Learning Center, then find and click on your course title.
Course Dates & Registration
- 4
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 5
- Credits
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.
Introduction To Excel Macros (On-Demand - K2E)
- 4
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 5
- Credits
Overview
You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this seminar will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA).
There’s no need to be intimidated by Excel macros! Instead, attend this session to learn how to create helpful macros to automate many business processes without writing VBA code. You’ll be amazed at how easy Excel macros can be!
Access expires 180 days from purchase date |
Course Description
Applicable for
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 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
Content
- getting started with Excel macros by using the Macro Recorder
- fundamentals of writing VBA code
- saving and sharing macros
- getting started with User-Defined Functions
Course Content Created: 2023
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.About This Product
On-Demand Courses by K2E. For over three decades, the team of professionals at K2E has created and presented the finest in technology-focused education. Today, their focus remains unchanged – delivering outstanding value to customers with every interaction.
Please note that not all on-demand courses include downloadable materials such as course notes or slides.
How to get started
Upon completion of purchase, go to mylms.bccpa.ca and log in using your CPABC Online Services credentials. Click “Go to your Courses and Materials” to go to your Learning Center, then find and click on your course title.
Course Dates & Registration
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.