02/12/2021

Top Articles

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

Create your custom functions with LAMBDA

Public holidays formulas

Nested IF in Excel

Search in a range of values with…

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
  DATEDIF for POWER QUERY
  07/11/2021
  Function
  Extract only the numbers of a cell in…
  12/10/2021
  Function
  Calculate Seniority in Excel
  09/10/2021
  Function
  Create your custom functions with LAMBDA
  25/08/2021
  Function
  Public holidays formulas
  24/08/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
  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
  Running Total in Excel
  05/01/2020
  Statistics
  Round to the Nearest Ten, Hundred, Multiple..
  01/12/2019
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:

Convert address to GPS coordinates

Frédéric LE GUEN12/01/202107/03/2021

07/03/202107/03/202105973

Lookup functions

Dynamic VLOOKUP research

Frédéric LE GUEN02/09/201930/06/2020

30/06/202030/06/202014792

Examples of Paste Special (All Options)

Frédéric LE GUEN30/11/201728/04/2020

28/04/202028/04/202004698

Public holidays formulas

Frédéric LE GUEN24/08/202118/11/2021

18/11/202118/11/202101517

Create an online survey with Excel

Frédéric LE GUEN22/02/201513/11/2021

13/11/202113/11/202106562

Lookup functions

XLOOKUP is a Formula 1

Frédéric LE GUEN02/07/202007/03/2021

07/03/202107/03/202103142

Conditional Formatting

Conditional Formatting – Color scales

Frédéric LE GUEN18/09/201224/06/2020

24/06/202024/06/202002776

Difference between 2 dates – DATEDIF

Frédéric LE GUEN29/08/201908/03/2021

08/03/202108/03/2021110236

Conditional Formatting – Highlighting dates

Frédéric LE GUEN13/01/202106/06/2021

06/06/202106/06/202112560

First day – Last day in Excel

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

13/12/202013/12/202010 12917

Start Excel with your custom parameters

Frédéric LE GUEN01/03/202007/03/2021

07/03/202107/03/20212 4219

COUNTIFS – Count rows automatically in Excel

Frédéric LE GUEN25/01/201928/11/2021

28/11/202128/11/20217 15776

Videos

Thumbnail youtube Draw Map Chart in Excel (Country, States, Counties, Zip Code) 10:29 Thumbnail youtube How to Change the color in Excel by formula -... 07:36 Thumbnail youtube Pin Data on Map with Excel 08:08 Thumbnail youtube How to Compare two columns with Excel 04:30

Categories

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

Social Networks

Last post

Population Pyramid with Excel

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

28/11/202128/11/202113786

Keep the leading 0 in Excel

Frédéric LE GUEN26/11/202126/11/2021

26/11/202126/11/202144

Connect slicer with Data Type

Frédéric LE GUEN17/11/202117/11/2021

17/11/202117/11/202196

DATEDIF for POWER QUERY

Frédéric LE GUEN07/11/202117/11/2021

17/11/202117/11/2021204

XLS or XLSX file ?

Frédéric LE GUEN14/10/202128/11/2021

28/11/202128/11/202115496

@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