Frédéric LE GUEN

Most commented posts

  1. How to make automatic calendar in Excel — 28 comments
  2. Date format in Excel — 9 comments
  3. Split Time and Date — 4 comments
  4. NOW & TODAY — 4 comments
  5. Weekends or weekdays in Excel — 3 comments

Author's posts

Dynamic Drop-down List

This article will show you how to automatically update your drop-down list Create a drop-down list in Excel To create a drop-down 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 Birthday Automatically

In this article, you will see how you can change the color when a Birthday is coming up in few days. No macro has been used. Step 1: Add the current date First of all, add the current date with the function TODAY() in a new column. =TODAY() Step 2: Gap for the months In …

Continue reading

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

Wildcard with COUNTIFS or SUMIFS

Greater than / Less than You can create complex conditions with the COUNTIFS function. You can enhance your criteria by adding a logical operator. In other words, you can select all the rows where one criterion is greater than a value. For example, if we want to determine the number of men with incomes greater …

Continue reading

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/

Extract text without a formula

FlashFill

In Excel 2013 and later, you can extract text without a formula using Flash Fill. What is Flash Fill? FlashFill is a tool integrated into Excel, that runs in the background continuously. You don’t have to click anywhere on the ribbon to activate it. You just have to fill in what you want to extract. Extract …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/extract-text-without-formula/

Filter your data in Excel

One of the most useful tools you have in Excel is the Filter tool. You know that the filter is ON when you see arrows on the header of your table. Activate the Filter 1. Select one of the cells of your table 2. Activate the filter in the Data > Filter 3. Now you …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/filter-your-data-in-excel/

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/