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

Facebook Linkedin Youtube Rss

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

Search for:

All the secrets of Excel and the Business Intelligence

Search for:

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)
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

Facebook Linkedin Youtube Rss

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