Frédéric LE GUEN

Author's posts

Exchange rate in Excel

Exchange Rate added to Excel with Data types

With the new feature of Office 365, Data Type, you can easily collect the last Exchange Rate between 2 currencies

Permanent link to this article: https://www.excel-exercise.com/exchange-rate-in-excel/

Explanation of the VBA code for the calendar

What is the value of the dates in column 30, 31 and 32

Each lines of the VBA code for the automatic calendar explain in detail.

Permanent link to this article: https://www.excel-exercise.com/explanation-of-the-vba-code-for-the-calendar/

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/