Frédéric LE GUEN

Author's posts

Running Total in Excel

Running Total animated

A running total is a very useful mathematical operation which is very simply to build in Excel.

Permanent link to this article: https://www.excel-exercise.com/running-total-in-excel/

Dash for 0 in Excel

The Dash for 0

Learn how you can display your zeros as a dash in your spreadsheets.

Permanent link to this article: https://www.excel-exercise.com/dash-for-0-in-excel/

Weekly calendar 2020 in one formula

Weekly calendar 2020 - All months

Discover how to create a weekly calendar and with just one formula.
With the new dynamic array, it’s very easy to do with the function SEQUENCE 🙂

Permanent link to this article: https://www.excel-exercise.com/weekly-calendar-2020-in-one-formula/

How to become Office Insider

Change the level of your Office Program

Discover how to become an Office Insider in order to have the newest features of Office

Permanent link to this article: https://www.excel-exercise.com/how-to-become-office-insider/

Most common number in my spreadsheet

Number of times the most common number is in the document

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

Permanent link to this article: https://www.excel-exercise.com/most-common-number-in-my-spreadsheet/

Reorder your data from one column to many

Unstack 1 column to many with TRANSPOSE and INDIRECT

You can unstack data from 1 column to many with the function TRANSPOSE and INDIRECT. Explanation is this article.

Permanent link to this article: https://www.excel-exercise.com/reorder-your-data-from-one-column-to-many/

Extract random data of your database

List of email extract randomly

To extract random data from a huge list, the copy-paste method is not the best one ⛔. In fact, with the functions RANDBETWEEN and INDIRECT it’s easier 😉

Permanent link to this article: https://www.excel-exercise.com/extract-random-data-of-your-database/

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/