EXCEL EXERCISE - All Tricks, News, Advices, Formulas

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

Facebook Linkedin Youtube Rss

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

Search for:

All the secrets of Excel and the Business Intelligence

Search for:

Functions

Condition
Date
Dynamic Arrays
Search

Calculation of tenths, hundredths and thousandths with Excel

Frédéric LE GUEN19/02/201431/01/2020

19/02/201431/01/202012197

Wildcard with COUNTIFS or SUMIFS

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

24/12/201828/06/202002991

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

What is the SPILL error?

Frédéric LE GUEN29/09/202007/03/2021

29/09/202007/03/202103451

Function IF – Examples with payments

Frédéric LE GUEN19/05/201918/06/2020

19/05/201918/06/20207 4171

News

Extract items that appear just once

07/03/202107/03/2021 909 0

Number to Words

26/01/202126/01/2021 1305 0

Excel as a sports coach

13/04/202014/04/2020 1269 0

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

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

Radar chart

30/12/202022/02/202112560

Sunburst Chart

28/12/202010/03/202120580

Tips and Tricks

Add Emojis to your charts, formulas

12/12/201928/02/202165492

Gantt Chart

03/11/201822/02/202124210

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)

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

Facebook Linkedin Youtube Rss

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