Unlock the next level of modeling - dominate the competition!

„There is a better way to create models - ultra flexible and performant - that you should be taking advantage of"

- Accelerate the process of setting up and amending models (with the help of our object-oriented Excel setup)
- Reduce the effort to comprehend/follow and review model build-ups (by utilizing template structures)
- Produce highly flexible, and performant, battle-tested model structures (that will help you get your job done) 

Short description:

We introduce the toolkit - functions and structural elements - that enable us to set up object-oriented models.

Then, we will discuss the best practice model approach that is prevailing in the financial industry, point out the disadvantages, and introduce advanced models that allow for maximum flexibility. 
 

We reason that template-based modeling is objectively superior in all aspects of good model and introduce our Rollout-Kill-Model approach, which yields the above-stated benefits. Thereafter, we explain the system that make use of sophisticated modeling concepts (softlinks, Flexibility Frames, flexible cases, flexible consolidation, overviews) and put performance optimization measures into place. This allows us to "eat the cake and have 'em too" as we can thereby create models that are both highly flexibility and highly performant.

Finally, we introduce Input-Template-Models, provide context to its use-cases of incorporating inputs and calculations on the same tab, and explain the setup and its functionalities.

„Everybody teaches how to set up financial models. Only we show how to set up advanced universally applicable model structures. We discuss the various model types, when to apply them, and show you how to put them into place by utilizing sophisticated, battle-tested modeling concepts (object-oriented Excel environment, sandbox - live mode etc.)." ~ TJ

Syllabus:

I. Toolkit
201 Reference Functions I
202 Reference Functions II
203 Names
204 Strings

II. Flex-Case Models
205 Flex-Case Models
206 Advanced Flex-Case Models

III. Rollout-Kill Models
207 Templates
208 Core Setup
209 Cases
210 Consolidations
211 Overviews
212 Performance Optimization
213 Sandbox - Live Mode

IV. Input Template Models
214 Input Template Models
215 Multi Tab Operations
216 Tab Roll-Out & Optimization

Methodology:

Streamlined, time-efficient learning, structured for maximum impact. Your time is valuable, that’s why every video has been thoughtfully scripted to ensure maximum clarity and efficiency. We deliver concise, well-structured lessons that get straight to the point, eliminating unnecessary detours or filler content. Explore our learning methodology.

16 lectures - 13 tutorials - 16 quizzes - 5 hours of video content - estimated time to acquire the skills: 25 hours  

Prerequisites:

- A Microsoft Excel license (preferably in English)
- A Windows operating system is advisable (to allow for optimal use of keyboard shortcuts)
- Completion of the "How to Model" course is recommended