14. IF: Startup and investor excel model training

TL;DR: Learn how to use the excel IF function. This is really important to learn!

IF? IF what? Exactly 😉 You can do super powerful things when you ask the question IF. IF is basically the foundation of any complex formula where something happens IF a condition is met. IF client’s ARPU is greater than 50 then mark them as a VIP. Sure you can see how that is useful, right? But do you know how to use it?

UPDATE: I was originally planning on dealing with “IF” later, but writing the classes, I realised doing it earlier would enable us to make better uses of learnings and apply them to formulas. IF is really the workhorse of Excel!

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 you will only learn the most useful things; those that I actually use regularly. We’ll go through the obvious applications, but also include some hacks I’ve developed over the years.

To get the excel example for this and all the other instalments, subscribe with the pretty box on the right and you’ll get the excel tip of the day sent directly to your inbox. Within a month and ten minutes practice, you’ll be a boss in no time.