Excel Modeling Fundamentals

Excel Modeling Fundamentals
Corporate Finance Institute (CFI) on-demand courses are designed for finance professionals and industry practitioners who want to master the art of corporate finance. The courses move through three levels of mastery for anyone looking to be an expert in financial modeling, valuation, and financial analysis. Participants typically include professionals in entry to mid-level positions in financial planning and analysis (FP&A), corporate development, treasury, investor relations, and capital markets. All participants are automatically issued certificates of completion after successfully finishing each course.


NOTE: Course login details are normally sent to registrants within one week from date of registration.

EL22230011
This four part series 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 scenario planning. 

MODULE 1 - EXCEL TIPS AND TRICKS   
 
Learn how to speed up your Excel modeling skills by using keystroke navigation 
 Significantly improve how you can edit your worksheet by learning how to use editing shortcuts in Excel 
 Develop the skill every model builder needs in editing and modeling your spreadsheet in mere minutes 

MODULE 2 - BETTER FORMULAS   
 
• Build flexibility into financial forecasts 
 • Break down complex calculations 
 • Minimize errors in Excel models 
 • Understand Excel function syntax performance? 

MODULE 3 - CATERING FOR UNCERTAINTY   
 
• Learn how to perform sensitivity analysis 
 • Understand how data tables and goal seek can facilitate your model building process 
 • Learn how to measure the impact of future uncertainty on cash flows and profit with scenario planning 
 • Learn how to use scenario and solver tools to see how certain inputs can impact your model 

MODULE 4 - AUDITING A MODEL   
 • Learn how to quickly and easily find errors and audit a spreadsheet 
 • Understand how the auditing tool-bar can help make your spreadsheet error-free 
 • Learn how to use test data to uncover errors
 

CPD-
4 Hours
When
4/1/2022 - 3/31/2023 11:59 PM
Where
On-demand