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

## Running Total in Excel

A running total is a very useful mathematical operation which is very simply to build in Excel.

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

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

You can easily round your number to the nearest tenth, hundredth or thousandth with the function ROUND

## Mortgage calculator with Excel

It’s easy to build a mortgage calculator with Excel and the function PMT

## 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, …

## Convert Coordinates Latitude and Longitude

Nowadays, GPS localization is common. Some apps use decimal format (48.85833) while others return the coordinates in degrees, minutes and seconds (48°51’29.99”). In this article I will show you how to convert from one format to the other and vice-versa. Add GPS coordinates to address If you are looking to add GPS coordinates to your address, please …