Logical functions serve us to test conditions not only in Excel. They can be used in situation when we need to compare 2 or more values and find out...
SUBTOTAL is a little strange function. There are 11 mathematical functions hiding inside it. We can calculate sum, arithmetic mean, spread, minimum/maximum and another statistic values using SUBTOTAL function....
There is a huge number of functions for date and time in Excel. they are used to extract parts of the date or time type of cell. You may...
You have a huge table with many date entries in it. You need to find out which date is after 20th week of the year or if a certain...
Weighted arithmetic mean is a statistical value of broad use not only in mathematics or statistics. If you need to calculate weighted arithmetic mean in Excel, here is a...
In Excel, we work mostly with numbers (aggregation via SUM, AVERAGE, etc.) or with dates. However, it is true that very often we need to adjust, combine or clean...
The VLOOKUP function is one of the most commonly used Excel functions in general. This function returns a value we are looking for from a particular column of a...
Let’s start with what the average means. In terms of descriptive statistics, the average is a certain reference (typical) value. It is a property of the data set that...