What is a formula in Excel?
It is a way for you to make calculations on data that is already 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, it will show you an updated result, reflecting the change.
The fill handle is especially useful, as often you need to repeatedly copy the same formula across the worksheet. 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 practically implemented.
The data used in the formulas does not have to appear only in the same worksheet. You can use values from cells from other worksheets inside a single formula, and so integrate data from multiple worksheets.
