Excel and Python: A Tale of Two Powerful Tools (LIve Webinar)
Overview
Technical Requirements
Because Python does not run natively inside Excel, a brief setup is required to ensure a smooth experience. This workshop is designed as a beginner-friendly, live seminar and hands-on lab. To follow along effectively, participants will need the tools installed in advance so we can focus our time on the core material.
Please ensure all of the technical requirements are completed before joining the session.
- Personal laptop. Windows is preferred, as demonstrations will be done on Windows.
- Why personal? Company-managed devices often restrict software installation, which may prevent required setup.
- Microsoft Excel (Microsoft 365 version) signed in with a personal Microsoft account. (see how-to)
- Preferably desktop app
- Alternatively, Excel Online (via Microsoft Account, see “2”)
- Why personal? Organizational accounts often block add-ins needed for this workshop.
- Anaconda Code and Anaconda Toolbox, signed in with an Anaconda Account (see how-to)
Course Description
Applicable for
This seminar will benefit the following groups:
- Analyst(s) who works with detailed data and is frequently tasked with generating accounting reports or visualizations for recurring or ad-hoc analysis.
- Manager(s) who seeks inspiration and opportunities to increase their team’s reporting productivity with Microsoft Excel, or who aims to enhance their knowledge and literacy to navigate change management as their staff begin to utilize these tools in their domain of work.
Content
- Learn dynamic array functions in Microsoft Excel.
- Utilize dynamic array functions to process, manage, and perform advanced operations on data in Excel.
- Explore Python and its integration with Excel. Discover Python for data analysis and data visualization.
- Apply Python in Excel to tackle data processing and data visualization tasks.
- Understand the potential, impact and trade-off of using Python in Excel.
- Understand the current analytics landscape, data technology landscape, and basic concepts of cloud computing.
Course Dates & Registration
Improving Your Virtual Learning Experience
Live webinars have varying levels of expected interaction, with some requiring microphone and camera capabilities to support a proper learning experience – please email pdreg@bccpa.ca if you have concerns.
In general, we encourage participants to have their cameras turned on to enhance their virtual learning experience. This practice promotes a stronger connection with the instructor and fellow participants, and fosters improved communication and collaboration.
Live Webinar FAQs can be found here.
Registration terms and conditions, including the cancellation policy can be found here. If you require further assistance, please contact the PD Department.
- 7
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 10
- Credits
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.
Excel and Python: A Tale of Two Powerful Tools (LIve Webinar)
- 7
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 10
- Credits
Overview
Technical Requirements
Because Python does not run natively inside Excel, a brief setup is required to ensure a smooth experience. This workshop is designed as a beginner-friendly, live seminar and hands-on lab. To follow along effectively, participants will need the tools installed in advance so we can focus our time on the core material.
Please ensure all of the technical requirements are completed before joining the session.
- Personal laptop. Windows is preferred, as demonstrations will be done on Windows.
- Why personal? Company-managed devices often restrict software installation, which may prevent required setup.
- Microsoft Excel (Microsoft 365 version) signed in with a personal Microsoft account. (see how-to)
- Preferably desktop app
- Alternatively, Excel Online (via Microsoft Account, see “2”)
- Why personal? Organizational accounts often block add-ins needed for this workshop.
- Anaconda Code and Anaconda Toolbox, signed in with an Anaconda Account (see how-to)
Course Description
Applicable for
This seminar will benefit the following groups:
- Analyst(s) who works with detailed data and is frequently tasked with generating accounting reports or visualizations for recurring or ad-hoc analysis.
- Manager(s) who seeks inspiration and opportunities to increase their team’s reporting productivity with Microsoft Excel, or who aims to enhance their knowledge and literacy to navigate change management as their staff begin to utilize these tools in their domain of work.
Content
- Learn dynamic array functions in Microsoft Excel.
- Utilize dynamic array functions to process, manage, and perform advanced operations on data in Excel.
- Explore Python and its integration with Excel. Discover Python for data analysis and data visualization.
- Apply Python in Excel to tackle data processing and data visualization tasks.
- Understand the potential, impact and trade-off of using Python in Excel.
- Understand the current analytics landscape, data technology landscape, and basic concepts of cloud computing.
Course Dates & Registration
Improving Your Virtual Learning Experience
Live webinars have varying levels of expected interaction, with some requiring microphone and camera capabilities to support a proper learning experience – please email pdreg@bccpa.ca if you have concerns.
In general, we encourage participants to have their cameras turned on to enhance their virtual learning experience. This practice promotes a stronger connection with the instructor and fellow participants, and fosters improved communication and collaboration.
Live Webinar FAQs can be found here.
Registration terms and conditions, including the cancellation policy can be found here. If you require further assistance, please contact the PD Department.
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.