Hosne Ara

In this tutorial, I will discuss how to highlight cells that contain text from a list in Excel. I will use Conditional Formatting to highlight cells. ...

In this tutorial, I will discuss how to group columns in the Excel Pivot Table. The ability to group data in subsets is one of the useful features in Pivot ...

Let's work with a dataset containing date-wise sales of some mobile phones to make a Pivot Table. Reason 1 - Excel Pivot Table Is Not Gathering Data ...

In this article, I will show you how to create a tally bill format in Excel from scratch. You can make bill format from Excel Template too. Small businesses ...

In this article, I will discuss how to find multiple values in Excel. Often, while working with spreadsheets, finding multiple values at once can be a great ...

In this tutorial, I will explain some methods to count the number of rows using Excel Formula.  Usually, we can get the row count by simply clicking the column ...

While working in Excel, often we need to calculate total hours. For example, you can estimate the total hours required for a certain project from a list of the ...

In this article, I will explain why the Advanced Filter feature is not working in certain situations in Excel. Basically, the Advanced Filter is the advanced ...

In this article, I will discuss the details of the data table in the Excel chart. Basically, in Excel, we show a data table in a chart so that we can analyze ...

Often there are situations in Excel when concatenate is not working. Usually, MS Excel has three ways to join cell values. For example, we can use both the ...

In this article, I will discuss how to calculate weighted average in Excel Pivot Table. Finding weighted average in Pivot Table is a bit complex. Usually, in ...

The PMT function is a Financial function in Excel. Interestingly, the name PMT stands for ‘payment’. We can use this function to get the periodic payment for a ...

Logarithm values are often used in various fields, including science, engineering, and finance. In Excel, we can use the LOG function to calculate logarithm ...

The GROWTH function is a built-in function of Microsoft Excel. Besides, we can use this function in financial statistics, regression analysis, and predicting ...

Excel MONTH function is an effective function to extract the month from a given date. This function returns the month as a number between 1 to 12. The MONTH ...