Frédéric LE GUEN

Author's posts

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/

Add Emojis to your charts, formulas

Chart label are icons

You can customize your Excel worksheets and create unique dashboards with emojis (icons) in your cells, worksheet name, formulas, charts or slicers.

Permanent link to this article: https://www.excel-exercise.com/add-emojis-to-your-charts-formulas/

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/

Dynamic Dropdown List

How to create a dynamic dropdown list

This article will show you how to automatically update your drop-down list Create a dropdown list in Excel To create a dropdown list activate the menu Data > Data Validation Select a cell (in our example F1) Select the menu Data > Data Validation In the dialog box, select the option List Then select the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/dynamic-drop-down-list/

How to Highlight a Birthday Automatically

Gap in days and months before after the birthday

In this article, you will see how you can change color when a Birthday is coming up without using a macro.

Permanent link to this article: https://www.excel-exercise.com/how-to-highlight-birthday-automatically/

Wildcard with COUNTIFS or SUMIFS

Wildcard characters with a COUNTIFS function

You can create complex criteria in your COUNTIFS or SUMIFS function with the wildcart.
The wildcards are specials characters to replace one or more characters in your string

Permanent link to this article: https://www.excel-exercise.com/wildcard-with-countifs-or-sumifs/

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/

Convert YYYYMMDD to DD/MM/YYYY

This article will explain how to convert date YYYYMMDD to DD/MM/YYYY. You can use one of two techniques: Convert with formulas With this technique, you must extract each part of a date with the text functions. So if you have a YYYYYMMDD format to transform, here are the steps to follow. Step 1: Extract the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/convert-date-yyyymmdd-to-dd-mm-yyyy-without-formula/

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/

Convert roman numerals with Excel

This article will show you how easy it is to convert numbers to roman numerals, or vice versa, with Excel. Roman numerals Roman numerals are represented by combinations of letters I = 1 V = 5 X = 10 L = 50 C = 100 D = 500 M = 1000 To create a number, you …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/convert-roman-numerals-with-excel/