Excel Modeling Fundamentals - On-demand

Excel Modeling Fundamentals - On-demand
CFI is a global provider of online financial training courses with a focus on practical applications. Most courses involve hands on Excel tutorials, which take participants beyond the theory to develop job-based skills. All participants are automatically issued certificates of completion after successfully finishing each course. The price of the course varies and are based on a function of a few criteria including, (1) their duration (CPD hours), (2) level of difficulty, and (3) demand for the topic.


EL19200031 

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 

1 Passport Day - 4 PD Hours
When
4/1/2019 - 3/31/2020
Where
On-line