Overview
Recommended Prep Courses
These preparatory courses are optional, but we recommend you to complete the stated prep course(s) or possess the equivalent knowledge prior to enrolling in this course:
Excel modeling fundamentals course overview
Learn the fundamentals of Excel modeling online from professional Wall Street trainers. This four-part Excel fundamentals course provides tips and tricks for Excel model builders, gives advice on how to audit your financial models, demonstrates how to use better formulas, and shows you how to monitor and handle uncertainty using scenarios planning.
Excel tips and tricks
1 - Learn how to speed up your Excel modeling skills by using keystroke navigation
2 - Significantly improve how you can edit your worksheet by learning how to use editing shortcuts in Excel 2003, 2007 and 2010
3 - Develop the skills every model builder needs to edit and model your spreadsheet in mere minutes
Better formulas for financial modeling
1 - Build flexibility into financial forecasts
2 - Break down complex calculations
3 - Minimize errors in Excel models
4 - Understand Excel function syntax
Catering for uncertainty in the model
1 - Learn how to perform sensitivity analysis
2 - Understand how data tables and goal seek can facilitate your model building process
3 - Learn how to measure the impact of future uncertainty on cash flows and profit with scenario planning
4 - Learn how to use scenario and solver tools to see how certain inputs can impact your model
Auditing a financial model
1 - Learn how to quickly and easily find errors and audit a spreadsheet
2 - Understand how the auditing toolbar can help make your spreadsheet error-free
3 - Learn how to use test data to uncover errors
Included in this module is a PDF – Excel Shortcuts Reference Guide for both PC and Mac – that can be used while taking the course and downloaded to your computer for future reference.
More about the Excel financial modeling fundamentals course
This Excel modeling fundamentals course is designed for professionals working in equity research, investment banking, corporate development, financial planning and analysis (FP&A) and other areas of finance and accounting.
For further CPE information, please read before purchasing:
https://corporatefinanceinstitute.com/about/cpe-information/
Note: This course does not offer a certificate. It is an optional prep for the Building a Financial Model in Excel course which will allow you to earn our Financial Modeling Certificate.
What You'll Learn
What Our Students Say
very good
Camila Thais Higa Lopes
If you want to get into investment banking, equity research, of a good finance position you definitely have to take courses like this. Unfortunately university doesn't teach you most of this stuff so you have to take it from professional training companies, and I can say, having taken several of them that this is one of the best. Highly recommend.
Ron T
Good for beginners and great to review all the "best practices"
Rustom Rupand
This is a very practical course for people who want to understand the art of FP&A. Good tips are explained here.