10 Most Used Excel Formulas

Top 10 Excel formulas

Excel is important for beginners, intermediate and advanced users alike, there are 100’s of formulas in excel which you can learn but in our regular usage the following 10 formulas are the most used excels formulas

Here is the list of top 10 most used excel formulas

1.       If formula in Excel  – If formula checks whether a condition is met or not can be used to make awesome logical combination formula  -

2.       Sum formula in Excel – Adding numbers in Excel is the most common function used by Excel users and Sum formula can add numbers in breeze for you.

3.       Or Formula in Excel  – checks whether any of the conditions in a logic are true, it will return a false value if none of the conditions are met.   

4.       Average Formula in Excel – another most used function in excel is finding the Average of a given values and Average formula in excel is best for that.

5.       Vlookup Formula In excel – The most famous formula and probably the most feared formula in excel is the Vlookup formula which is used to effortlessly lookup results from databases  

6.       Pivot Table in Excel – Pivot Table is not a formula but I had to include it in this list as its the most powerful tool in excel that help you in analysis, reports , visualization with simple drag and drop options.  

7.       Count Formula in Excel - Counting cells containing values can be an important function for any excel user and Count formula in excel can help yo in find the number of cells that contain values.

8.       CountBlank Formula in Excel – Something knowing how many cells are empty in data set is all that you want and the Countblank formula can find the count of empty cells in a data set.

9.       Dropdown list in Excel  – having Dropdown lists in excel can save both time and effort plus eliminate the chances of wrong data entry to a large extent.

10.   Sumif Formula in Excel – sometimes you just want to add cells that meet a certain condition and the Sumif formula in excel can do just that for you

11.   Rank formula in Excel – Knowing who ranks above whom is such a an enlightening experience and the Rank formula can rank values in any size of dataset in the most easy manner. 

You can also visit http://www.myelesson.org to learn Excel in Hindi.