Before you get Excel to read your data for you, take a moment to adjust the voice. Crucially, you can't do this inside ...

Constants: This is the fastest way to audit a spreadsheet for errors. It finds every cell that contains a manually typed value rather than a formula, so you can make sure someone hasn't hard-coded an ...