Hit enter after type your search item

# VBA / Excel Tutorials

## 4 Ways of How to Calculate Age in Excel (Years, Months and Days)

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

## The DATEDIF Function in Excel

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

## What are Excel FIND and SEARCH functions?

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

## Identifying the Duplicate Data in Excel sheet

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 MATCH function in Excel

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

## Using Excel AND function with IF

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

## What is the purpose of IFERROR function?

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 function in Excel

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

## What is Excel VLOOKUP function (for dummies)?

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

## The COUNTIF function in Excel

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 While and Do loops in VBA

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 For loop in Excel VBA

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 VBA select case statement

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

## The VBA MsgBox function

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

## The VBA if statement

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