### How to use the CONCATENATE function in Excel

If you want to join multiple texts, numbers or function values into one cell, Excel has a function called CONCATENATE(). You can use the function is some very creative ways. Simple text concatenation The CONCATENATE...read more

### How to add numbers in a column in Excel

Adding numbers in a column or on a row is one of the most basic Excel Functions. Here are 3 easy ways to do it. Use simple addition ( the plus sign +) Use the...read more

### How to use SUMIF in Excel

SUMIF formula is great for summarizing data in a large dataset. A better method to summarize the data is a pivot table. But if only a quick summary is required, SUMIF might be an easier...read more

### Excel IF statement

IF statement is one of the most common programming function. It is also one of the most used ones in Excel. The IF function can be used with one condition, as described below or with...read more

### How to calculate age in Excel

To calculate age from date of birth in Excel, you must use one of the two formulas below =(TODAY()-DOB)/365.25=DATEDIF(DOB,TODAY(),"Y")where DOB is the range (cell) that has the Date of Birth value Age calculation can be...read more

### How to find duplicates in Excel

Finding duplicates in Excel is a very common task when dealing with large sets of data. Excel has some very easy methods to remove or highlight duplicates. You can also use some functions to help...read more

### How to create an Excel macro without coding – Excel macro tutorial

Excel macros sound scary but they don't have to be. You don't have to be a programmer to start with Excel macros. If you are not a programmer or don't even intend to be, this...read more

### How to start a macro when a worksheet changes

In this tutorial you will learn how to start a macro when a worksheet changes. This is a follow up tutorial from the creating a macro tutorial. In that tutorial, the goal was to have...read more

### Excel Formula: Get day name from a date in Excel

Here are a few methods to get a day name (Monday, Tuesday, Wednesday etc) from a date field in Excel. If you prefer video, see the tutorials below. Use Excel TEXT formula The Excel Text...read more