A graph helps us to visualize the data in a better way as we are able to recognize the hike and fall down events very easily. This helps the viewer to analyse the data and take further crucial steps. Excel provides us with an easy way to create a graph and it also provides the tools to upgrade the graph. In this section, we will discuss the steps to create a graph in Excel. We will also explore … [Read more...]

In excel when you click on any cell it’s content are displayed on the formula bar. Sometimes, we want that formula applied to a cell must not be visible in the formula bar for the sake of protection. Excel allows us to hide the formula applied to any cell and you can even make that no one is allowed even to click on the cell. That means you can restrict the permission to access the cell. To hide … [Read more...]

Whenever we create any data in an excel sheet and we want to provide it with a title which must be centred over the entire range of the data, we have to merge cells of that particular section. The Merge & Centre option of Excel merges all the cells of the selected range and only the text in the upper left-most box is preserved and is placed at the centre of the merged cells. In this … [Read more...]

Concatenate is a text function which is used to concatenate multiple cells in excel. The Concatenate function does not provide the delimiter. Like, it does not provide spacing between the texts that you want to concatenate. The Syntax of the Concatenate function is given below: =CONCATENATE(text1, [text2],......) In the above syntax, text1 is the first item to consider while … [Read more...]

The pivot table in Excel which allows you to arrange and summarize the complex data easily. You can create a pivot table within a few seconds without worrying about any formula. There are many advantages of using the pivot table as it fast and flexible. Below are the benefits of using the pivot table. Benefits of Pivot Table: A pivot table allows you to summarize and calculate the data … [Read more...]

Have you ever hide and unhide rows & columns in excel? In some excel sheets we store our everyday information like attendance of office staff, we create an everyday to-do list etc. Putting everyday data in an Excel sheet creates numerous rows and columns in the sheet. Too many columns and rows in the sheet makes it voluminous. Analysing such a voluminous spreadsheet become a headache. In … [Read more...]

Excel provides us with two formulas to generate random number those are, RAND() & RANDBETWEEN(). We can modify these functions to get random decimal numbers, random date, random time, random character. We can also calculate random text string to get a password. Well, there is a lot to do with this random function. In this section, we will discuss the steps to: RAND() Function … [Read more...]

In our earlier post, we have discussed the methods to create the drop-down list. In case, you need to edit dropdown list i.e. if you want to add more items to the drop-down list or you want to delete the items from the drop-down list you can do it with few pretty simple steps.  In this section, we will discuss the methods to edit the dropdown list. We will edit the dropdown list using the three … [Read more...]

It happens that many times we got stuck in an Excel workbook which contains duplicates cells. It is difficult to understand the data with duplicates. Well, we can delete duplicates in Excel. Let’s see how? In this section, we will first learn to identify the duplicates in Excel and then we will see how to delete the duplicates? We will also discuss the scenario when there are multiple rows … [Read more...]

Blank rows or cells in a table create a lot of confusion for excel built-in functions to identify the data in a correct manner. So, to clean the data in the table we must delete blank rows present in a table that creates a disturbance while analysing the data. Well, if you are working with a large table in Excel and you keep on adding or removing entries in a table, definitely there will be … [Read more...]