17/04/2021
Top Articles

Extract folder and subfolders with Excel

Extract items that appear just once

How to return many rows with VLOOKUP

NOW & TODAY

Link address to Google Maps

Split Text by delimiter

Dynamic SUM in Excel

Capitalize the first letter in Excel

Depending drop-down list

Displaying Negative Numbers in Parentheses – Excel

Number to Words

Conditional Formatting – Highlighting dates

FacebookLinkedinYoutubeRss
  • Home
  • What is New
    • What is New

      Extract items that appear just once

      07/03/2021

      What is New

      Number to Words

      26/01/2021

      What is New

      Excel as a sports coach

      13/04/2020

      What is New

      Exchange rate in Excel

      17/11/2019

      What is New

      Create a progress bar with icons

      09/06/2019

  • Function
    • Function

      Extract items that appear just once

      07/03/2021

      Function

      How to return many rows with VLOOKUP

      28/02/2021

      Function

      NOW & TODAY

      28/02/2021

      Function

      Depending drop-down list

      10/02/2021

      Function

      First day – Last day in Excel

      18/11/2020

  • Tips and Tricks
    • Tips and Tricks

      Depending drop-down list

      10/02/2021

      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

      Tips and Tricks

      Compare 2 Columns

      14/01/2020

      Tips and Tricks

      Dash for 0 in Excel

      03/01/2020

  • Statistics
    • 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

      Statistics

      Most common number in my spreadsheet

      26/11/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

  • French

cropped Image header site Excel exercise

All the secrets of Excel and the Business Intelligence
cropped Image header site Excel exercise

Functions

  • Condition
  • Date
  • Dynamic Arrays
  • Search
Date

Calculation of tenths, hundredths and thousandths with Excel

Frédéric LE GUEN19/02/201431/01/2020
19/02/201431/01/202012197
Expert

Wildcard with COUNTIFS or SUMIFS

Frédéric LE GUEN24/12/201828/06/2020
24/12/201828/06/202002991
Search

XLOOKUP is a Formula 1

Frédéric LE GUEN02/07/202007/03/2021
02/07/202007/03/202101619
Tips and Tricks

Compare 2 Columns

Frédéric LE GUEN14/01/202025/02/2021
14/01/202025/02/20216 9801
Dynamic Arrays

What is the SPILL error?

Frédéric LE GUEN29/09/202007/03/2021
29/09/202007/03/202103451
Condition

Function IF – Examples with payments

Frédéric LE GUEN19/05/201918/06/2020
19/05/201918/06/20207 4171

News

Dynamic Arrays

Extract items that appear just once

07/03/202107/03/2021 909 0
Expert

Number to Words

26/01/202126/01/2021 1305 0
Advanced

Excel as a sports coach

13/04/202014/04/2020 1269 0
What is New

Exchange rate in Excel

17/11/201928/02/2021 8542 1
Conditional Formatting

Create a progress bar with icons

09/06/201914/04/2020 2174 1
What is New

Excel on your mobile for free

17/11/201428/11/2019 2371 0

Videos

Thumbnail youtube C'est quoi Power Query ? L'outil qui remplace le VBA 06:27 Thumbnail youtube Fonction SI - 2 exemples pour comprendre 05:03 Thumbnail youtube Power Query - Relation entre 2 tables - Toutes les... 09:30 Thumbnail youtube Comment calculer le pourcentage d'augmentation ou diminution 04:08 Thumbnail youtube Excel - Retourner plusieurs valeurs à partir d'une recherche 03:01 Thumbnail youtube Importer un fichier csv avec Power Query et rejouer les... 08:28

Charts

Charts

Radar chart

30/12/202022/02/202112560
Charts

Sunburst Chart

28/12/202010/03/202120580
Tips and Tricks

Add Emojis to your charts, formulas

12/12/201928/02/202165492
Expert

Gantt Chart

03/11/201822/02/202124210
Charts

Population Pyramid

15/01/201215/04/202062174

Categories

  • Beginner (19)
  • Expert (15)
  • Tips and Tricks (13)
  • Statistics (13)
  • Conditional Formatting (12)
  • Manage data (8)
  • Advanced (7)
  • What is New (6)
  • Charts (5)
  • Pivot Table (5)
  • Text functions (5)
  • Shortcuts (4)
  • Maps and GPS (3)
  • Power Query (2)
  • Data Type (1)
  • Function (43)
    • Date (17)
    • Condition (11)
    • Search (9)
    • Dynamic Arrays (7)

Social Networks

Last post

Extract folder and subfolders with Excel

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

Extract items that appear just once

Frédéric LE GUEN07/03/202107/03/2021
07/03/202107/03/2021909

How to return many rows with VLOOKUP

Frédéric LE GUEN28/02/202107/03/2021
28/02/202107/03/20211039

NOW & TODAY

Frédéric LE GUEN28/02/202128/02/2021
28/02/202128/02/20213103

Link address to Google Maps

Frédéric LE GUEN26/02/202107/03/2021
26/02/202107/03/2021961
@2020 - www.excel-exercise.com. All Right Reserved. Privacy Policy
cropped Image header site Excel exercise
FacebookLinkedinYoutubeRss
  • Home
  • What is New
  • Function
  • Tips and Tricks
  • Statistics
  • Pivot Table
  • French