Find Items That Appear Only Once
Discover How to Extract Only the Unique Values of a list of data in Excel with the UNIQUE function.
Function
Want to become an Excel expert? Start by mastering Excel functions. Our guide provides in-depth explanations and examples for each function.
How to return multiple rows with VLOOKUP
If you want to return many rows, you can't use the VLOOKUP function. But you can do the job with the FILTER function.
TODAY and NOW function in Excel
The functions NOW & TODAY are very useful in Excel. It's the only way to build dynamic date to calculate gap between dates.
How to create Dependent Drop down List in Excel?
This step-by-step guide will teach you how to create a dependent drop down list in Excel. You need to use the UNIQUE and FILTER functions.
Displaying Negative Numbers in Parentheses in Excel
Discover how to format negative numbers in Excel with parentheses. Improve the readability of your data with this simple technique.
What is the SPILL error in Excel?
Discover what causes the #SPILL! error in Excel and how it relates to dynamic array formulas and insufficient space for result display.
Title with Text and Date in the same cell
Learn how to use the TEXT function in Excel to format numbers and keep the desired number format inside a string.
Date Format in Excel
Discover how to customize your date format in Excel easily by changing the day, month, or year. There are many examples.
How to use the MATCH function in Excel?
The MATCH function returns the position of an item in a list. This function is very useful to create DYNAMIC dashboard and formulas
Excel Split Date and Time
Discover how to separate date and time in Excel with ease. Use the INT and subtraction functions to extract the desired values.
How to Display Tenths, Hundredths with Excel
Learn how to display tenths, hundredths, or thousandths of a second in Excel with a custom time format for accurate analysis.
Function XOR in Excel
Master the exclusive OR function (XOR) in Excel. Understand its unique logic and apply it to various scenarios to enhance your Excel skills.
Function DATE – YEAR – MONTH – DAY
The function DATE is very useful to create your custom dates. This article will explain you how the function works
Wildcard with COUNTIFS or SUMIFS
You can create complex criteria in your COUNTIFS or SUMIFS function with the wildcart.The wildcards are specials characters to replace one or more characters in your string
Mortgage calculator with Excel 💰
Learn how to create a mortgage calculator in Excel using the PMT function. Then, you can easily and accurately calculate your loan payments.
How to make automatic calendar in Excel
This article present how can create an automatic calendar in excel to avoid and refresh manually your worksheet, step by step. Tutorial video available.
Anonymize your data
Discover how you can transform your worksheet to anonymise your data in the case you have sensitive data. 5 steps are needed
1 2
Categories
- AI & Excel (1)
- Conditional (12)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (11)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (15)
- Excel Tutorial (16)
- Expert (26)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (19)
- Lookup functions (14)
- Manage data (18)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (6)
- Quiz Premium (7)
- Shortcuts (5)
- Statistical functions (25)
- Text functions (19)
- Tips and Tricks (21)
Function
Identifying Weekdays and Weekends with Excel
How to Round Numbers to 0.99 in Excel
Group Data per 15 Minute Interval in Excel
Rounding Numbers in Excel: 8 Functions Explained
CHOOSECOLS function in Excel
Who Gets the Lowest and Highest Values with Excel
GROUPBY vs SUMIF in Excel
Nested IF and IFS Functions in Excel
Calculate Week Number Excel: A Quick Guide
Week number in Excel: Avoid Mistakes
How to Use the SUMIF Function in Excel
GROUPBY function: The future of COUNTIF SUMIF
COUNTIF Function in Excel: A Must-Know Function
COUNTIFS Function: Mastering Multi-Criteria Counting
Select the Top 5 Values with TAKE function
Write Months in Any Language in Excel
Compare Two Columns in Excel Easily
How to Use the VLOOKUP Function in Excel
Why VLOOKUP Returns #N/A Error
Easily Create a Running Total in Excel (No formula)
VLOOKUP Left Lookup Using INDEX or XLOOKUP
Search in 2 Columns with VLOOKUP & XLOOKUP
Convert TRUE/FALSE to 1/0 in Excel
Return a Value Between Two Values in a Range
Master XLOOKUP function in Excel
Excel IF Function Explained with Examples
Historical Stock Quotes with the STOCKHISTORY Function 🏦
Calculate Percentage Change in Excel
Converting a Date from YYYYMMDD to DD/MM/YYYY in Excel
Excel Calendar with Automatic Monthly Data Saving 📅
Adding Headers to Tables Built with Dynamic Arrays
Transform List to Matrix like Distance Table 🚗
Quickly Calculate Percentages in Excel Without Formulas
Unlocking the Secrets of Excel’s DATE Function
Live Quotes Stock in Excel
Bollinger Bands with Excel
Create a Dynamic VLOOKUP function
Displaying Days in Letters in Excel
Minutes to Hours converter with Excel
Date Picker in Excel
The TIME function in Excel
How to Round a Number to the Nearest 10, 100 in Excel
Displaying Date and Time in the Same Cell
How to display Months in Letters in Excel?
Calculate the Number of Days between 2 dates in Excel
The WEEKDAY function – Secrets and Errors
Mastering the SORT Function in Excel
Function MOD (Modulo) of Excel
Round nearest 10, 25, or 50 cents with Excel
Formula to Calculate Quarter with Excel
Display negative time in Excel
Calculate Monday Previous Week with Excel
Calculate the Previous Monday with Excel
Calculate Monday in 2 weeks with Excel
Calculate the Next Monday with Excel
Formula First Monday of the month with Excel
Calculate Monday 2 weeks ago with Excel
Formula to Remove the VAT in Excel
Build a Logical Test in Excel
Convert a Text Date to a Number Date
How to Create a Running Total in Excel?
Find duplicate values in Excel by formula?
How to do a Cube Root in Excel?
Dynamic SUM in Excel
How to round in k$ with Excel?
Highlight the Date outside the deadline in Excel
Add Days Excluding the Weekend in Excel
How to Calculate the Week Number in Excel?
How to display hours over 24 in Excel?
Exchange rate in Excel 🏛️
TOP 10 Most Useful Statistical Functions for Data Analysis
How to build your dynamic dates in Excel
Calculate any Day of the Week Using These Excel Formulas
How to use the INDEX function in Excel?
Time Format in Excel to avoid mistakes
Change the Color of Weekends in Excel 🗓️🎨
How to calculate VAT in Excel?
Create a weekly calendar with just one formula in Excel
Study Case with Excel Statistics functions
What is the Most Common Value in your Excel document.
First day – Last day in Excel
DATEDIFF for POWER QUERY
The FILTER Function in Excel
Extract only the numbers of a cell in Excel
Calculate Moving Average in Excel
Calculate Seniority in Excel
UNIQUE Function – Remove duplicates with formulas
The DATEDIF function in Excel
Create your custom functions with LAMBDA
Calculate Public holidays with Excel 📆
Change the default Date format in Excel
How to Highlight a Birthday Reminder in Excel
SUMIFS Function in Excel
Create a Lookup Offset
Understand the Standard Deviation
Basic calculations with Excel
Functions AND – OR with Excel
The SUM function – All Tricks
3D Formula in Excel
