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 11, 2024, 6:00 p.m. - 8:30 p.m.
- December 12, 2024, 6:00 p.m. - 8:30 p.m.
- December 13, 2024, 6:00 p.m. - 8:30 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 a live webinar. You must attend the live course to receive verifiable CPD hours. We recommend you join five minutes prior to the scheduled starting time. To get the full experience of this interactive course, use a computer that has video and microphone capabilities.
Electronic material can be accessed one week prior to the course and should be downloaded in advance.
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.