Top 10 Excel Functions
List of Top 10 Most Useful Functions in Excel 2016
If the question is, What are the most useful functions in Excel? Then maybe one person will give a different answer. But I hope everyone will mention the following 10 Most Commonly Used Excel functions. Because these are the ones that are used more in our daily tasks. So if you know them, it will be easier to do your daily tasks and save a lot of time. IF () COUNTA () COUNTBLANK () COUNT () VLOOKUP () IFERROR () CONCATENATE () COUNTIF () AVERAGEIF () SUMIF () IF () If means we all know – if. And the work of the IF function is actually like this. It will find you such a result, where if is there. Suppose you are going from a database, where it says – if the value of X is greater than Y, then the value of Z will be set. In all these cases, you can easily get your data using IF Function. [Watch the video below carefully from start to finish for details] COUNTBLANK () COUNTBLANK function counts the number of empty cells. That is, how many cells are empty or how many cells do not have any data in your data can be found using COUNTBLANK Function. [Watch the video below carefully from start to finish for details] COUNT () COUNT function is used to count cells containing numbers or dates, excluding zeros. [Watch the video below carefully from start to finish for details] COUNTA () On the other hand, COUNTA will count everything… numbers, dates, text or a mixture of all these, but does not count empty cells. COUNTA stands for count all. [Watch the video below carefully from start to finish for details] VLOOKUP () VLOOKUP is one of my favorite functions and it is one of the Most Useful Functions in Excel. With VLOOKUP, we can find the data we want from a large database in a moment. Much like software. For example, suppose you have a large Employee Database, if you want, you can use the VLOOKUP Function to find all the information about an Employee from there using the Employee ID. [For details, watch the video below carefully from beginning to end] IFERROR () Many times, the correct value or result of the formula or function we write does not come. It can be for various reasons. For example, due to making a mistake in the formula, or due to giving the wrong cell reference, or due to not inputting the correct data, etc. So when the result of our formula or function is wrong or errors, usually: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! These things come up. And if we want that even if the formula or function used is wrong, what we want should come out without writing #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! (for example: Invalid ID/ Data not Found or match). In that case, we can use the IFERROR function. [For details, watch the video below carefully from beginning to end] CONCATENATE () The CONCATENATE function is used to join any two data together. Although we can do this with “&” if we want. [For details, watch the video below carefully from beginning to end] COUNTIF () The function of COUNTIF is Count cells that match criteria. This function [ =COUNTIF (range, criteria)] has a range and criteria. It counts specific criteria within the data of a specific range. COUNTIF is a function to count cells that meet a single criterion. COUNTIF can be used to count cells with dates, numbers, and text that meet specific criteria. The COUNTIF function supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching. [For more information, watch the video below from start to finish] AVERAGEIF () =AVERAGEIF (range, criteria, [average_range]) The AVERAGEIF function in Excel calculates the average of cells that meet one criteria. [For more information, watch the video below from start to finish] SUMIF () The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria. [For more information, watch the video below from start to finish] [su_divider top=”no” style=”double”]