There is nothing more frustrating than when someone pastes a value on top of a formula in your spreadsheet. This can ruin a beautiful excel model. And it can take awhile to fix because you have to find the problem cell.
The F5 key saves time in Excel by letting you jump to specific cells or named ranges. But that isn't all it can do. Use this key to identify hard-coded values in a spreadsheet and protect your financial models from lazy junior analysts.
Produced by Sara Silverstein
Follow BI Video: On Facebook