How to detect hard-coded inputs within formulas in your Excel spreadsheets

In this episode of Financial Model Detective, I show you how to detect hard-coded inputs within formulas in your spreadsheets.

I show you three methods:
1. Bird view
2. Acid test
3. User Defined Function

You can also read my blog post on the same topic from here:

Materials referred in this video:

- Project Finance model review checklist

- How to add a VBA code that you find on the internet into your Excel spreadsheet?

-Applying financial modeling standards to your VBA Macros

💡 If you want to learn more about my online courses please check here:

💡 Check out my website and if you like what I do, make sure you subscribe to my newsletter:

Who is the Financial Model Detective?
Hedieh has made financial modelling her profession and passion. She has worked since 2008 as the financial modeler and was the lead modeler for several Mega green field projects in Africa.
She is the author of a book on project finance model audit called:" Financial Model Detective"

[sanazdaniellefotoohi]

So if we have OAK then we run OAK? but the annual fee of OAK is expensive. I know of it but I don’t have it, so this is very useful. Thank you.