Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with confidence.

The Alt+Enter shortcut isn't limited to new formulas you write—you can go back and clean up any messy formulas at any time.

If you're an editor like I am or even just send more than a few emails a day, you need to use keyboard shortcuts. They're special key combinations that can not only optimize your ...