Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Learn the basics of Excel VBA using a case study of a multinational company.
VBA is an excellent tool to automate repetitive tasks in Excel and can also streamline complex calculations. This CPA Ontario course will help you understand when and why to use VBA, and how to build custom formulas. This Excel VBA tutorial will also cover more advanced topics such errors and exceptions, how to publish your functions, how to set up events and automation, and how to work with arrays.
This course includes a quiz that you can attempt multiple times. To ensure that your understanding of the material is accurately assessed, the correct answers will not be shown after each attempt.
Unlock learning anytime, anywhere with the Blackboard Learn app
Seamlessly access your on demand courses, assignments, and get PD hours on the go. Learn how to download now and elevate your education experience with the convenience of mobile learning.
Key Takeaways
Upon completion of this course, you will be able to:
- Understand when and why to use VBA.
- Create custom formulas in VBA to be used in Excel.
- Create a custom function and explore various useful topics and concepts in VBA.
- Identify coding errors and manage errors in your data.
- Publish custom functions and share with colleagues.
- Create events and automate tasks.
- Source large datasets.
Who Will Benefit
Aspiring business analysts or professionals who want to expand their knowledge of Excel, as well as anyone with an interest in investment banking, sales and trading, treasury, or other areas of.
Prerequisite(s)
Participants should have a solid understanding of Excel prior to registering for this course.
How to Access the Course
This is an online session. This course is available 24 hours a day, 7 days a week. Once registered, you can access the material at any time.
However, you will only have access to the course for 90 days after REGISTRATION.
New mobile learning! Download Blackboard Learn from your app store (iOS or Android). Learn more.
To access the course on your computer please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.
Please allow up to 15 minutes after registration for the course to appear on your BlackBoard page.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Sebastian Taylor is the principal consultant at Octopus Analytics, working in partnership with the Corporate Finance Institute® to deliver world-class business intelligence courses. He has held several senior management roles and has spent the last 12 years delivering complex analytical and automation solutions in the energy, finance and retail sectors.