Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Excel dynamic array functions and Python in Excel are both very powerful tools. This seminar offers a hands-on demonstration-driven learning environment. You will complete a series of advanced data processing and data visualization tasks that require Microsoft Excel's dynamic array functions and Python in Excel. This doubles as a quick and basic introduction to Python for data analytics to beginners. We will end our journey with a practical understanding how to consciously choose between dynamic array functions and Python in Excel.
Note: Python in Excel is still being rolled out to different versions of Microsoft Excel. Check the availability for your computing platform here: Python in Excel availability - Microsoft Support. Python in Excel is not required to attend the seminar but will be needed if you wish to follow along with the live demo during the seminar. All seminar demonstrations will be conducted through a PC (i.e. Windows OS based) computer.
Schedule
- October 16, 2025, 8:30 a.m. - 12:30 p.m.
- October 17, 2025, 8:30 a.m. - 12:30 p.m.
Key Takeaways
Upon completion of this course, you will:
- 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.
Who Will Benefit
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.
Prerequisite(s)
To get the most out of this course, you should have a few years of experience using Microsoft Excel. You should be comfortable with concepts like Pivot Tables, lookups, and basic functions such as SUM and SUMIFS.
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)
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.