27/01/2022

Top Articles

Calculate a date from the week number

Formulas to calculate the days of the…

How to build your custom date in…

How to use the Statistical functions

Population Pyramid with Excel

Keep the leading 0 in Excel

Connect slicer with Data Type

DATEDIF for POWER QUERY

XLS or XLSX file ?

Extract only the numbers of a cell…

Moving Average in Excel

Calculate Seniority in Excel

Facebook Linkedin Youtube Rss

Home
What is New
- What is New
  Extract items that appear only one time
  07/03/2021
  What is New
  Exchange rate in Excel
  17/11/2019
  What is New
  Create a progress bar with icons
  09/06/2019
  What is New
  Excel on your mobile for free
  17/11/2014
Function
- Function
  Calculate a date from the week number
  22/01/2022
  Function
  How to build your custom date in Excel
  05/12/2021
  Function
  How to use the Statistical functions
  04/12/2021
  Function
  DATEDIF for POWER QUERY
  07/11/2021
  Function
  Extract only the numbers of a cell in…
  12/10/2021
Tips and Tricks
- Tips and Tricks
  Keep the leading 0 in Excel
  26/11/2021
  Tips and Tricks
  Depending drop-down list
  10/02/2021
  Tips and Tricks
  Extract sample randomly in Excel
  24/11/2020
  Tips and Tricks
  Ctrl + D The Secret Revealed
  29/08/2020
  Tips and Tricks
  Add filter option for all your columns in…
  11/06/2020
Statistics
- Statistics
  How to use the Statistical functions
  04/12/2021
  Statistics
  Moving Average in Excel
  11/10/2021
  Statistics
  Dynamic SUM in Excel
  17/02/2021
  Statistics
  Round to the next decimal range
  25/10/2020
  Statistics
  Formulas to include or exclude tax
  20/01/2020
Pivot Table
- Pivot Table
  Add slicer with Excel Online
  13/11/2020
  Pivot Table
  Pivot Table Percentage
  04/11/2020
  Pivot Table
  Add filter option for all your columns in…
  11/06/2020
  Pivot Table
  Split report to many sub-reports automatically
  18/04/2020
  Pivot Table
  Pivot Table – Presentation
  04/11/2018
Contact
French

Search for:

Improve your Excel skill

All the secrets of Excel and the Business Intelligence

Search for:

How to display hours over 24

Frédéric LE GUEN25/11/201926/12/2021

26/12/202126/12/20213 15823

Convert TRUE or FALSE to 1 or 0

Frédéric LE GUEN16/06/202007/03/2021

07/03/202107/03/2021010177

Tips and Tricks

How to become Office Insider

Frédéric LE GUEN11/12/201927/08/2021

27/08/202127/08/202103972

Pivot Table – Presentation

Frédéric LE GUEN04/11/201818/04/2020

18/04/202018/04/202004439

SUMIF Function in Excel

Frédéric LE GUEN03/10/202028/11/2021

28/11/202128/11/202105586

Lookup functions

Create a Lookup Offset

Frédéric LE GUEN05/07/202114/07/2021

14/07/202114/07/202115040

Conditional Formatting

Display bars in the cells

Frédéric LE GUEN20/06/202007/03/2021

07/03/202107/03/202101802

Weekly calendar 2020 in one formula

Frédéric LE GUEN13/12/201915/12/2019

15/12/201915/12/201905674

First day – Last day in Excel

Frédéric LE GUEN18/11/202013/12/2020

13/12/202013/12/202010 14776

Calculate a date from the week number

Frédéric LE GUEN22/01/202222/01/2022

22/01/202222/01/2022040

Function INDIRECT

Frédéric LE GUEN20/06/202009/12/2021

09/12/202109/12/202101662

Extract folder and subfolders with Excel

Frédéric LE GUEN10/03/202110/03/2021

10/03/202110/03/202104619

Categories

Beginner (21)
Expert (15)
Tips and Tricks (15)
Conditional Formatting (13)
Manage data (9)
Advanced (8)
Text functions (8)
Charts (5)
Pivot Table (5)
What is New (4)
Shortcuts (4)
Power Query (4)
Maps and GPS (3)
Data Type (2)
Function (72)

Social Networks

Last post

Calculate a date from the week number

Frédéric LE GUEN22/01/202222/01/2022

22/01/202222/01/202240

Formulas to calculate the days of the week

Frédéric LE GUEN28/12/202128/12/2021

28/12/202128/12/2021228

How to build your custom date in Excel

Frédéric LE GUEN05/12/202105/12/2021

05/12/202105/12/20211308

How to use the Statistical functions

Frédéric LE GUEN04/12/202104/12/2021

04/12/202104/12/2021771

Population Pyramid with Excel

Frédéric LE GUEN28/11/202128/11/2021

28/11/202128/11/202115223

@2020 - www.excel-exercise.com. All Right Reserved. Privacy Policy

Facebook Linkedin Youtube Rss

Home
What is New
Function
Tips and Tricks
Statistics
Pivot Table
Contact
French