How to delete multiple rows in Excel

Excel is a powerful tool which can be used not only for performing calculations but it can be used to manipulate the data as well. In this tutorial we’ll learn […]

How to add months to a date in Excel

You can watch a video tutorial here. Excel allows you to add days to a certain date in a very simple way. Let’s take an example data set, shown below, and […]

How to calculate range in Excel

The range of the data means the difference of minimum and maximum values of that particular data. Although it is a very easy calculation and can be performed very easily […]

How to link cells in Excel

Microsoft Excel is a very handy computational software tool which has many versatile functions for data handling and performing calculations as well. While handling the big datasets, knowing the methods […]

How to remove dashes in Excel

Sometime while working with numeric data in Excel, we see that the data contains special formatting i.e. dashes and parentheses, because it is a phone number. There might be another […]

How to password protect an Excel File

Excel provides a built-in feature to protect the files through passwords. When an excel file is locked with a password, it can’t be opened without providing the right password. In […]

How to expand all columns in excel

Excel provides a vast variety of formulas, functions and tools to perform simple to complex mathematical calculations. In some cases, when we have large data in different columns, Excel uses […]

How to select non adjacent cells in Excel

In this tutorial we’ll learn the process to select multiple cells in Excel by following these simple steps.

How to add a total row in Excel

In this tutorial we’ll learn using one such tool to add a special row called Total Row. This term is particularly related to Excel Tables in which we can very […]

How to sort a column in Excel

How to get the SUM of a column in Excel

Excel offers incredible features to ease mathematical calculations by using built-in formulas. One of those features is SUM, which enables us to calculate the sum of many numbers and simplify […]

How to insert page break in Excel

In this tutorial, we’ll learn how to manually insert page breaks in Excel manually by choosing the number of rows to be printed on one page ourselves. The current dataset has […]

How to find the number of Wednesdays in a year in Excel

So in this tutorial we’ll learn how to find the number of times a particular day i.e. Wednesday will occur between two dates by following the steps mentioned below. As […]

How to colour code in Excel

Excel is a very useful tool for analysing data and performing various calculations with the data. It has some very powerful functions and tools to visualise data as well. One […]

How to reference another sheet in Excel

Microsoft Excel is a world’s powerful mathematical calculations tool. It can manipulate data in millions of different ways. Most of the time we need to add data from different sheets […]