Financial model excel formatting

Excel financial model formatting guide

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 in excel

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? …

EXCEL training- SUMIF

24. SUMIF: 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 …