Week number in Excel: Avoid Mistakes

Improve your Excel skills by understanding week number calculation. Dive into the WEEKNUM and ISOWEEKNUM functions and their nuances.

How to Use the SUMIF Function in Excel

Learn how to correctly set the SUMIF function in Excel and avoid mistakes. Analyze data efficiently with this powerful function.

GROUPBY function: The future of COUNTIF SUMIF

Find out how to build and use the GROUPBY function in Excel 365. Group data, calculate summaries, and update instantly.

COUNTIF Function in Excel: A Must-Know Function

Master the COUNTIF function: Learn how to analyze and count data with this essential Excel function quickly.

COUNTIFS Function: Mastering Multi-Criteria Counting

Learn how to use the powerful COUNTIFS function in Excel. Count rows that meet multiple conditions for accurate data analysis.

Select the Top 5 Values with TAKE function

Learn how to find the top 5 values or the last 5 values from a list in Excel using the TAKE function and SORT function.

Write Months in Any Language in Excel

Discover the trick to displaying months in any language in Excel. Learn how to customize the date format and automate month names in Excel.

Compare Two Columns in Excel Easily

Find out how to compare columns in Excel and identify missing values or return only missing values with efficient formulas.

How to Use the VLOOKUP Function in Excel

Get a comprehensive understanding of the VLOOKUP function in Excel. Learn how to perform efficient searches in your tables.

Why VLOOKUP Returns #N/A Error

Discover why the VLOOKUP function returns an #N/A error in Excel. Learn the common causes and how to quickly fix VLOOKUP errors.

Easily Create a Running Total in Excel (No formula)

Discover Excel AI-powered features and tools can simplify Running Totals and make complex data easier to understand.

VLOOKUP Left Lookup Using INDEX or XLOOKUP

Explore advanced Excel techniques to overcome VLOOKUP limitations and retrieve data from the left with XLOOKUP or INDEX/MATCH.

Search in 2 Columns with VLOOKUP & XLOOKUP

How do you search in 2 columns in Excel? Why Search Two Columns? When working with dates and currencies, each date has different values for each currency. The currency code repeats daily. To get accurate results, we must build a unique identifier by combining the Date and Currency columns. VLOOKUP Isn't Ideal VLOOKUP only searches in the first column 😡. This is how the function has been developed. Now, if you need to search in 2 columns, you must transform the table and concatenate the two columns to create a new column. After that, you create your VLOOKUP function by using the column as the first column of your reference table. XLOOKUP Is Better If you work with Excel 365, Excel Online, and Excel 2021, it's better to use the XLOOKUP function. This function has been developed to remove the limitations of VLOOKUP. This includes performing a search in two […]

Convert TRUE/FALSE to 1/0 in Excel

Learn how to convert TRUE or FALSE to 1 or 0 in Excel. Discover two simple techniques for transforming logical test results effortlessly.

Return a Value Between Two Values in a Range

Discover a better way to find a value between two values in Excel. Learn how VLOOKUP and XLOOKUP functions can simplify your search.

Master XLOOKUP function in Excel

Learn how the XLOOKUP function in Excel 365 simplifies data lookup in tables. Find out how it improves VLOOKUP and handles errors better.

Excel IF Function Explained with Examples

Learn how to use the IF function in Excel. Get step-by-step instructions, examples, and tips for mastering this essential function.

Historical Stock Quotes with the STOCKHISTORY Function 🏦

Discover the power of the STOCKHISTORY function. Get historical stock quotes easily and analyze market trends with precision in Excel.

Calculate Percentage Change in Excel

Learn how to calculate percentage change in Excel and gain valuable insights into your data trends and performance.

Converting a Date from YYYYMMDD to DD/MM/YYYY in Excel

Easily convert dates from the format YYYYMMDD to DD/MM/YYYY in Excel using this simple formula or the Text to Column tool.

Excel Calendar with Automatic Monthly Data Saving 📅

Discover our Excel calendar data saving method. With our user-friendly template, you can effortlessly track and save timesheet updates.

Adding Headers to Tables Built with Dynamic Arrays

Discover the easy way to add headers to dynamic arrays in Excel. This will instantly improve the usability and visual appeal of your data.

How to Use the CHOOSECOLS Function in Excel

Discover the power of the CHOOSECOLS function in Excel for extracting specific columns and reordering data with ease.

Transform List to Matrix like Distance Table 🚗

How to convert a list of data to a double-entry table? Only one function is needed to do the job. See the technique in this article

Quickly Calculate Percentages in Excel Without Formulas

Learn how to calculate percentages in Excel without formulas using Quick Analysis. Simple steps for beginners and pros!

Unlocking the Secrets of Excel’s DATE Function

Learn how to use the DATE function in Excel to effortlessly create dates from values, cell references, or calculations.

Live Quotes Stock in Excel

Get real-time stock quotes in Excel for free with Microsoft 365. Learn how to connect to the Stock database and add live stock prices.

Bollinger Bands with Excel

Learn how to create Bollinger Bands in Excel to identify trend reversals. A step-by-step guide for traders and investors.

Create a Dynamic VLOOKUP function

Learn how to create a dynamic VLOOKUP with the MATCH function and customize your search criteria to return accurate results in Excel.

Displaying Days in Letters in Excel

This simple tip will improve readability and reduce errors in Excel: add the day of the week in letters to your dates.

Minutes to Hours converter with Excel

Need to convert minutes to hours in Excel? Find out how to do it effortlessly using specific functions and formulas.

Date Picker in Excel

Discover how to use the Date Picker feature in Excel Online to select dates accurately and efficiently. Many situations explained

The TIME function in Excel

Discover the power of the TIME function in Excel. Easily create time values and perform calculations using hours, minutes, and seconds.

How to Round a Number to the Nearest 10, 100 in Excel

Learn how to use the ROUND function to round numbers to the nearest 10, 100, or thousandth and simplify the understanding of your reports

Displaying Date and Time in the Same Cell

How to display date and time together in the same cell using custom number formatting. This tutorial explains you the steps

How to display Months in Letters in Excel?

Learn the simple trick to display months in letters instead of numbers in your Excel date. Clear instructions and examples

Calculate the Number of Days between 2 dates in Excel

Learn how to calculate the number of days between any two dates using in Excel. Easy-to-follow guide with clear explanations and examples

The WEEKDAY function – Secrets and Errors

Master the Excel WEEKDAY function with this easy-to-follow guide. Learn how to use it to determine the day of the week for any date.

Mastering the SORT Function in Excel

Learn how to sort your data dynamically in Excel using the SORT function. Sort single columns or entire tables with ease.

Build a nested IF in Excel

How to write nested IF in Excel? There is 3 situations and 3 functions that can be used. All the cases are explained here.

Function MOD (Modulo) of Excel

The MOD function of Excel is beneficial in many situations, and you can use it as a result, as a logical test, or with conditional formatting

Round nearest 10, 25, or 50 cents with Excel

How to round up by 10, 25 or 50 in Excel? This article gives you all the formulae to do this job with Excel.

Formula to Calculate Quarter with Excel

Discover how to calculate quarters in Excel for any date, whether it's the current, next, or previous quarter, with these formulas.

Separate Date and Time with Power Query

This step-by-step guide will walk you through the process of split your date and time data with Power Query.

Display negative time in Excel

Learn how to handle negative hours in Excel with these 3 simple methods. From formatting cells to using formulas, all explanations here.

Calculate Monday Previous Week with Excel

Learn how to find the date of the previous Monday using Excel. Streamline your scheduling and data analysis with this handy formula.

Calculate the Previous Monday with Excel

Formula to calculate the previous Monday with Excel, from TODAY or any date.

Calculate Monday in 2 weeks with Excel

Learn how to find the Monday in 2 weeks in Excel effortlessly. Boost efficiency and streamline workflows with this easy-to-use formula.

Calculate the Next Monday with Excel

Master the technique to find the next Monday effortlessly in Excel. Say goodbye to manual counting and hello to efficient date calculations.

Formula First Monday of the month with Excel

Formula to calculate the first Monday of the month with Excel

Calculate Monday 2 weeks ago with Excel

Formula to calculate Monday 2 weeks ago with Excel, from TODAY or any date.

Formula to Remove the VAT in Excel

How to remove VAT? To solve this, you don't need a specific Excel function. A combination of additions and divisions do the job.

Build a Logical Test in Excel

A logical test Is very important in Excel because it's the starting point for a lot of functions to create dynamic dashboards.

Convert a Text Date to a Number Date

Learn how to convert a text date, like '1 January 2023', to a number date format using Excel. Easily convert text dates to numerical values.

How to Create a Running Total in Excel?

Calculate a running total in Excel with ease. Follow our step-by-step guide and learn three different methods to analyze cumulative data.

Find duplicate values in Excel by formula?

Unlock the secrets of finding duplicate values in Excel effortlessly. Find out how to use FILTER and COUNTIF functions

How to do a Cube Root in Excel?

There is no cube root function in Excel. But there is a solution to perform a cube root calculation with another Excel function.

Dynamic SUM in Excel

Discover two powerful techniques for creating dynamic sums in Excel: Excel Tables and the SUM function with INDEX.

How to round in k$ with Excel?

Discover 3 techniques to round numbers in k in Excel. Learn how to use Paste Special, divide by formula, and create custom number formats.

Highlight the Date outside the deadline in Excel

How to highlight the dates outside the deadline in Excel? You must use the conditional formatting and create your own rule.

Add Days Excluding the Weekend in Excel

How to add days to a date excluding the weekend? In Excel, one function exists to do the job without mistakes.

How to Calculate the Week Number in Excel?

In Excel the way to return the week number is based on the American system. But most of countries use the ISO system. What is the technique to avoid mistakes.

How to display hours over 24 in Excel?

Discover how you can display time over 24 hours in your worksheets. You just have to customize the number format of your cells.

Exchange rate in Excel 🏛️

With the new feature of Office 365, Data Type, you can easily collect the last Exchange Rate between 2 currencies

TOP 10 Most Useful Statistical Functions for Data Analysis

Learn the top 10 most useful Excel statistical functions for data analysis, with clear explanations and examples.

How to build your dynamic dates in Excel

With Excel, you can build your dynamic date very easily. Discover how to build a dynamic date in this article.

Calculate any Day of the Week Using These Excel Formulas

All the formulas to calculate any day in a week, like the first Monday of the month, the last one, the next Tuesday, ...

How to use the INDEX function in Excel?

Learn how to use the INDEX function in Excel. Step-by-step guide for beginners and experts to improve your data analysis skills.

Time Format in Excel to avoid mistakes

Master time formatting in Excel. Learn how to display dates and times accurately, customize formats, and avoid common mistakes.

Change the Color of Weekends in Excel 🗓️🎨

Change the color of weekends in Excel with conditional formatting. Quick and easy with this step-by-step guide.

Calculate a date from the week number in Excel

Formula to calculate a date according to the week number. The result is not the same according to the iso week number system

How to calculate VAT in Excel?

How to calculate VAT in Excel? It's very easy and doesn't need a specific function. Many examples in this article.

Create a weekly calendar with just one formula in Excel

Unlock the potential of Excel by learning how to create a weekly calendar with just one formula. Step-by-step guide in this article.

Study Case with Excel Statistics functions

How to use Excel statistics functions? In this study case, we will analyze the wages of all the employees and what is the result.

What is the Most Common Value in your Excel document.

You can easily return the most common number in a range of cells with the function MODE or MODE.SNGL

First day – Last day in Excel

This article is a glossary of all the Excel functions to return the first day or the last day of the Month, the Quarter or the Year

DATEDIFF for POWER QUERY

This article gives you the M Code for Power Query to return the result of the DATEDIFF function (difference between 2 dates)

The FILTER Function in Excel

The FILTER function of Excel returns all the rows corresponding to a specific criteria. It's possible because of the Dynamic Arrays of Microsoft 365

Extract only the numbers of a cell in Excel

Want to extract numbers from cells with mixed characters? Discover the step-by-step process using the SEQUENCE and FILTER functions.

Calculate Moving Average in Excel

Learn how to calculate a moving average in Excel. Use the AVERAGE function to smooth out data and identify trends.

Calculate Seniority in Excel

Calculate seniority is an easy task with Excel when you use the appropriate function.

UNIQUE Function – Remove duplicates with formulas

UNIQUE is a new Excel function to remove automatically the duplicates in a list of data. It's amazing how simple is it to use this function

The DATEDIF function in Excel

Want to calculate date differences? Learn how to use the DATEDIF function in Excel to determine the age between dates accurately.

Create your custom functions with LAMBDA

Discover how to create custom Excel functions using the LAMBDA function and named ranges in Microsoft 365.

Calculate Public holidays with Excel 📆

Discover how Excel can make it easy to calculate public holidays. Learn simple formulas to automate the process and never miss a holiday again.

Change the default Date format in Excel

Learn how to effortlessly change the default date format in Excel using these instructions. Enhance your Excel experience with this guide.

How to Highlight a Birthday Reminder in Excel

This step-by-step guide will explain to you how to build a birthday reminder in Excel with a specific color when the event occurs

SUMIFS Function in Excel

Discover how to use the SUMIFS function in Excel to filter and sum data based on multiple criteria in your worksheets

Create a Lookup Offset

When you have many times the same ID in your table, the following formula will help you to create a lookup offset.

Understand the Standard Deviation

Learn to calculate and interpret standard deviation to better understand your average results.

Basic calculations with Excel

Learn how to perform basic calculations in Excel with ease. Follow simple rules and formulas to avoid mistakes and get accurate results.

Find Weekend or Weekday in Excel

Discover how you can easily find weekends or weekdays with Excel functions. No complex formulas are necessary.

Functions AND – OR with Excel

Master Excel's logic functions to create powerful tests. Understand how the AND and OR functions can enhance your data analysis.

The SUM function – All Tricks

SUM is the most used Excel function. There is nothing complex to use this function but there is also tricks behind this function

3D Formula in Excel

In Excel, you can build 3D formulas by making a relationship through many worksheets. Let's see how to build a 3D formula.

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.