Excel has hundreds of features, and I still discover new ones every year. Some solve very specific problems, while others become so useful that they quietly earn a place in every workbook I create.

Though the practice of maintaining bookkeeping and ledger records dates back to ancient Mesopotamia, physical spreadsheet records have always suffered from the problem of requiring corrections and ...