The One Key That Fixes The Biggest Problem Bankers Have In Excel
Nov 5, 2014, 17:44 IST
Your browser doesn't support HTML5 video.
kalturavideoplaceholder
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.
Advertisement
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