# Category Archives: Excel functions

## AND, OR Logical Functions in Excel

By | 23. 5. 2020

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 if a certain condition is met. Often used function IF belongs to logical functions, except for this function, you will most often use functions AND and… Read More »

## Excel | Subtotal – 11 Functions in One

By | 23. 5. 2020

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. What’s more, we can limit whether we want to calculate even with hidden values which were hidden manually. All under roof of one function. SUBTOTAL –… Read More »

## Excel – Function for date and time – YEAR, MONTH, DAY, HOUR, MINUTE, SECOND

By | 23. 5. 2020

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 have needed to extract some certain parts of the data of date and time data types, for example month. All functions have identical and absolutely simple… Read More »

## WEEKNUM, ISOWEEKNUM,WEEKDAY Excel – Was it on Friday After 15th Week of The Year?

By | 21. 3. 2020

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 date is Friday. MS Excel will help by three functions – WEEKNUM, ISOWEEKNUM,WEEKDAY . It is definitely more effective than searching in calendar. More so if… Read More »

## Weighted Arithmetic Mean in Excel – SUMPRODUCT

By | 2. 2. 2020

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 guide How Works Function SUMPRODUCT and Weighted Arithmetic Mean in Excel Example: Lets have few loans where every loan has different principal and interest rate. The… Read More »

## Excel | Text Functions – Top Functions Overview + Examples

By | 8. 11. 2019

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 text columns. There are many situations where we want to edit the text in some way (it cannot be generalized). It depends on a case-by-case, but… Read More »

## Excel | VLOOKUP vs HLOOKUP – What’s the Difference + Example

By | 8. 11. 2019

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 table containing many rows and columns. The function supports 2 modes – full and approximate match. In addition to the VLOOKUP function, there is a similar… Read More »

## Excel | Mean (Average) Functions Overview – Types, Formulas, Explanation and Examples

By | 2. 11. 2019

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 we are investigating. It belongs to the so-called measures of central tendency. If we have a large amount of data, we can describe the data with… Read More »