1 cell, 1 formula: 5 Excel functions that replace repetitive calculations

For longer than I care to remember, I’ve written Excel formulas, dragged them down hundreds of rows, copied calculations across columns, and built running totals one cell at a time. This works, but I always find I’m doing too much work, especially when some of those jobs can be handled by a single formula sitting in a single cell.