Advanced Excel
For Investment Banking MASTERCLASS
Register now to reserve your spot for the masterclass taking place December 15th
at 10am EST!
Advanced Excel Essentials for Banking
Stand out as a rockstar on the desk.Â
Register now to our FREE Masterclass and learnÂ
Advanced Excel functions, tricks and tools that will
give you the edge over the competition.
Register now! Spots are limited.
What You’ll Learn:
- Learn to run sensitivity analyses (aka Data Tables) on your model
- Master the two basic Excel Functions every top investment banker must know to create SCENARIOS in models: CHOOSE and OFFSET
- Learn how to create SELF REFERENCING IF STATEMENTS, also called "sticky cells" to create summary tables.
- Learn how to update those summary tables with MACROS and Data Tables
- Learn the insider tips that will help you stand out once you hit the desk.
In this 60-minute, power-packed session we'll cover:
Running Data Tables
Sensitize your model to stress test your assumptionsÂ
Create Scenarios
 Learn to create different cases and add a toggle switch to control your model
CHOOSE and OFFSET
Learn the two most powerful functions to create scenarios (as well as their pros and cons)
Self referencing IF statements
Learn to create summary tables to show outputs from various cases side by side
Insider tips and tricks
Learn additional shortcuts as well as trips and tricks to maximize efficiency
By the end of the masterclass, you’ll have the tools to build financial modelings like a Pro.
