Learn the insider tips that will set you apart in your LBO modeling tests, allow you to audit complicated models, and help you hit the ground running when you start the job.
In this masterclass, you'll learn:
- Sensitivity analyses (aka Data Tables): Building the model is just step one, the real trick is understanding the drivers of value and what causes those values to change.
- CHOOSE and OFFSET (aka Scenarios): Master the two basic Excel Functions every top investment banker must know to create cases in models
- SELF REFERENCING IF STATEMENTS: Learn to use "sticky cells" to create summary tables.
- Using Data Tables to power and update those summary tables.
- Data Validation and Combo Boxes: Create and use these to control cases