Formulas to Calculate Age in Excel In Excel, you may calculate the age in a number of ways. It is up to your choice and requirements that Continue Reading

# VBA / Excel Tutorials

The Excel DATEDIF function takes the start date, end date, unit and calculates the difference in terms of days, months or years between these two dates. The Continue Reading

Suppose we have a sentence “Excel has plenty of functions.” We want to find the position of “plenty” in that sentence. The position means from which number Continue Reading

Finding the duplicate data is quite simple in Excel. You do not require writing any formula but following a few mouse clicks in the menu/Toolbar. In this Continue Reading

The Excel MATCH function returns the relative position of the specified item from the given range of cells. For example, we have fruit names in column B: Continue Reading

The Excel simple IF function enables us testing a condition and returns True or False value. For example, in a student mark sheet, if Marks is less Continue Reading

This is natural that error occurs as you run different Excel Formulas. For example, #DIV/0! Error occurs as you try dividing a number by 0. Similarly, as Continue Reading

The IF statement is generally taken as a decision-making statement – to take a decision based on certain options/conditions. If the given condition is TRUE then execute Continue Reading

An Introduction to VLOOKUP function Let me start with an example to explain what is Excel VLOOKUP function? If you know a little about VLOOKUP then move Continue Reading

You want to count the number of times word “Microsoft” appears from the cell A2 to A1000. How can you do that? One way is to go Continue Reading

The VBA while loop is used to execute the given statements as long as the condition is True. If the condition is false on the first check, Continue Reading

The VBA for loop is used to execute the group of statements for the given number of times. For example, you have ten cells in Excel sheet Continue Reading

The Select Case is another decision making statement in VBA that may be useful for scenarios where you have a single expression to evaluate that has several Continue Reading

For interacting with the users of your application, you may create dialog boxes. In VBA, a dialog box can be created by using the MsgBox function. The Continue Reading

In VBA, the if is a decision-making statement that is used to execute a block of code if a certain condition is true. For example, if you Continue Reading