Frédéric LE GUEN

What is the Most Common Value in your Excel document.

You can easily return the most common number in a range of cells with the function MODE or MODE.SNGL

How to keep the leading 0 in a cell?

Keep the leading 0 in Excel is important when you want to keep all the digits of your strings and to avoid mistakes

First day – Last day in Excel

This article is a glossary of all the Excel functions to return the first day or the last day of the Month, the Quarter or the Year

DATEDIFF for POWER QUERY

This article gives you the M Code for Power Query to return the result of the DATEDIFF function (difference between 2 dates)

What is a Pivot Table in Excel?

A pivot table in Excel is a great tool. You can build a report to follow your activity without writing a single formula. Let's see how?

Radar chart in Excel

Visualize survey data with an Excel radar chart. Easily compare individual responses to the average and gain valuable insights.

The FILTER Function in Excel

The FILTER function of Excel returns all the rows corresponding to a specific criteria. It's possible because of the Dynamic Arrays of Microsoft 365

XLS vs XLSX file format?

Understand the difference between XLS and XLSX file formats in Excel. Learn how to convert and save files for optimal compatibility.

Extract only the numbers of a cell in Excel

Want to extract numbers from cells with mixed characters? Discover the step-by-step process using the SEQUENCE and FILTER functions.

Calculate Moving Average in Excel

Learn how to calculate a moving average in Excel. Use the AVERAGE function to smooth out data and identify trends.

Calculate Seniority in Excel

Calculate seniority is an easy task with Excel when you use the appropriate function.

UNIQUE Function – Remove duplicates with formulas

UNIQUE is a new Excel function to remove automatically the duplicates in a list of data. It's amazing how simple is it to use this function

How to create a Gantt Chart with Excel?

A Gantt chart, helps you to visualize the time needed to realize actions. Learn how to build a Gantt chart with Excel steps by steps

The DATEDIF function in Excel

Want to calculate date differences? Learn how to use the DATEDIF function in Excel to determine the age between dates accurately.

Create your custom functions with LAMBDA

Discover how to create custom Excel functions using the LAMBDA function and named ranges in Microsoft 365.

Calculate Public holidays with Excel 📆

Discover how Excel can make it easy to calculate public holidays. Learn simple formulas to automate the process and never miss a holiday again.

Change the default Date format in Excel

Learn how to effortlessly change the default date format in Excel using these instructions. Enhance your Excel experience with this guide.

How to Highlight a Birthday Reminder in Excel

This step-by-step guide will explain to you how to build a birthday reminder in Excel with a specific color when the event occurs

SUMIFS Function in Excel

Discover how to use the SUMIFS function in Excel to filter and sum data based on multiple criteria in your worksheets

Create a Lookup Offset

When you have many times the same ID in your table, the following formula will help you to create a lookup offset.

Understand the Standard Deviation

Learn to calculate and interpret standard deviation to better understand your average results.

Basic calculations with Excel

Learn how to perform basic calculations in Excel with ease. Follow simple rules and formulas to avoid mistakes and get accurate results.

Functions AND – OR with Excel

Master Excel's logic functions to create powerful tests. Understand how the AND and OR functions can enhance your data analysis.

The SUM function – All Tricks

SUM is the most used Excel function. There is nothing complex to use this function but there is also tricks behind this function

Tips to Move and Copy Worksheet in Excel

Discover the tips and tricks to move or copy a worksheet in the same workbook or in a new one. All explanations with animated gif.

Merge Multiple Excel files into one workbook

How to merge many Excel workbooks into a single one? This steby-step guide will explain you the technique with Excel and Power Query.

3D Formula in Excel

In Excel, you can build 3D formulas by making a relationship through many worksheets. Let's see how to build a 3D formula.

Audit a Formula with F9

Master the F9 shortcut in Excel to perform formula audits. Quickly analyze each part of your formula to ensure accuracy.

The custom rule applies to a range of cells

Change the color according to the value in Excel

How to change the color of your cells according to the values? With the conditional formatting tool of Excel, it's very easy

The Excel Shortcuts everyone must know

Discover a playlist of videos to learn the best Excel shortcuts ever.

Extract folder and subfolders with Excel

It's very easy to extract the hierarchy of a folder and subfolders with Excel. In just 5 steps the job is done.

Find Items That Appear Only Once

Discover How to Extract Only the Unique Values of a list of data in Excel with the UNIQUE function.

How to return multiple rows with VLOOKUP

If you want to return many rows, you can't use the VLOOKUP function. But you can do the job with the FILTER function.

TODAY and NOW function in Excel

The functions NOW & TODAY are very useful in Excel. It's the only way to build dynamic date to calculate gap between dates.

Capitalize the first letter in Excel (Camel Case)

Find out how to capitalize the first letter in Excel using three powerful tools: PROPER function, Power Query, and macros.

How to create Dependent Drop down List in Excel?

This step-by-step guide will teach you how to create a dependent drop down list in Excel. You need to use the UNIQUE and FILTER functions.

Negative numbers between parenthesis cover

Displaying Negative Numbers in Parentheses in Excel

Discover how to format negative numbers in Excel with parentheses. Improve the readability of your data with this simple technique.

Convert Numbers to Words in Excel

Convert Number to Words is now possible with Excel 365 and the LET function

Convert address to GPS coordinates

You can convert your addresses to GPS coordinates or the other way round to convert GPS coordinates to addresses.

Sunburst Chart with Excel

A Sunburst chart is useful to visualize the hierarchy of your data. You can use it for your folders or organization.

Add a slicer with Excel Online

Unlock the power of Excel with slicers. Find out how to add a slicer to your Pivot Table and simplify your data filtering process.

How to do Percentage in a Pivot Table in Excel?

Learn a quick and easy way to add percentages to your pivot table. Elevate your data analysis with this simple technique.

What is the SPILL error in Excel?

Discover what causes the #SPILL! error in Excel and how it relates to dynamic array formulas and insufficient space for result display.

Title with Text and Date in the same cell

Learn how to use the TEXT function in Excel to format numbers and keep the desired number format inside a string.

Ctrl+D: The Secret Shortcut of Excel

Unlock the power of secret Excel shortcuts. Discover how Ctrl + D can duplicate and align charts, images, or icons.

Date Format in Excel

Discover how to customize your date format in Excel easily by changing the day, month, or year. There are many examples.

How to use the MATCH function in Excel?

The MATCH function returns the position of an item in a list. This function is very useful to create DYNAMIC dashboard and formulas

Change the color of holidays

You can change automatically the color of the public holidays in your calendar with the conditional formating and a custom rule.

How to use the INDIRECT function of Excel?

Discover how to use INDIRECT Excel for dynamic references and enhance your data management in Excel spreadsheets.

Top Bottom values conditional formatting

Highlight Top / Bottom values with the conditional formatting

You can easily highlight the highest or lowest values of your document with the conditional formatting. Easy to use and to manage

Add Emojis to your Excel charts or slicers

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

How to Copy and Paste in Excel?

How to copy data and reuse them (paste) in other Excel cells? You can copy and paste text, numbers, and formula

Split report to many sub-reports automatically

You can split your report to many sub-reports automatically with a pivot table options. When you use the filter, you can spilt your report 😉

Excel Split Date and Time

Discover how to separate date and time in Excel with ease. Use the INT and subtraction functions to extract the desired values.

Excel as a sports coach

Do you know that Excel can be your new sports coach? No? But in reality, it's very easy. Copy for free the code and you will have your coach at home

Excel starts with your custom parameters

Custom Start of Excel (font, color, format)

Learn how to start Excel with custom parameters. Step-by-step guide for beginners and experts to optimize your Excel experience.

How to Display Tenths, Hundredths with Excel

Learn how to display tenths, hundredths, or thousandths of a second in Excel with a custom time format for accurate analysis.

Draw your borders with the mouse

Learn how to draw borders in Excel using just your mouse. Save time and increase precision in your daily tasks.

Master Excel Navigation with the Alt Key Shortcut

Navigate Excel like a pro with Alt key shortcuts. Access the ribbon interface and execute commands with ease for enhanced efficiency.

How to Reuse Cell Values in Excel: A Complete Guide

Learn how to easily reuse cell values in Excel. Discover different techniques for referencing cells in the same or different worksheets.

Function XOR in Excel

Master the exclusive OR function (XOR) in Excel. Understand its unique logic and apply it to various scenarios to enhance your Excel skills.

Explanation of the VBA code for the calendar

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

Function DATE – YEAR – MONTH – DAY

The function DATE is very useful to create your custom dates. This article will explain you how the function works

Create a progress bar with icons

Learn how to create a progress bar with icons in your worksheet using simple steps. Crop and align icons for a professional look.

Update your drowndown list automatically

Update a Dropdown List automatically

Find out two techniques to create a dynamic dropdown list in Excel by using the power of the Excel Tables. 📌

Wildcard with COUNTIFS or SUMIFS

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

Mortgage calculator with Excel 💰

Learn how to create a mortgage calculator in Excel using the PMT function. Then, you can easily and accurately calculate your loan payments.

How to make automatic calendar in Excel

This article present how can create an automatic calendar in excel to avoid and refresh manually your worksheet, step by step. Tutorial video available.

Anonymize your data

Discover how you can transform your worksheet to anonymise your data in the case you have sensitive data. 5 steps are needed

Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde

How to convert the GPS coordinates (latitude- longitude) in degree, minute, seconde and also the other way round. The solution is the custom number format.