Do you need to combine Excel cells for your analysis? This blog post explains you to join one or more cells in Excel. Splitting and Concatenating text are basic tasks…
The Microsoft Excel NOW Function returns the current date and time. When you need to keep track of when particular activities are accomplished or when you need to reference the…
You may give a password to protect the worksheet in excel to prevent other users from accidentally or deliberately changing the data in your worksheet. Or, you may want to…
When you’re trying to display data with complex relationships, sometimes a table just won’t cut it. You need to use charts instead, but programming them in Excel can be challenging.…
In Excel, an user defined function (UDF) is a function that is created by the user to perform a specific task. UDFs are written in Visual Basic for Applications (VBA),…
Do you need to create a custom function in excel for your project? This post explains how to create a custom function to count the number of vowels in a…
This post explains how to remove duplicates from a range of cells using excel VBA. Removing duplicates from a list, array, or range of cells is a basic operation in…
Do you have to check multiple criteria in your project? You can use the Select Case statement instead of using a nested if statement in your project. In this article,…
This is one of the lookup and reference functions in excel. It is handy to look up your data for data analysis. Mapping data between tables is an essential data…