Excel category contains all articles related to Excel in some way. For more detailed filtering, direct your attention to one of the categories below:

### 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 Procedure in Excel incl. Parameters with Example

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

### 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) Functions Overview – Types, Formulas, Explanation and Examples

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

### Day Count Convention (Fractions) for Bonds, Loans, Accrued Interest – Financial Mathematics

• 25. 10. 2019
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,...