Discover how to improve your Excel knowledge, functions, tips and tricks

## Understand Standard Deviation

Calculate the standard deviation helps you to analyze the result of your AVERAGE calculation.

## Create a progress bar with icons

Discover how you can create a progress bar in your Excel worksheet. All the steps explain in this article.

## Convert address to GPS coordinates

It is possible to add GPS coordinates to a list of addresses. Our company can do this job for you. Convert GPS to mailing address But we can also do the opposite – return the mailing address of GPS coordinates. And we can send you the result. Price The price to do this job depends …

## Round to the Nearest Ten, Hundred, Multiple..

With Excel, it’s very easy to round to the nearest ten, hundred, thousand, …. Standard use of the ROUND function The ROUND function is a very common Excel function. You use it when you want to round a number. =ROUND(number, decimal) “Number” is your number “Decimal” is the number of decimal places you want to keep …

## Mortgage calculator with Excel

In Excel, you can easily create a mortgage calculator with the PMT function Explanation of the PMT function PMT calculates the PayMenT for a loan for a constant interest rate. The arguments of the function are: Rate    The interest rate on the loan. Nper    The total number of payment periods for the loan. Pv  …

## First day – Last day in Excel

On this page, you will find some formulas to calculate specific days automatically. Building specific dates, such as the first or last day, is always a very complex task, in Excel or any other software. The function TODAY has been used in all the examples but you can replace it with your own date value. …

## Displaying Negative Numbers in Parentheses – Excel

With Excel, you can display your negative numbers inside a parenthesis.
To do that, you have to create a customize code like it is explain in this article.

## Inspect a Formula with F9

In Excel, you can scan part of your formula with the shortcut F9 When use the F9 shortcut? Let’s say you have a complex formula with a lots of VLOOKUP, INDEX, MATCH, references. But the result returned is not correct and you need to find the reason. Tips: To display your formula on multiple rows, …