Hosne Ara

While working in Microsoft Excel, sometimes we require a random 5 digit number generator. Especially while doing statistical analysis we might need to generate ...

In this article, I will discuss how you can move filtered cells in Microsoft Excel. When we want to copy filtered cells to move to another location, ...

In this article, I will discuss how you can use an Excel formula to insert rows between data. Often working with Microsoft Excel, we need to insert single or ...

In this article, I will discuss how you can get the sum of cells in Excel columns by color. Often, while working with Microsoft Excel, we use different fill ...

In this article, I will discuss how you can sort data by value in Microsoft Excel. While working with a large amount of data in Excel, often we need to ...

In this article, I will discuss how you can make grid lines bold in Excel. By default, Microsoft Excel uses black thin lines as gridlines. However, for a ...

In this article, I will discuss how you can filter multiple columns by color in Microsoft Excel. Usually, when we filter a certain column, other columns ...

In this article, I will discuss how you can find duplicates in Excel and copy them to another sheet. While working with a large number of data in Microsoft ...

In this article, I will discuss how you can extract data from an image into an Excel worksheet. This data extraction from images is very effective and saves a ...

While working in Microsoft Excel, you may need to trim part of a text string. For example, you might require removing a certain part of a text string. Besides ...

While working with Microsoft Excel, often we need to make a comparison table. Most of the time, Excel tables contain a lot of random data which might not make ...

Sometimes, while working in Excel, we need to split comma-separated continuous values of one column into different columns or rows. When we import data ...

In this tutorial, I will show you how you can link multiple cells from another worksheet in Microsoft Excel. Linking cells between worksheets has a great ...

In this article, I will discuss how you can calculate the principal and interest for a mortgage using a formula in Microsoft Excel. Suppose a $90,000 home at ...

In this article, I will discuss how you can merge multiple Excel cells without losing data. While working in Microsoft Excel, you may want to join several for ...