How to use Functions in Excel

What are functions?

Functions are pre-defined formulas, built into Excel to help perform some of the common calculations used. E.g. Addition, Multiplication, Subtraction, Division, Percentages, Averages…and hundreds more.

How to Find and use Functions:

1. Click the ‘Formulas’ tab

2. Click the ‘Insert Function’ button. See diagram below.

How to use functions in Excel - diagram 1

 

3. The ‘Insert Function’ Dialog box will appear on your screen with a list of hundreds of pre-defined formulas you can use in Excel.

To locate a function – You can do a search in the search box which is provided on the Insert Function Dialog box; or you can use the default functions which appears under the category ‘The Most Recently used’.

4. We selected the ‘SUM’ function to add our numbers in Column A.

See the Diagram below

How to use functions in Excel - diagram 2

 

5. When the ‘SUM’ function was selected – The ‘Function Arguments’ dialog box appeared on the screen. Excel has also automatically selected the numbers in Column A for addition and calculated its sum, as well. See diagram below.

How to use functions in Excel - diagram 3

 

See the results of the SUM Function which we applied to the numbers in column A of our example. 

How to use functions in Excel - diagram 4

 

Lesson 47:  How to add a column or row of numbers