Excel Exercise

Tips and Tricks, Advice, Formula, News

Home
Sitemap
Video on YouTube
Contact
Français

Excel category

's articles list

To print an extract, get over the title

3D Function
Absolute Relative Reference – Dollar in Formula
Add Days Excluding the Weekend
Add Emojis to your charts, formulas
Add filter option for all your columns in a pivot table
Anonymise your data
Basic calculation
Build a Logical Test in Excel
Calculate between two values
Calculate Percentage Increase with Excel
Calculation of tenths, hundredths and thousandths with Excel
Calculation without equal
Change the color of holidays
Change the color of the weekends
Change the language of Office
Change the Themes
Comma or Semicolon in an Excel formula
Compare 2 Columns
Conditional Formatting – Color scales
Conditional Formatting – Highlight highest values
Conditional Formatting – Highlighting dates
Convert Coordinates Latitude and Longitude
Convert roman numerals with Excel
Convert TRUE or FALSE to 1 or 0
Convert YYYYMMDD to DD/MM/YYYY
Copy Paste
COUNTIFS – Count rows automatically in Excel
Create a progress bar with icons
Create an Offset Vlookup
Create an online survey with Excel
Create test on String Length
Custom rule for conditional formatting
Dash for 0 in Excel
Date Format in Excel
Difference between 2 dates – DATEDIF
Display bars in the cells
Displaying Negative Numbers in Parentheses – Excel
Draw your borders with the mouse
Dynamic Dropdown List
Dynamic SUM in Excel
Dynamic VLOOKUP research
Example of Date, Week, Gap in days
Examples of Paste Special (All Options)
Excel as a sports coach
Excel could be a database with VLOOKUP
Excel for free
Excel on your mobile for free
Exchange rate in Excel
Explanation of the VBA code for the calendar
Extract random data of your database
Extract text without a formula
Fill Series
Filter your data in Excel
First day – Last day in Excel
Formulas to include or exclude tax
Function COUNTIF
Function DATE – YEAR – MONTH – DAY
Function IF – Examples with payments
Function INDEX in Excel
Function INDIRECT
Function MOD (Modulo)
Function SEARCH
Function SUM
Function SUMIF
Function SUMIFS
Function XOR
Functions AND – OR
Functions LEFT – RIGHT – MID
Gantt Chart
How to become Office Insider
How to display hours over 24
How to Highlight a Birthday Automatically
How to make automatic calendar in Excel
How to round in k$ without formula?
Insert Icons in your cells
Inspect a Formula with F9
Keep your Last Updated Data
MATCH function returns a position
Mixed References
Mortgage calculator with Excel
Most common number in my spreadsheet
Move and Copy worksheets quickly
NOW & TODAY
Pivot Table – Presentation
Population Pyramid
Quick Analysis
Relationship between tables
Remove Duplicates
Remove spaces in Excel with TRIM
Reorder your data from one column to many
Round to the Nearest Ten, Hundred, Multiple..
Running Total in Excel
Shorcuts – Function Key
Shortcuts – Alt Key
Shortcuts – Control Key
Shortcuts for the pros
Split report to many sub-reports automatically
Split Time and Date
Start Excel with your custom parameters
Statistics functions in Excel
The Correct Value for a Week Number
Time Formats in Excel
Title with date in Excel
Understand Standard Deviation
Use the Cell Value in your Calculation
Vlookup to the left in Excel
Weekends or weekdays in Excel
Weekly calendar 2020 in one formula
What is a conditional formatting
Wildcard with COUNTIFS or SUMIFS
XLOOKUP is a Formula 1
XLS or XLSX file ?

Excel 2013, Excel 2016, Excel online, XLSX file

Permanent link to this article: https://www.excel-exercise.com/xls-xlsx-file/

Microsoft Award

Author and Web developper

Frédéric LE GUEN

Subscribe

All rights reserved to FLG Consulting Services Ltd (2018)- Privacy policy

Web design : Isidore, le majordome du Net

Made with by Graphene Themes.