It's not really possible to string together a more painfully boring term than "spreadsheet auditing". Auditing is a painstaking activity that requires intense concentration, an obsessive attention to detail, and its only... read more →
We have blogged before on data tables. Their power and efficiency for sensitivity analysis is impressive. But setting them up 100% correctly is critical, because if you do not, they... read more →
On this week's Invest Florida podcast I discuss the top three categories of mistakes we make when running financial models on transactions. Check out the 40-minute audio interview here, and... read more →
Below is the Excel so you can practice (you will need to download it by clicking on the download icon in the bottom border). Don't forget to see our other... read more →
Thou shalt carry a contingency line item Thou shalt not be arrogant Thou shalt not be careless Thou shalt not hard code numbers into a formula Thou shalt not promise... read more →
Read my thoughts on it here on the Fundrise Blog.
To save a partially-constructed formula, or to inspect a formula outside of the cell in which it resides, simply put a single quote mark ( ' ) in front of... read more →
We have old saws like this because they are timeless in their validity. Here are REFM's recommendations for writing and testing formulas in Excel before deploying them in your models:... read more →