Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
This advanced Excel training course starts with a blank spreadsheet and quickly dives into using combinations of functions and formulas to perform dynamic analysis. The main formulas & functions covered in this training course include:
- INDEX and MATCH
- IF with AND / OR
- OFFSET combined with other functions
- CHOOSE for creating scenarios
- INDIRECT combined with other functions
- XNPV and XIRR
- CELL, COUNTA, and MID functions combined together
- PMT, IPMT, and principal payment calculations
The main types of data analysis in this course include:
- Data tables
- Pivot tables
- Column and line charts
- Stacked column charts
- Waterfall charts
Note: If you’ve previously completed the CFI course “Advanced Excel Formulas” do not register for this course.
Key Takeaways
Upon completion of this course, you will be able to:
- Master advanced formulas and functions.
- Create sophisticated outputs for financial analysis, including beautiful tables, charts, and graphs.
Who Will Benefit
Professionals working in investment banking, equity research, corporate development, financial planning and analysis (FP&A).
Prerequisite(s)
Learners must have access to Microsoft Excel (or a compatible spreadsheet program such as Google Sheets or Excel Online) to complete the exercises and follow along with demonstrations. Familiarity with basic Excel functions is helpful but not required.
Disclaimer
Most of CPA Ontario's 450+ on-demand courses are compatible with the mobile app. Unfortunately, this on demand course is not compatible. For the best learning experience, we suggest you use your computer.
How to Access the Course
To access the course please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.
Please allow up to 15 minutes after registration for the course to appear on your BlackBoard page.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Tim Vipond, is the CEO and Co-Founder of CFI Education. He has extensive experience as an internet entrepreneur in financial analysis and investment banking. Beginning in 2005, Tim was an active participant in the capital markets with a wide range of experience spanning investment banking, investment management, and corporate development.