This tip comes from Tom Lieven, who teaches on the side in Milwaukee.
Errors can happen in Excel. Changes get made and a formula goes awry.
What if you have a large spreadsheet? It could take a lot of time to check every formula.
Wouldn't it be nice if you could catch the errors on the fly? There is a way.
You get another benefit. The formula stays hidden unless an error occurs. No mucking up the look of your spreadsheet with error checking formulas.
Check out Tom's tip in the attached spreadsheet- Error Checking
Got a favorite Excel tip to share? Send it our way to jon@financeleaders.org .