Excel Tutorials - Easy Simple Smart

How to use the CONCATENATE function in Excel

Posted on October 19, 2019 by Paul

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

Posted on October 18, 2019 by Paul

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

Posted on October 12, 2019 by Paul

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

Posted on October 9, 2019 by Paul

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

Posted on October 9, 2019 by Paul

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

Posted on October 4, 2019 by Paul

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

Posted on September 29, 2019 by Paul

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 with a button

Posted on September 29, 2019 by Paul

In this tutorial you will learn how to create an Excel Macro Button. This is a follow up from creating a a macro tutorial. If you want to learn how to record a macro and...read more

How to start a macro when a worksheet changes

Posted on September 29, 2019 by Paul

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

Posted on September 27, 2019 by Paul

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

Easy Simple Smart

Digital Products

Category: Excel

How to use the CONCATENATE function in Excel

How to add numbers in a column in Excel

How to use SUMIF in Excel

Excel IF statement

How to calculate age in Excel

How to find duplicates in Excel

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

How to start a macro with a button

How to start a macro when a worksheet changes

Excel Formula: Get day name from a date in Excel