Function

Want to become an Excel expert? Start by mastering Excel functions. Our guide provides in-depth explanations and examples for each function.

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.

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.

Negative numbers between parenthesis cover

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

Function

Categories

Function