Excel predicts it will take approximately 36.5 months to pay off the loan. Useful, right? You can build this into a spreadsheet template that allows you to experiment with different payoff periods ...

When you create loan amortization ... Suppose you have a giant Excel spreadsheet with hundreds of customer names in a column. Now you want to extract unique customers from the list.