How to do Percentage Breakdown of Items in an Excel List

  Let's say you own a grocery store. You sell different items. As you know, due to the corona virus pandemic the nature of purchases has c...

How to Calculate Variance in Excel

What is Variance? We use the variance of data to estimate the range of  future value in series. The variance tells how much data can vary from the...

How to Get Most frequently appearing Number in Excel

If you want to look up the most frequently appearing number in a range, this article is for you. Generic Formula For a single value. ...

Excel Formula to Sort Text

Earlier, we learned about the sorting of numeric values in Excel. In this article, we will learn how to sort text values using an Excel formula. It w...

Sort Numeric Values with Excel RANK Function

We have already learned the direct sorting of numeric values in Excel. In this article, we will sort numeric values with the help of Excel RANK funct...

How to Use Excel NORM.INV Function

The NORM.INV function is used to get INVERSE CUMULATIVE DISTRIBUTION FUNCTION (ICDF). The ICDF is used to know the value associated with a probability...

How to Use MODE.SNGL function

The MODE.SNGL function is a replacement of the MODE function in Excel. It was introduced in Excel 2010 with MODE.MULT function. It simply returns the ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.