What is Target Address in Excel

In MS Excel, Target is the name assigned to the Range object variable that is passed on as the argument of Worksheet Object Events in case of events like Worksheet_Change […]

How to use If Else Formula in Excel

To use the “IF” function properly we need to understand the syntax of the formula and what parameters it requires to work. So let’s see the structure of the formula […]

How to skip a line in Excel

Suppose we have a data set that has the home addresses of people just like shown below.  We want to insert a line break after each comma in the cell. […]

What is $ in Excel

Get next Friday date in Excel

In this tutorial we’ll learn how to find Next Friday (i.e. The Friday of the next week) from any given date. Let’s look at the data set in the picture. […]

Excel round up a value to nearest whole number

How to insert row in Excel 

How to use Countif to count the non blank rows in Excel

The best way to understand how countif works is to first understand the structure of the function and the parameters it requires. Structure of COUNTIF The standard syntax of countif […]

How to calculate the distance between two addresses in Excel

London and Bristol, the two major cities of England, have the latitude and longitude given in the image below.

How to calculate the Z score to percentile in Excel

Z-score is the numerical representation of the relationship of a value with the mean of a group of values. Z-score is measured with reference to standard deviations from the mean. […]

How to calculate the date of 13 weeks from now in Excel

Break down of the formula: We used the DATE function of Excel and the format of the DATE function is as follows; DATE(year, month, day) This function is used to […]

How to insert inches symbol in Excel

So by using this simple trick you can add an inch symbol to all your data entries.

UTC to PST Converter in Excel

So let’s see how to convert the time zone of UTC(Universal Time Coordinated) to PST(Pacific Standard Time). Before moving ahead we should know the time difference between the two time […]

How many weekends in a month

Understanding the syntax Suppose we have an excel worksheet with month and year inputs in seperate cells as shown. To get the list of weekends in the given month of […]

How to insert a text box in Excel

You can watch a video tutorial here. So this is how you can insert the textbox in MS Excel.