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
- May 20, 2025, 8:30 a.m. - 12:30 p.m.
- May 21, 2025, 8:30 a.m. - 12:30 p.m.
- May 22, 2025, 8:30 a.m. - 12:30 p.m.
- May 23, 2025, 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 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)
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.