Select Page

## Excel SLN Function

The SLN function is a Finance function that calculates the depreciation of an asset on a straight-line basis for one period. In this guide, we’re going to show you how to use the SLN function and go over some tips and error handling methods. Supported versions All...

## How to extract date from string in Excel

In this guide, we’re going to show you how to extract date from string in Excel by using formulas and VBA. Download Macro-Free Workbook Download Workbook Note that, there isn't a single formula or approach that can handle all scenarios. Extracting dates from strings...

## Function: QUOTIENT

QUOTIENT is a Math and Trigonometry function which calculates and returns the integer portion of a division. This function can be especially useful for when you want to discard the remainder of a division, and not any of the values. In this guide, we’re going to show...

## Function: PROB

The PROB function is a statistical function that can calculate the probability associated with a given range. The function is useful for calculating the probability for the occurrences having discrete probabilities of an event. In this guide, we’re going to show you...

## Function: VARPA

The VARPA function is a statistical function that can calculate and return the variance of a population by evaluating text and logical values. Variance provides a general idea of how much data points are spread in a data set, and can be used to calculate the standard...

## Function: VARP

The VARP function is a statistical function calculates and returns the variance of a population. Variance provides a general idea of how much data points are spread in a data set, and can be used to calculate the standard deviation or determine the risk of an...

## Function: VAR.P

The VAR.P function is a statistical function that can calculate and return the variance of a population. This formula was essentially introduced as a replacement for the outdated VARP function. Variance provides a general idea of how much data points are spread in a...

## Function: VAR

The VAR function is a statistical function calculates and returns the variance of a sample. The variance provides a general idea of the spread of data, and can be used to calculate the standard deviation or determining risk of an investment. In this guide, we’re going...

## Function: CHISQ.TEST

The CHISQ.TEST is a Statistical function that calculates the chi squared (χ2) distribution and returns the probability of a value chi-squared (χ2) between observed and expected data. The chi squared (χ2) test can be used to assess the relationship between two data...