Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Whether you work for a large or small organization, you probably use Microsoft Excel. Your job likely involves analyzing, summarizing, and reporting data. It might also involve building models to help reduce costs, increase profits, or better manage operations.
The course will teach participants how to use Microsoft Excel more competently to analyze data, create models, and generate insights. Participants will learn all of the key skills needed to excel as a business analyst and learn techniques to solve any business problem in any industry.
Participants will learn how to work with data, sort and filter lists, create charts, use formulas, conduct text manipulation, and leverage multiple lookup functions, create PivotTables, use data analysis tools, generate array formulas, visualize data, and conduct detailed statistical analysis.
Schedule
- December 14, 2026, 8:30 a.m. - 12:30 p.m.
- December 15, 2026, 8:30 a.m. - 12:30 p.m.
- December 16, 2026, 8:30 a.m. - 12:30 p.m.
- December 17. 2026, 8:30 a.m. - 12:30 p.m.
Key Takeaways
Upon completion of this course, you will be able to:
- Understand and learn many of the key formulas, functions, and tools in Excel to conduct basic to advanced data analysis and model building.
- Create flexible and dynamic models, charts, and graphic visualizations using Offsets.
- Employ the suite of What-If-Analysis tools to perform powerful sensitivity analysis and optimization.
- Use Formula auditing tools to understand and diagnose spreadsheet and model errors.
- Conduct detailed statistical tests and analysis using the Data Analysis ToolPak
- Discover multiple ways to visualize data to transform basic information into actionable insights.
Who Will Benefit
Business professionals that need to learn key Excel skills to analyze data, business professionals that need to develop broader analytic capabilities to make faster and smarter business decisions, and analysts that want to build their analytical capabilities and learn techniques to solve business problems.
Prerequisite(s)
Attendees must use a laptop with Microsoft Office 2013 or newer installed.
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)
David Elsner is the President of DHE Consulting, providing training, consulting, and analytical solutions to organizations. Working across a number of industries, his specialties lie in solution implementation, guiding businesses to make use of their data assets, and developing cost-saving strategies. An experienced lecturer, David provides analytical and professional classes to clients including the Rotman School of Management and CPA Ontario.