Excel Tutorials

There is a number of ways for calculating the difference between two dates in Excel. In this tutorial, we will discuss three ways.

Excel REPLACE and SUBSTITUTE functions can be used for replacing new text string by existing text in the given text.

The IF statement is generally taken as a decision making statement. In Excel, the IF is a function that enables us doing that.

In Excel VLOOKUP tutorial, explore real-world scenarios and learn how to apply this powerful function for data retrieval.

Learn how to change the date format in Excel by using three different ways in our detailed tutorial @ jQuery-az.com

The SUMPRODUCT function is used to multiply corresponding arrays or ranges and returns the sum. The SUMPRODUCT function is versatile.

In this tutorial, I will show you how to make dropdown list in Excel with examples. Not only will I show you ways of how to create dropdown but how to use its values in different formulas as well.

In Excel, you may calculate the age in a number of ways. In this tutorial, we will describe four ways of calculating age in Excel.