How to format numbers as file sizes in Excel

How to format numbers as file sizes in Excel

Excel’s number formatting doesn’t support file sizes by default. However, it allows you to program your own formatting style. In this guide, we’re going to show you how to format numbers as file sizes in Excel. Download Workbook The number formatting is one the...
Function: NORMSINV

Function: NORMSINV

NORMSINV Excel formula is a Statistical function that calculates the inverse of the standard normal cumulative distribution of a specific probability. The standard normal distribution is a type of normal distribution with a mean of zero (0) and a standard deviation of...
Function: FREQUENCY

Function: FREQUENCY

FREQUENCY is a Statistical function that can calculate how often values occur in a set of data and returns the occurrence counts as a vertical array. These numbers represent frequencies can be helpful for charting histograms. In this guide, we’re going to show you how...
Function: LAMBDA

Function: LAMBDA

LAMBDA is a special function that can create custom functions in the scope of a named range. You can essentially create a user defined function without any VBA, macro, or JavaScript knowledge. In this guide, we’re going to show you how to use the LAMBDA function and...