What is a formula in Excel?

A formula is a way for you to make calculations based upon data written in the spreadsheet.

What’s best about formulas is that they are linked to the data in such a way that if the data changes, the formula gives an updated result, reflecting the change.

The fill handle is especially useful, as often you need to repeat the same formula many times. In such cases using the handle can be a great time saver.

One of the important parts of learning formulas is understanding the concepts of absolute referencing and relative referencing. Take the time to watch the video dealing with it, and the next one with simple examples demonstrating how it is been implemented in the formulas.