Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.
A common source of errors in Excel is "the gap"—a situation where you add new data to the bottom of a list, but your formulas ...