We can add a vertical/average line to a bar chart in Excel by using the horizontal bar graph. The average line is used to analyse the data value in the graph but checking whether we have reached the average or not in the particular interval. Adding vertical average line to ... Read More

Displaying alternate row colours in a normal table is a very simple process which can be done using the conditional formatting concept but creating alternate row colour in pivot table is simple problem. A pivot table in Excel is an interactive table which helps in quickly summarizing the data. When ... Read More

As we all know that we can change the colour of alternate rows with different colours very easy in excel but have you ever wondered can alternate row colour based on the condition the condition can be anything. We will try to choose the colour for the row based on ... Read More

Let us assume we have a situation where we have collected names of people from two sources and you want to know the names of the people who have registered from the both sources and we want to make a list of then them so we can use this simple ... Read More

When we create a pivot table in excel where there is a list of items and you want to know their share in the list in percentage. Read through this tutorial to understand how you can create a new column where it shows the percentage of grand total or subtotal ... Read More

The AVERAGE function determines the average value of the numbers that are passed to it in the argument list. Excel first totals all of the numerical values, then divides that total by the number of numerical values to arrive at the average. The AVERAGE function accepts several arguments, up to ... Read More

There are several ways that an Excel user can delete rows if a cell contains a specific text, as explained in this article. At times, when you work with large data sets, you might find that you have to delete rows based on the values of the cells or based ... Read More

You are going to experience a great deal of frustration if there are hundreds of blank rows that need to be eliminated from the entire worksheet or workbook. In the following section of this article, you will find a listing of some efficient ways that will handle this job for ... Read More

The typical user of Microsoft Excel can benefit from the use of a dropdown list in order to simplify the data entry process. When entering data into a selected cell, using a drop-down to restrict entry options expedites the process and reduces the likelihood of making errors. Using the Data ... Read More

Excel has the capability to automatically include related data into a range, provided that there are no empty rows or columns inside the area that has been specified. It is ok to leave empty rows and columns between groups of related data. Excel will then examine the data area to ... Read More