ASM Arman

While using formulas in Excel, you might not get the result you expect the formula will return, or sometimes the formula will even throw an error. Getting such ...

While working with categorical information in Excel i.e., products of different categories, you might need to create a drop-down list with unique values from ...

If you are working with dates in Excel, you might need to find out the first day of the month before the current month you are working with. In Excel, you can ...

If you are working on different categories of information in an Excel worksheet, you might need to find out and count all the unique values of the categories ...

While converting numbers to text in Excel, you will find that Excel removes the trailing zeros after the decimal point of a number. There is a simple solution ...

If you are working with data with different categories or have cells with the same value in your Excel worksheet, then you might need to group the cells with ...

While using formulas in Excel, we have to insert a specific range of cells to make the formula work or get the desired result. In this tutorial, I will show ...

If you are working with different Excel files that contain the same type of information i.e, information of the employees from different departments of a large ...

While working with a list of any kind i.e, a list of products or a list of employees you might come across a lot of blank cells in it. While such blank cells ...

You can use the Does Not Contain feature of Advance Filter to filter out the rows that do not contain a specific text or multiple texts. In this tutorial, I ...

Sometimes, you might accidentally delete the worksheet or even the whole workbook you are working on. This could be a disaster if you are working with ...

While working on a project in Excel that has a deadline to meet, you might want to find out how many days from today are left until the deadline. You might ...

Oftentimes while working with categorical information in Excel, you might need to color all the cells under a specific category in the same color to ...

If you are working with an Excel worksheet that you need to update and share with other people via email on a frequent basis, VBA macro in Excel can reduce the ...

While concatenating two or more pieces of text in Excel, you will find that the different number formats like currency, decimal format, and percentage format ...