25/01/2021
Top Articles

Conditional Formatting – Highlighting dates

Convert address to GPS coordinates

Radar chart

Sunburst Chart

First day – Last day in Excel

Add slicer with Excel Online

Pivot Table Percentage

Round to the next decimal range

Dynamic filter in Excel

SORT your data dynamically

What is the SPILL error?

UNIQUE Function – Remove duplicates with formulas

FacebookLinkedinYoutubeRss
  • Home
  • What is New
    • 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

      What is New

      Excel on your mobile for free

      17/11/2014

  • Function
    • Function

      First day – Last day in Excel

      18/11/2020

      Function

      XLOOKUP is a Formula 1

      02/07/2020

      Function

      MATCH function returns a position

      30/06/2020

      Function

      Convert TRUE or FALSE to 1 or 0

      16/06/2020

      Function

      Change the color of the weekends

      12/06/2020

  • Tips and Tricks
    • 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

      Tips and Tricks

      Add Emojis to your charts, formulas

      12/12/2019

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

      Statistics

      Understand the Standard Deviation

      21/06/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

cropped Image header site Excel exercise

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

Most viewed posts

How to make automatic calendar in Excel

Frédéric LE GUEN26/11/201820/01/2021
26/11/201820/01/202171 4777

Date Format in Excel

Frédéric LE GUEN02/08/201813/12/2020
02/08/201813/12/202036 4582

Displaying Negative Numbers in Parentheses – Excel

Frédéric LE GUEN08/11/201815/06/2020
08/11/201815/06/20208 3989

Compare 2 Columns

Frédéric LE GUEN14/01/202004/11/2020
14/01/202004/11/20206 3334

Formulas to include or exclude tax

Frédéric LE GUEN20/11/201817/06/2020
20/11/201817/06/20203 3273

Split Date and Time

Frédéric LE GUEN18/04/202013/12/2020
18/04/202013/12/202018 3069
Load more posts

Functions

  • Condition
  • Date
  • Search
Date

Title with date in Excel

Frédéric LE GUEN07/09/201417/04/2020
07/09/201417/04/202001169
Expert

Wildcard with COUNTIFS or SUMIFS

Frédéric LE GUEN24/12/201828/06/2020
24/12/201828/06/202001009
Date

Weekly calendar 2020 in one formula

Frédéric LE GUEN13/12/201915/12/2019
13/12/201915/12/201901132
Search

Filter your data in Excel

Frédéric LE GUEN27/11/201822/11/2019
27/11/201822/11/20190425
Advanced

Function SUMIFS

Frédéric LE GUEN08/02/201923/11/2020
08/02/201923/11/20200662
Advanced

COUNTIFS – Count rows automatically in Excel

Frédéric LE GUEN25/01/201928/06/2020
25/01/201928/06/20207 1833

News

Advanced

Excel as a sports coach

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

Exchange rate in Excel

17/11/201917/11/2019 2842 1
Conditional Formatting

Create a progress bar with icons

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

Excel on your mobile for free

17/11/201428/11/2019 906 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 - Croiser les données (sans formule) 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/20203640
Charts

Sunburst Chart

28/12/202028/12/20204350
Tips and Tricks

Add Emojis to your charts, formulas

12/12/201905/11/202021672
Expert

Gantt Chart

03/11/201823/11/20198680
Charts

Population Pyramid

15/01/201215/04/202021024

Categories

  • Beginner (19)
  • Advanced (17)
  • Expert (15)
  • Statistics (13)
  • Tips and Tricks (12)
  • Conditional Formatting (11)
  • Manage data (8)
  • Charts (5)
  • Pivot Table (5)
  • What is New (4)
  • Dynamic Array (4)
  • Shortcuts (3)
  • Text functions (2)
  • Power Query (1)
  • Function (37)
    • Date (18)
    • Condition (11)
    • Search (9)

Social Networks

Last post

Conditional Formatting – Highlighting dates

Frédéric LE GUEN13/01/202121/01/2021
13/01/202121/01/2021208

Convert address to GPS coordinates

Frédéric LE GUEN12/01/202112/01/2021
12/01/202112/01/2021276

Radar chart

Frédéric LE GUEN30/12/2020
30/12/2020364

Sunburst Chart

Frédéric LE GUEN28/12/202028/12/2020
28/12/202028/12/2020435

First day – Last day in Excel

Frédéric LE GUEN18/11/202013/12/2020
18/11/202013/12/20201971
@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
  • Contact
  • French