SUMIF is one of the useful function in excel. This function returns the total sum of the specified range when the specified criteria is met by the specified range. SUMIF function ease our work if we are in search of the sum, based on the criteria. The syntax of the SUMIF function is as follow: = SUMIF(range, criteria,[sum_range]) The range is the range of cells which has to be evaluated … [Read more...]

Dealing with the large scale of data sometimes, it becomes very challenging for us to focus on some specific set of data or the data you are interested in. Well, Excel provides us with the facility to Filter data to narrow down the large scale of data which eases us to study the data of our interest. In this section, we will discuss the method of adding the filter to the data. Further, we will … [Read more...]

A pie chart is a circular chart which is a collection of multiple slices that joins together form a circular graph. In a pie chart, each slice represents an individual fragment of the whole pie chart and the complete pie chart represents 100% of the whole. Excel provides us with an easy way to create a pie chart. In this section, we will discuss the method of creating a pie chart, we will also … [Read more...]

We use Excel to save or accumulate information. Working with large Excel sheet, we may duplicate records or information and further, it becomes difficult for us to identify duplicates. Well, Excel provides a facility to highlight duplicates. Analyzing the highlighted duplicates, you can determine whether you have to keep that record or you have to delete it. In this section, we will discuss the … [Read more...]

Do want to track changes in excel? We often share our excel spreadsheet with other people to overview it or if required make some changes or updation to it. To know what changes have been made to your excel spreadsheet by others, you can turn on tracking. As soon as the tracking of an Excel sheet is turned on, it becomes the shared workbook to which multiple users can make changes and those … [Read more...]

In excel we don’t write text in sentences or paragraph. The main motive of using excel is to store data or information in tabular form so there is not much need for spell check in excel. Sometimes people even forget to check spellings in excel. The spell check in excel is not similar to spell check of MS Word. Excel never highlight the incorrect spelling by underlining it with the red wavy … [Read more...]

It easy to use a cell or the range of cells by a name instead of their references. In excel we can create named range which makes the working in excel easier. However, using the named range also saves our time and provide efficiency thereby avoiding mistakes which occur while typing the reference for the range of cells. In this section, we will discuss the steps to: Name a Single Cell … [Read more...]

Sometimes we share our excel sheet with others but we don’t want others to edit it. Or we want to prevent the sheet from getting edited mistakenly. Sometimes the Excel sheet may have formulas in some cells which when edited mistakenly may lead to the wrong result. Excel provides us with the facility to lock formulas or cells in the sheet. All the cells of an excel sheet 'by default' are … [Read more...]

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...]