Learn how to calculate payback and discounted payback in Excel with formulas, SCAN, XMATCH, LET, and SWITCH, plus ...

If I asked you which Excel tab you use most, there's a good chance the View tab wouldn't even cross your mind. The Insert, Formulas, and Data tabs usually get all the attention, and for good reason.

Excel's power lies in its accessibility, though this very trait makes it a breeding ground for disastrous errors. A single ...