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.

Quotations Stock Market History in Excel

Collect historical stock quotations with the STOCKHISTORY function in Excel. Learn how to use this powerful tool for analyzing stock data

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.

Running total in Excel with AI

Excel's AI features can help you perform a running total without writing a formula. Use the Quick Analysis tool for seamless data analysis.

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

Customize your date format in Excel to display days in letters and dates. Avoid errors and save time with this helpful feature.

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

=TIME(Hours,Minutes,Seconds) Times is necessarily a decimal value In Excel, hours are always a fraction of a day. So it is necessarily decimal numbers (ALWAYS). This rule is fundamental to avoid mistakes in calculation and display. For instance, in the following picture, we have the value 0.5 in a cell. If we change the format number to the Time format, we have 12 hours this time. This is logical because 12 hours is the middle of the day, so 0.5 day 😉 Most people use integer numbers to write their time values. It's a fact that writing a time in Excel is not easy because you must use the symbol colon ( : ), like 12:00:00. Many people prefer to write the value 12 (an integer number). But when you apply a Time format to an integer number, the only result you have it's 00:00:00 😱😱😱 TIME function to transform your […]

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

Write Months in Excel in a Foreign Language

Learn how to write automatically your Months in any Foreign Language in the world. This step-by-step guide will show you the trick.

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

=WEEKDAY(Date,Localization) How to use the WEEKDAY function The WEEKDAY function operates with minimal arguments, just a date =WEEKDAY(A1) Yet the returned result may pose confusion. The 13/11/2023 is a Monday and the WEEKDAY function returns 2; WHY? The function, developed by Microsoft, an American company, reflects the U.S. convention where the week starts on Sunday, making Monday the second day. This is why, if you don't use the same US convention for the first day of the week, the results of the WEEKDAY function can insert errors in your report. Explanation of the second argument The second parameter is optional but very useful if you are NOT in USA or Canada. While Monday is the default first day for most countries globally, specifying this argument ensures accurate calendar settings. You can set values for the second argument as follows: The screenshot displays the different results returned for the same date […]

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.

Return a result between 2 values

How to return a result between two values? With the XLOOKUP function, you can search in both directions, smaller or larger.

Why VLOOKUP returns #N/A?

Unravel the mystery behind the #N/A error in VLOOKUP formulas. Learn how to identify and fix common mistakes that lead to this error

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

The 10 most useful Excel Functions

What are the 10 most useful Excel functions that you need to know? This article presents them with examples.

Round to 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

Easily determine the quarter for any date with these Excel formulas. Learn how to calculate quarters in Excel in just a few steps.

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.

Save Data Automatically with Excel Calendar

Download our automated monthly calendar to streamline your scheduling! Ideal for busy professionals, students, organization

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.

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.

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.

Select the top 5 by formula in Excel

With the new Excel CHOOSEROWS function, it's easy to extract the top / bottom rows of your data. Let's discover how to build it.

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.

Convert YYYYMMDD to DD/MM/YYYY with Excel

You can easily convert date YYYYMMDD to DD/MM/YYYY in Excel with formulae or with the tool Table to Column in 3 step

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.

Percentage change in Excel

What is the formula to calculate the percentage of increase or decrease between 2 cells is very simple in Excel.

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.

Function XLOOKUP in Excel

How to use the XLOOKUP function of Excel? It's a combination of the VLOOKUP and INDEX functions. Look at this article.

The VLOOKUP function in Excel

The VLOOKUP function helps you to return a specific value inside a table. How to use it? It's not difficult.

The IF Function with Excel

Discover all the tricks and mistakes you can have with the IF function

How to do a VLOOKUP on 2 columns

There is two techniques to build a research based on 2 columns. One is with VLOOKUP and the other, the easiest, with XLOOKUP

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.

How to Compare 2 Columns in Excel

Learn how to compare two columns in Excel efficiently using simple techniques. Easy-to-follow guide with clear explanations and examples.

All formulas to calculate any day

All formulas that allow you to calculate the following or previous days such as Monday, Tuesday, Wednesday, ...

Create a weekly calendar with just one formula in Excel

Generate a dynamic weekly calendar in Excel with this single powerful formula SEQUENCE. Easy and efficient

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.

VLOOKUP to the left in Excel

The function VLOOKUP is not able to return a value on the left of the search column. But you can do the job with XLOOKUP or INDEX MATCH

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

How to calculate the public holidays in Excel? This article will present many formulae to calculate those dates according to the year.

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

Transform List to Double-entry 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

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

The standard deviation helps you to have a better understanding of the result of your averages. In this article, all the explanations.

Basic calculations with Excel

How to do a calculation or a formula in Excel? It's very simple but you have a few rules to know to avoid mistakes.

The COUNTIF Function in Excel

The COUNTIF function of Excel returns the number of rows within a range according to a criterion. Learn how to use it in this article.

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.

Dynamic SUM in Excel

There is 2 methods to create a dynamic SUM in Excel. The first one uses the technique with a Table, the second one uses the function INDEX.

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.

COUNTIFS – Count rows automatically in Excel

The COUNTIFS function in Excel works like a filter. It returns the number of rows you have in a worksheet based on one or more criteria.

Round to the next decimal range

How to round up or down for decimals, like for instance, 10 cents, 25 cents, 50 cents? The different formulae explain in this article

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.

SUMIF Function in Excel

The SUMIF function calculates the sum of specific cells according to a criterion, like a product, country, seller's name, ...

What is the SPILL error in Excel?

SPILL is a new Excel error that occurs when Excel hasn't had enough space to return the result.

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

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

Convert TRUE or FALSE to 1 or 0 in Excel

Discover two easy techniques to convert true or false to 1 or 0 in Excel. Improve your data analysis skills today.

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.

Calculation of tenths, hundredths and thousandths with Excel

It's not easy to make calculation with time in Excel, especially if you want to do calculation for tenths, hundredths and thousandths.In this article, you will have all the explanations to do such calculation.