Category: Advanced

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

Running Total in Excel

Running Total animated

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

Permanent link to this article: https://www.excel-exercise.com/running-total-in-excel/

Understand Standard Deviation

Same average but the analyze is different

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

Permanent link to this article: https://www.excel-exercise.com/understand-the-standard-deviation/

Create a progress bar with icons

Cover Progress bar with icons

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

Permanent link to this article: https://www.excel-exercise.com/create-a-progress-bar-with-icons/

Round to the Nearest Ten, Hundred, Multiple..

Round to the nearest hundredth

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

Permanent link to this article: https://www.excel-exercise.com/round-to-the-nearest-tenth-hundredth/

Mortgage calculator with Excel

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

Permanent link to this article: https://www.excel-exercise.com/mortgage-calculator-with-excel/

Displaying Negative Numbers in Parentheses – Excel

Negatives numbers are written with parenthesis in red

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.

Permanent link to this article: https://www.excel-exercise.com/negative-numbers-with-parenthesis-excel/

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

Continue reading

Permanent link to this article: https://www.excel-exercise.com/inspect-a-formula-with-f9/

Convert Coordinates Latitude and Longitude

Convert coordinates from degree minute second to Decimal

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 …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/convert-latitude-longitude/

Mixed References

Formula with mixed reference

A mixed reference is a reference that is fixed only on part of the reference

Permanent link to this article: https://www.excel-exercise.com/mixed-reference/

COUNTIFS – Count rows automatically in Excel

Avoid the filter to count rows When you want to count the number of rows corresponding to a specific criteria, many users use the tool Filter. For 1, 2 or 3 different criteria, you can work like that. But if you have to extract a lot of count of rows for many different criteria, the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/countifs-count-rows-automatically-in-excel/