Ever googled directions to the airport?
How many routes do you get?
Is one the clear choice?
But — do they all get you there within 5 minutes?
Try to keep this in mind when building models.
It doesn't matter if you use INDEX/MATCH, VLOOKUP, or even just punch in numbers manually.
All that matters is you get the job done.
That you build a tool to help your team make decisions about the business.
No one cares how "Excely" your model is (especially not your boss).
They just care about the result.
Is information presented in a clear (and accurate) way so we know what to do next?
Then it's a good model.
If you're stuck on what function to use ask yourself,
"𝗪𝗵𝗮𝘁 𝘄𝗼𝘂𝗹𝗱 𝘁𝗵𝗶𝘀 𝗹𝗼𝗼𝗸 𝗹𝗶𝗸𝗲 𝗶𝗳 𝗶𝘁 𝘄𝗮𝘀 𝗲𝗮𝘀𝘆?"
Then do that.
If that means SUM instead of SUMIFS?
Direct linking instead of lookups?
Just typing in numbers?
You can always work on optimization later.
The goal is to arrive at your destination.
Just don't end up at the train station.
Whenever you’re ready, there are 3 ways I can help you:
1. Master the 3 statements: https://bit.ly/_Three_Statements
2. Model like a Private Equity pro: https://bit.ly/_Private_Equity
3. Add financial horsepower to your business: https://bit.ly/_Consulting