Do you find yourself repeating the same actions or tasks in your spreadsheets? Do you have a time-consuming Excel-based process that you want to automate? Do you want to control how Excel acts when a file is opened, closed, saved or printed?
Formulas and functions are the building blocks that enable Excel to perform calculations. So think of any scenario that involves addition, subtraction, division or multiplication and that's where you'd use a formula.