ASM Arman

While working in Excel, we might sometimes need to convert a column or a range to a comma separated list with single quotes around each of the cell values. In ...

If you are working with the time or date format in Excel and if you subtract a time value from another, then there is a possibility that you will come across a ...

Theoretically and even practically, you cannot find the percentage change for negative numbers. If not possible, then how can we calculate percentage change ...

While Credit Card is a widely used and convenient financial tool to borrow or lend money from the bank, oftentimes the interest on credit cards could be very ...

While working in Excel, you might need to calculate the average percentage change in a series of data. For example, you have an Excel worksheet with the sales ...

Sometimes in Excel, we have to work with the kind of data that might need to be ranked or ordered based on a specific set of criteria. For example, when you ...

Merge is an excellent and powerful tool in Excel that lets you merge or combine multiple across different columns or cells under the same column. The merge ...

Sometimes while working with Excel you might need to add blank space before and after the cell values. You might need to add the blank spaces to separate a ...

The sort button in Excel is a very powerful and useful feature that will let you sort the information in a large Excel worksheet without any hassle. Sort of ...

Filter in Excel is a great tool that you can use in a large worksheet to find out all the information that matches the criteria of the Filter very quickly and ...

Sometimes working with Excel, you will need to find out the unique values in a column or a range. For example, you might need to find out how many distinct or ...

The date grouping feature in Excel is a very powerful tool that will save you a lot of hassle. It helps you analyze the data in a large worksheet while ...

Operators specify the type of calculation that you want to perform on the elements of a formula. There are four different types of calculation operators in ...

While working with long text in Excel you might need to find out a specific character or string in it. You can use the Excel FIND function to find the position ...

Sometimes you need to change the width of columns or height of rows in Excel from default unit Inches to other standard universal units like centimeters or ...