Home » Microsoft Excel Guides » Page 59
Excel is an awesome and powerful tool for calculations and manipulating data. However, there are still some things that become very irritating and often require changes in the default settings […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
In this tutorial we’ll learn the process to select multiple cells in Excel by following these simple steps.
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 […]
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 […]
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 […]
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 […]
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 […]
