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...
This article is made especially for those who regularly export large data volumes to Excel in order to analyze them or process some kind of regular report. Usually, we...
I must say right from the beginning that even though this process is possible, I do not recommend it (but I will show it to you anyway) :). Launching...
Import of Excel sheet or csv file into SQL Server is a quite common task. You can find a guide on how to do it below. Let’s have an...
Did you ever need to compare 2 lists and test it for duplicities? The easiest way to do it in Excel is to use standard functions as VLOOKUP. Sometimes...
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...
Powerpivot in excel is an add-in automatically pre-installed in MS Office 2013 + (all you need to do is add it to the ribbon). It is not present in...
Powerpivot is an excel add-in enabling data modeling and analysis in familiar Excel environment which is certainly an advantage. Import big amounts of data through Power Query and connect...
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...
Most calculations in the area of financial mathematics are relatively easy – for example, to calculate an annuity payment, interest rate or target amount value with regular deposits. However,...