EXCEL EXERCISE - All Tricks, News, Advices, Formulas

29/07/2021

Top Articles

Convert list to Double-Entry Table

Create a Lookup Offset

Function INDEX in Excel

Weekends or weekdays in Excel

Color an entire row by formula

Import Many Workbooks in a single one

Change the color according to the value

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

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
  Convert list to Double-Entry Table
  13/07/2021
  Function
  Create a Lookup Offset
  05/07/2021
  Function
  Function INDEX in Excel
  03/07/2021
  Function
  Weekends or weekdays in Excel
  29/05/2021
  Function
  Extract items that appear just once
  07/03/2021
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:

Most popular articles

Date Format in Excel

Frédéric LE GUEN02/08/201823/04/2021

02/08/201823/04/202123279

Conditional Formatting

Displaying Negative Numbers in Parentheses – Excel

Frédéric LE GUEN08/02/202128/02/2021

08/02/202128/02/202123186

How to make automatic calendar in Excel

Frédéric LE GUEN26/11/201820/01/2021

26/11/201820/01/202122775

Formulas to include or exclude tax

Frédéric LE GUEN20/11/201817/06/2020

20/11/201817/06/202017230

Tips and Tricks

Compare 2 Columns

Frédéric LE GUEN14/01/202021/07/2021

14/01/202021/07/202116569

Split Date and Time

Frédéric LE GUEN18/04/202002/03/2021

18/04/202002/03/202115846

Exchange rate in Excel

Frédéric LE GUEN17/11/201928/02/2021

17/11/201928/02/202114559

Convert YYYYMMDD to DD/MM/YYYY

Frédéric LE GUEN15/12/201828/02/2021

15/12/201828/02/202114487

Conditional Formatting

Dash for 0 in Excel

Frédéric LE GUEN03/01/202001/03/2020

03/01/202001/03/202013405

Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde

Frédéric LE GUEN07/01/201807/03/2021

07/01/201807/03/202112561

Comma or Semicolon in an Excel formula

Frédéric LE GUEN15/11/202028/02/2021

15/11/202028/02/202112020

Tips and Tricks

Add Emojis to your charts, formulas

Frédéric LE GUEN12/12/201928/02/2021

12/12/201928/02/202111779

Function DATE – YEAR – MONTH – DAY

Frédéric LE GUEN28/08/201621/01/2021

28/08/201621/01/202111519

Dynamic SUM in Excel

Frédéric LE GUEN17/02/202128/02/2021

17/02/202128/02/202111399

XLS or XLSX file ?

Frédéric LE GUEN14/12/201303/03/2020

14/12/201303/03/202010752

Population Pyramid

Frédéric LE GUEN15/01/201215/04/2020

15/01/201215/04/20209864

News

Extract items that appear just once

07/03/202107/03/2021 2440 0

Number to Words

26/01/202126/01/2021 2618 1

Excel as a sports coach

13/04/202014/04/2020 2075 0

Exchange rate in Excel

17/11/201928/02/2021 14559 1

Conditional Formatting

Create a progress bar with icons

09/06/201914/04/2020 3699 1

Excel on your mobile for free

17/11/201428/11/2019 3934 0

Videos

Thumbnail youtube How to Change the color in Excel by formula -... 07:36 Thumbnail youtube Pin Data on Map with Excel 08:08 Thumbnail youtube How to Compare two columns with Excel 04:30 Thumbnail youtube Excel Trick - Draw your Border by following the lines... 04:25

Categories

Beginner (19)
Expert (14)
Tips and Tricks (14)
Conditional Formatting (13)
Statistics (13)
Manage data (8)
Advanced (7)
What is New (6)
Charts (5)
Pivot Table (5)
Text functions (5)
Shortcuts (4)
Power Query (3)
Maps and GPS (3)
Data Type (1)
Function (47)

Social Networks

Last post

Convert list to Double-Entry Table

Frédéric LE GUEN13/07/202113/07/2021

13/07/202113/07/2021337

Create a Lookup Offset

Frédéric LE GUEN05/07/202114/07/2021

05/07/202114/07/2021439

Function INDEX in Excel

Frédéric LE GUEN03/07/202113/07/2021

03/07/202113/07/20211568

Weekends or weekdays in Excel

Frédéric LE GUEN29/05/202107/12/2020

29/05/202107/12/20201505

Color an entire row by formula

Frédéric LE GUEN10/05/202110/05/2021

10/05/202110/05/20211455

@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