Tl;dr: Building a huge Excel model is great, using it easily is awesome. The foundation is in your formatting and knowing the code of what colors to use. It’s simple, but you need to know the rules. Then you have to apply them as frequently as you breathe. I’m going to teach you how to use font colors consistently and …
How to rebase a chart
Tl;dr: This is how you make a chart so that everything starts at 100 and grows from there so you can see the relative growth Have you ever wondered what stock has performed better or worse over a period of a year? What do things look like a year later? Did one do better than another and by how much? …
How to make your financial model look professional. Before and after example
Appearances matter. Just ask Tinder đŸ˜‰ When it comes to your financial model, you need to pay attention that not only that it makes sense but that it looks the part too. In this blog I’m going to: Explain why appearances matter Show you a real founder’s model and how I improved it in just 3 hours Teach you the …
Excel number format cheat sheet
Tl;dr: We’re going to learn to do excel number format so you can make your sheets prettier, professional and more informative. Did you know that you can do all sorts of magic in Excel to format your cells and make magic happen without formulas? Maybe you know some basics, but I’m sure you don’t know all the awesome tricks that …
25. COUNTIF: Count what matters simply – Startup and investor excel model training
Intro to Excel model training This is part of a series on Excel model training focused on helping founders and investors to actually enjoy and get proficient in excel. It’s such an important skill to have, and there’s no excuse to not be able to do all the ‘advanced’ stuff, let alone the basics. This is a pragmatic course where …