This module is designed as a leveling course for founders and entrepreneurs who are new to spreadsheet tools like Microsoft Excel and Google Sheets. It starts with the basic building blocks of formula-building, and advances into reference functions like INDEX+MATCH.
We focus on the tools that you'll need to connect most financial models.
Agenda:
Driver-based modeling is the single most important lesson we will be teaching in this bootcamp. This module is the key to unlocking your understanding of financial models and will allow you to dissect and break down any type of business into parts that you can model on a spreadsheet.
Curriculum:
Now that we understand the basics of how financial models work, we’ll get to building our first formulas to connect the maps that we’ve been working on.
Curriculum:
We’ve built our first financial model, but we need a better canvas to work on if we want to scale the spreadsheet. We’ll walk you through the (free) template our team built, and that over 20,000 startups have used as a starting point.
Curriculum:
With a superpowered canvas to work from, we now move into connecting a complete model map inside an existing financial model template.
Curriculum:
At this point we have a fully functional financial model we can use to estimate anything we want. It’s now time to put it to good use to answer the questions a founder needs to solve before pitching investors.
Curriculum: