24/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
  • Home
  • Excel category

Excel category

Clémentine Ansallem20/11/201920/11/2019
0

[sh_CatArticles]

0

Most viewed posts

Conditional Formatting – Highlighting dates

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

Convert address to GPS coordinates

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

Radar chart

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

Sunburst Chart

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

First day – Last day in Excel

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

Microsoft Award

Categories

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