EXCEL EXERCISE - All Tricks, News, Advices, Formulas

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

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:

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

Title with date in Excel

Frédéric LE GUEN07/09/201417/04/2020

07/09/201417/04/202001169

Wildcard with COUNTIFS or SUMIFS

Frédéric LE GUEN24/12/201828/06/2020

24/12/201828/06/202001009

Weekly calendar 2020 in one formula

Frédéric LE GUEN13/12/201915/12/2019

13/12/201915/12/201901132

Filter your data in Excel

Frédéric LE GUEN27/11/201822/11/2019

27/11/201822/11/20190425

Function SUMIFS

Frédéric LE GUEN08/02/201923/11/2020

08/02/201923/11/20200662

COUNTIFS – Count rows automatically in Excel

Frédéric LE GUEN25/01/201928/06/2020

25/01/201928/06/20207 1833

News

Excel as a sports coach

13/04/202014/04/2020 411 0

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

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

Radar chart

30/12/20203640

Sunburst Chart

28/12/202028/12/20204350

Tips and Tricks

Add Emojis to your charts, formulas

12/12/201905/11/202021672

Gantt Chart

03/11/201823/11/20198680

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)

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

Facebook Linkedin Youtube Rss

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