Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
This seminar provides hands-on experience in completing a comprehensive data project and is designed by accountants for accountants. Participants will explore the powerful, popular open-source analytical solution R and even better, how to integrate R right into your Excel workbooks, inspiring you to enhance your accounting Life. We will delve into the mindset of analytics professionals and explore the synergy between analytics and accounting. The seminar will conclude with an overview of the current analytics and technology landscape, highlighting how accountants can capitalize on these trends. This course is designed to be welcoming for those new to analytics.
Note: This course was previously titled "Elevate Accounting with Analytics".
Schedule
- December 2, 2026, 1:00 p.m. - 5:00 p.m.
- December 3, 2026, 1:00 p.m. - 5:00 p.m.
Key Takeaways
Upon completion of this course, you will understand:
- Introduction to R: Learn the fundamentals of R, an open-source data-focused programming language for beginners.
- Super charge Excel with R: How to create and run R programs in Excel workbooks and supercharge your Excel productivity.
- Data Management with R: Gain skills in importing, exporting, and processing data using R.
- Advanced Data Visualization Techniques: Discover how to create impactful visualizations with R.
- Automate Reporting with R: Build a practical department distribution workflows with R.
- Navigating the Analytics Landscape: Understand the current trends in analytics and data technology, along with foundational concepts of cloud computing.
Who Will Benefit
This course caters to several professionals, including the following groups:
- Analysts: Ideal for those with access to detailed data who seek to automate professional reports and visualizations using free open-source tools.
- Managers: Designed for managers looking for inspiration and strategies to boost team productivity in reporting, particularly within budget constraints, or those interested in enhancing their understanding of modern analytics processes.
Prerequisite(s)
To fully engage in this course, please ensure you have access to a PC and are prepared to install the necessary open-source tools prior to the seminar. This will allow you to follow along with the hands-on exercises and make the most of the learning experience.
How to Access the Course
This course is delivered as a live webinar. To receive verifiable CPD hours, you must attend the session live. We recommend joining at least 5 minutes before the scheduled start time. For the best interactive experience, please use a computer equipped with a camera and microphone.
A reminder email with the Zoom link and course details will be sent two business days before the session. If you do not receive it, please check your spam or junk folder.
The same information, including any available materials, will also be posted in advance on our Blackboard LMS.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Andy Hu has over eight years of experience in accounting, financial analysis, and analytics engineering, Andy is dedicated to helping organizations maximize their data potential. Andy has held various analyst roles across multiple functional areas, including central accounting/finance, budgeting, academic faculty, central IT, HR ERP system migration, and institutional planning. Andy has led enterprise datastore initiatives, transformed business processes, and created value-adding visualizations that assist management at different levels while alleviating reporting burdens. As a CPA since 2020, Andy's educational background encompasses advanced accounting and management analytics.