When using Excel functions play an important role in finding values for a range of cells. Learn all about using functions in Excel.
Watch the video! (11:34 min)
Download the example to work along with the video.
Each function has a specific order, called syntax, which must be strictly followed for the function to work correctly.
An example of a function with one argument that adds a range of cells, A3 through A9:
An example of a function with more than one argument that calculates the sum of two cell ranges:
Excel literally has hundreds of different functions to assist with your calculations. Building formulas can be difficult and time consuming. Excel's functions can save you a lot of time and headaches.