Category: Advanced

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

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/

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 …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/convert-address-to-gps-coordinates/

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 …

Continue reading

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

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  …

Continue reading

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

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

Continue reading

Permanent link to this article: https://www.excel-exercise.com/first-day-last-day-in-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 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 an address, please …

Continue reading

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

Mixed References

Mixed reference A mixed reference is a reference that is fixed only on part of the reference: either the row or the column Before showing you an example of a calculation using mixed references, we will detail the use of the $ symbol in a reference. An absolute reference has two $. There is one …

Continue reading

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