Excel Tutorials

Excel Dropdown List

In this tutorial, I will show you how to make dropdown list in Excel with examples. Not only will I show you ways of how to create dropdown but how to use its values in different formulas as well.

Excel Subtract/Add Date Formulas

There is a number of ways for calculating the difference between two dates in Excel. You may get the number of days, months and years by using these ways along with adding or subtracting and getting the resultant dates.

Visual Guide: Modifying Excel Text with REPLACE and SUBSTITUTE Functions for Data Management/Editing

Replace Text in Excel by REPLACE & SUBSTITUTE Functions

The Excel REPLACE and SUBSTITUTE functions can be used for replacing new text string by existing text in the given text. See the examples, syntax, and difference between these two functions by this tutorial.

How to Round Numbers in Excel?

The Excel has a number of functions that enable rounding the decimal numbers as per the need. These functions are: ROUND
ROUNDUP, ROUNDDOWN and MROUND

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…

How to Identify/Remove Duplicate Data in Excel sheet

In this tutorial, I will show you step by step of how to find the duplicate data in rows/columns. This is followed by steps for deleting the duplicate data.