1 to 11 of 11 events
Microsoft Excel Visual Basic for Applications (VBA) is the programming language that underlies Excel spreadsheets. Excel VBA is a powerful tool that extends the capabilities of Excel, manipulates spreadsheets and automates tools and dashboards.
Many financial professionals needlessly spend time manually performing repetitive tasks that can be easily automated. An introduction to Excel VBA can result in time savings, reduced errors from repetitive fatigue, greater Excel self-sufficiency and more efficient spreadsheet models.
JUL 12 - Jul 21, 2022
6:00 PM - 8:30 PM
15 PD Hours
0 Ethics Hours
Registration open until Jul 07, 2022
Summer Sale. Discount already applied.
JUL 13 - Jul 14, 2022
8:30 AM - 12:30 PM
7.5 PD Hours
Registration open until Jul 08, 2022
This seminar is intended for CPAs who are required to explain technical concepts through written forms of communication.
During the program, we will create a checklist for drafting professional emails and documents. The overarching goal of this program is to help you visualize your own communications from the perspective of your readers. Whether your readers are clients or team members, they will rarely possess the same knowledge as you. While a client may be unfamiliar with certain accounting concepts, a team member may be unfamiliar with the file you are working on. In order to write effectively, writers must bridge the knowledge gap between them and their readers.
JUL 06 - Jul 07, 2022
1:00 PM - 5:00 PM
Registration open until Jul 03, 2022
This course has shifted online into two, half-day sessions.
This seminar focuses on the core part of a mergers and acquisitions (M+A) project: how to plan, evaluate, analyze and then synthesize the information accumulated. The due diligence process has multiple objectives: deciding whether to proceed, providing a basis for pricing the transaction, and preparing for life after the deal is consummated.
JUL 19 - Jul 20, 2022
Registration open until Jul 14, 2022
This session explores the detection and deterrence of fraud, and is led by a full time forensic accountant. This includes examples from real-life experience with lawyers, government organizations, and other accountants. Case studies will comprise a significant portion of the session. Learn how to detect the "red flags" of fraud. The attendee will understand the mechanisms of risk tolerance and management, as well as fraud prevention, deterrence, and mitigation. In addition, the attendee will learn how to use fraud-risk assessment in his or her organization.
This seminar focuses on the recovery rules applicable to GST/HST and Quebec sales tax (QST) to maximize tax recovery. Participants will gain insight on how to avoid the pitfalls and reduce audit exposures while maximizing tax recoveries.
The recovery of tax is one of the most common areas prone to audit assessments. This insightful overview will include a detailed examination of the documentation requirements, when and how to claim input tax credits and restricted expenses for both large and small to medium sized businesses. A comprehensive overview of the recovery rules using common everyday examples to illustrate the key technical issues, employee expense reports and company credit card issues will also be discussed.
JUL 26 - Jul 27, 2022
8:30 AM - 12:30 AM
Registration open until Jul 21, 2022
For professional accountants that have not exercised those management accounting muscles in some time (maybe since university), this course will help participants apply management accounting concepts to generate new ideas for problem solving.
A guide to employment law for financial professionals.
A company’s greatest asset is its employees. The recruitment and termination process presents opportunities and challenges for every type of employer. This CPA Ontario webinar will highlight what to consider and prepare for when hiring, performance managing, and when an employment relationship has come to an end. Participants will gain an understanding of employment law and human rights legislation as part of this webinar.
Jun 27, 2022
12:00 PM - 1:00 PM
1 PD Hour
Registration closed on Jun 22, 2022
Summer Sale. Discount already applied.
Take your virtual presentation skills to the next level.
This on demand CPA Ontario course will teach you charismatic communication skills to present your ideas, participate in meetings, and socially converse in today’s virtual world. We are communicating online all the time now, and this course will help you project clarity, trust and confidence. Learn charismatic vocal tone techniques to convey enthusiasm and use technology to your advantage to look your best on camera.
Jul 14, 2022
5:00 PM - 7:00 PM
2 PD Hours
Registration open until Jul 11, 2022
Learn strategies to innovate and lead in a team setting.
Successful team collaboration requires self-awareness, collaboration skills and the right type of thinking for the right challenge. This CPA Ontario course will explore how to innovate and lead in a team setting.
Participants will discover how to develop self-awareness around their thinking preferences and build the skills necessary to lead team collaboration towards positive outcomes. This course will discuss how to find creative solutions to complex team problems, how to increase a team’s ability to innovate and suggest strategies to stay ahead of the competition.
JUL 21 - Jul 22, 2022
Registration open until Jul 18, 2022