‘To err is human!’ So, be it MS Excel or any other productivity tool, when the information is to be fed by us, then there is always a very big room for error. These errors at times can leave us scratching our heads puzzled and confused about what went wrong. Also read: How to Switch …
Even the simplest of the operations turns out to be exhaustive when it tends to be run for umpteen iterations. The same can be told for addition too. But worry not, for MS Excel has got other ways to get things done swiftly rather than sluggishly carrying them out like a handheld calculator. In this …
How to Add Data from Multiple Cells in MS Excel? Read More »
Rather than being a mere repository of numerical & textual data, MS Excel also serves as a vital tool to analyse those data with the aid of its in-built formulae. In this article, we shall look in detail at the sequence of steps that ought to be followed to create any formula in MS Excel. …
The functionality of MS Excel is not only limited to the usage of formulae to analyse & deduce meaningful inferences from a set of data but also extends to the usage of non-verbal interpretation techniques such as creating charts & graphs to provide the much-needed data visualisation. In this article, we would be looking into …
Let us say that there is a tabulated list of data with headers to categorise the entries under each column. But, there might be instances when we would be needing to replace the position of certain entries due to some errors during the recording of the information. This can be done by selecting the cells …
Some things are better left unsaid! This might be just true when it comes to the formulae used in MS Excel. When you create a spreadsheet that pulls in values from various cells within a sheet or across different sheets to compute the intended results through formulae and put it around for circulation so that …
And a bit of data here, a bit of data there! Here a data, there a data! Everywhere data, data…….! (Read with Old McDonald had a farm tune) Though MS Excel has been developed to handle data, it also flexes its muscles around making those in a more presentable manner. Having only data will make …
Merging 2 cells doesn’t pose much of a hassle. Select both cells and click on the Merge & Center button to get things done in a jiffy! But the same does not hold good for merging two columns. Adopting a similar approach could only leave all the selected cells merged together with only one entry …
While one can rejoice in creating eye-catching graphs or charts or tabulated data, the real nightmare starts when one tries to put the ink on the paper. Ever tried printing sheets from MS Excel? Those who did would have known that it does not seem to be child’s play. Unlike a document in MS Word …
Rather than sitting on its laurels, Microsoft has been constantly updating its Office Package with new features to make life easier for its users. As a part of this package, MS Excel also gets its own share of new features in every update & one such update is the ‘Dynamic Arrays’. Before this feature was …