How to Use the Excel OFFSET Function

This tutorial explains the uses of Excel OFFSET function with examples. You also learn how to use the OFFSET to create a dynamic range...

How to use Excel New IFS Function

In this tutorial, you’ll learn about newly introduced Excel IFS function that can be used as an alternative to the nested IF statements. You...

How to use Vlookup Function in Microsoft Excel

In this article, you will see the exciting and interesting use of one of the powerful Excel VLOOKUP function. The article covers real life...

How to use Excel EDATE Function

This article explains the syntax and the use of the EDATE function in Microsoft Excel. The Excel EDATE function returns the serial number that represents...

How to use Excel DAYS function

This article explains the syntax and the use of DAYS function in Excel. The Microsoft Excel DAYS function returns the number of days between two...

How to use Excel Day Function

This article explains the syntax and the use of Excel DAY function in Excel. The Excel DAY function returns the day of the month from...

How to use Excel MONTH Function

This article explains the syntax and the use of Excel MONTH function in Excel. The Excel MONTH function returns the serial number corresponding to a...

How to use AND function in Microsoft Excel

Use AND function to check one or more conditions at the same time. It returns TRUE if all the supplied logical arguments meet the...

How to use Excel DATE Function

In this tutorial, I am going to explain the syntax and usage of Excel DATE function in Microsoft Excel. The Excel DATE function returns the...

How to use Excel CHAR Function

This article explains the syntax and the use of the CHAR function in Microsoft Excel. Description: The CHAR function returns the character specified by a code...