Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Every day, organizations are faced with complex business problems. In most cases, information on the problem has already been gathered; but what is needed is actionable insights. The key tool in developing the insights is a performance model that applies a methodology to analyze and transform data into a useable, customizable and presentable format. Intelligent Performance Modeling using Excel is a practical class in which participants will blend data analysis skills into the construction of five interactive performance models in Excel from scratch.
Participants work alongside the instructor to apply modeling skills and techniques to better analyze organizational data, predict revenues and assess outcomes to justify business decisions. Each example will focus on a different operational scenario and a different business sector.
Topics Include:
- Understanding of general modeling techniques in Excel
- Learning how to use models to present quantitative information simply, clearly and concisely
- Fundamentals of what-if analysis in models
- Making more informed decisions based on collected business intelligence
- Understanding key Microsoft Excel functions and tools used for model building
Schedule
- September 9, 2024, 8:30 a.m. - 12:30 p.m.
- September 10,2024, 8:30 a.m. - 12:30 p.m.
Who Will Benefit
Business professionals who work with data and are often tasked with solving operational problems and finding creative solutions or act as a key part of the decision making process.
Prerequisite(s)
Attendees must bring a laptop with Microsoft Office 2013 or newer installed.
How to Access the Course
This CPA Ontario 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.
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)
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.