Average value calculation can be helpful in many use cases. There can be a need to find average spend volume, or average transaction volume, or average height etc. Average function helps average value calculation in Microsoft Excel. Average function is
Category: Microsoft Excel
This category covers detailed articles about Microsoft Excel. Various topics around Microsoft Excel are described in detailed steps. The category is useful for anyone looking to learn MS Excel in detail.
Minimum value calculation can be helpful in many use cases. There can be a need to find minimum spend, or minimum transactions, or minimum salary etc. Min function helps minimum value calculation in Microsoft Excel. Min function is one of
Maximum value calculation can be helpful in many use cases. There can be a need to find maximum spend, or maximum transactions, or maximum salary etc. Max function helps maximum value calculation in Microsoft Excel. Max function is one of
Sum function is one of the basic function in Microsoft Excel. This is leveraged multiple times while doing any analysis. As sum remains one of the important function to work with, we will discuss basic steps to learn this function.
Microsoft Excel provide very useful tool of “Remove Duplicates”. This is present in the Data tab. It can have various use cases, and help working on data in a much easier fashion. In case the requirement is to remove duplicates
Remove duplicate tool is very handy option in Excel. It can make life easy for anyone working on data analysis. There can be a need to remove duplicates at a single column level, or remove duplicate at multiple column level.
Anyone working on Excel would have used Count many times. COUNTIF function is popular to do single criteria based counting. In case the requirement is counting of cells with multiple condition checks, then COUNTIFS is the go to function. COUNTIFS
Sum remains one of the most used function in Excel. Many a time there is a need to do summation with multiple criteria’s. In case there are more than one condition requiring check for summation, SUMIFS is the go to
To count number of cells in excel is easy with COUNT function. When there is a need to count cells with predefined condition, then we use another function. COUNTIF function in Excel is used to count cells with pre defined
Calculating sum remains an important requirement in analysis in excel. Although doing simple sum is easy, many a times user need summation with criteria’s. For example sum is required for certain categories, sum is required at specific group level. This