There are so many functions available in Microsoft Excel but we are here to show you some of the top and most usable functions in excel.
- COUNT
If you want to count a number of cells then you can use the COUNT function. You can count a number that will not empty. If you have an empty cell then it will not be counted in the COUNT function in excel.
- SUM
If you want to sum up digits then you can use the SUM function in Excel. The SUM function in excel sums all values in column A.
- IF
The IF function in excel checks whether a condition is met and returns one value if right and another value if wrong.
- AVERAGE
To compute the average of a group of numbers, use the AVERAGE function in excel. You can find the average of any numbers you want.
- COUNTIF
In the COUNTIF function in excel, you can count cells that contain a specific word or value.
- SUMIF
The SUMIF function in excel below You can see the example
- VLOOKUP
The Vlookup function below looks up the value 53 in the leftmost column of the table (second argument). The value 4 (third argument) means the Vlookup function to return the value in the same row from the fourth column of the table.
- MIN
If you want to find a minimum value then you can use the MIN function in excel.
- MAX
If you want to find a maximum value then you can use the MAX function in excel.
- SUMPRODUCT
To compute the sum of the products of related numbers in one or more ranges, use Excel’s strong SUMPRODUCT function in excel.
