On Demand (eLearning)

Advanced Financial Modelling Using Excel Course Bundle

JAN 02 - Dec 31, 2022

Online

DATE

JAN 02 - DEC 31

2022

TIME

9:00 AM - 6:59 PM

WHO CAN ATTEND

All

PD HOURS

19.5 Hours

ETHICS HOURS

0 Hours

STATUS

Registration open until

Dec 31, 2022

EVENT DESCRIPTION

NOTE: This is an on demand learning bundle. This course suite is available 24 hours a day, 7 days a week. Once registered, you can access the material at any time. However, you will only have access to the course for 30 days AFTER REGISTRATION.

Build financial statements and perform analysis using advanced Excel functions.

This bundle includes two online courses:

1. Advanced Excel Formulas (6.5 hours)

Learn to set up a template with advanced formulas, functions to structure an intelligent design for financial analysis. Create data tables and pivot tables to display information in charts and graphs to show results. To speed up analysis, you’ll record macros, and create additional user interfaces.

Click to see the full course description for Advanced Excel Formulas.

2. Advanced Financial Modelling and Valuation (13 hours)

Level up your financial modelling skills with a case study on how to value Amazon.com, Inc. (AMZN). Using video-based lessons, learn how to build a detailed financial model for a public company. You will learn all the formulas and functions necessary to calculate the detailed mechanics of Amazon’s financial model.

Click to see the full course description for Advanced Financial Modelling and Valuation.

PREREQUISITE KNOWLEDGE

This course is designed for proficient Excel spreadsheet users looking to take their skills to the next level.

KEY TAKEAWAYS

  • Create auto-updating Excel spreadsheets
  • Build dynamic financial statements
  • Draw on advanced functions for insightful analysis
  • Build a complete financial analysis, including downloading financial data
  • Examine intrinsic value and internal rate of return (IRR)
  • Discuss long-term debt, capital and finance leases
  • Understand the strategic analysis process
  • Perform comparable company analysis

WHO WILL BENEFIT

Financial analysts and other finance professionals working in investment banking, equity research, corporate development, financial planning and analysis (FP&A).

PRICING

$797.00 Personal Passport

$818.00 Organization Passport

$839.00 Member

$839.00 Student

$1126.00 Public

Status: Registration open until Dec 31, 2022

LOCATION

Online

SPEAKER(S) BIO

Tim Vipond is an entrepreneur, financial analyst and former investment banker. He has worked across a wide range of corporate finance, financial modelling and forecasting roles at CIBC World Markets and Goldcorp Inc. Tim is the CEO of the Corporate Finance Institute®.

Lisa Dorian has designed and delivered courses for the financial services and corporate sectors in strategy and analysis to numerous organizations, including Bank of Montreal, Deutsche Bank, and ATB Financial. Lisa is a CPA and Managing Director of MDA Training Inc.

Scott Powell has over 15 years of experience designing and delivering Wall Street training programs for many of the world’s large investment banks. His clients include Allied Irish Bank, Bank of America and Merrill Lynch. Scott specializes in financial modeling, business valuations, and asset management.

SPECIAL INSTRUCTIONS

These are online sessions. The courses are available 24 hours a day, 7 days a week. Once registered, you can access the material at any time.

However, you will only have access to the courses for 30 days AFTER REGISTRATION.

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 at least four hours after registration for the seminar to appear on your BlackBoard page.

Registration, cancellation, withdrawal and all other CPA Ontario Program policies can be found here.