This category groups all articles that are in some way related to Excel. For more detailed filtering, direct your attention to one of the thematically focused categories below

Don’t miss out from category:

### AND, OR Logical Functions in Excel

• 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...

### Excel | Subtotal – 11 Functions in One

• 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....

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

• 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...

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

• 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...

• 3. 2. 2020

### How to Execute SQL Server Procedure in Excel with Parameters

• 3. 2. 2020
Right from the beginning let’s be clear. Even though this process is possible, don’t use it as your standard process. Instead use How to Execute SQL Query in Excel...

### Excel Import to SQL Server Database via SSMS

• 2. 2. 2020
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...

### Excel Fuzzy Lookup Guide – Comparing 2 Lists with Example

• 2. 2. 2020
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 in Excel – SUMPRODUCT

• 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...

### How to Enable Power Pivot in Excel

• 26. 11. 2019
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...

### Getting Started with Power Pivot – Data Modeling in Excel

• 26. 11. 2019
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...

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

• 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...

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

• 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...

### Excel | Mean (Average) Overview – Types, Formulas, Example

• 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...