Acquire top notch modeling skills - benefit from the legacy of generations of analysts and associates in top investment banks

"Learn the rules of the game and play it better than everyone else"

Key objectives:

- Increase speed
- Reduce error susceptibility
- Improve quality of work

We will show you how to efficiently navigate within Excel and introduce you to our optimized setup. This will enable you to significantly boost your speed. 

We will share THE key principles of modeling, break down its key components, and point out the do’s and don'ts by taking apart financial models. 

You will learn how to model properly, and thereby not only improve the quality of your work, but moreover reduce the likelihood of committing mistakes.

In addition, we will teach you how to systematically review Excel files, which will further reduce error susceptibility.

"You don't teach students how to model effectively by giving them an example to replicate. After that, they would only know how to tackle this one example. You need to teach them the underlying principals to enable them to come up with their own solutions." ~ TJ Smasher

Syllabus:

I. Navigation Optimization
101 Efficient Navigation
102 Calculations - Sheet Mode
103 Calculations - Cell Mode
104 Data Entry Optimization

II. Setup Optimization
105 Program Settings
106 Quick Access Toolbar
107 Styles
108 Template
109 Template Print-Readiness
110 Working with Templates

III. How to model
111 Structure Conventions
112 Calculation Nesting
113 Color Coding Conventions
114 Calculation Conventions
115 Inputs, Notes & Comments
116 Linking Conventions

VI. How to Audit
117 Workbook Preparation
118 Automatic Checking
119 Manual Checking
120 Testing