Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Through this online seminar, you will learn basic Python skills, automate the collection of data and produce Excel reports using Python.
Python is a free, popular and growing coding language that is easy to learn. Using Python can expand your data and automation capabilities when combined with Microsoft Excel. This online seminar will teach you the basics of combining Python with Excel, answer your questions and work through practical examples.
Schedule
- December 2, 2026, 1:00 p.m. - 5:00 p.m.
- December 4, 2026, 1:00 p.m. - 5:00 p.m.
Key Takeaways
By the end of this seminar, you will:
- Learn the basics of Python (variables, lists, loops, if/else logic, functions).
- Use powerful coding libraries, such as Pandas, to work with row/column data.
- Scrape financial data from the web and import data from text files and Excel.
- Export data to create Excel reports and text files.
- Automate the cleaning, summarizing and visualizing of data.
- Practice challenges to exercise coding muscles and think algorithmically.
Who Will Benefit
This workshop is designed for financial professionals who want to learn how Python can help them automate reporting and work together with Excel.
Prerequisite(s)
- It is recommended to download and install Anaconda on your personal computer then open the ‘Jupyter Notebook’ application.
- Use your internet browser to code online using Google Colab.
- Simply watch the class and apply the learning later in a coding environment of your choice.
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)
Scott Cuthbertson is a Data Scientist, Data Analyst and Coding Instructor who has been teaching with CPA for over a decade. He has worked with data in management consulting, financial services, retail, government and transportation. He develops models, reporting, dashboards and algorithms for any organization that wants to make sense of their data for decision making.