All information recorded in MS Excel can be identified using the position of the row & column into which they were keyed in. The rows & columns are identified by the continuous numbers & alphabets respectively. But what if one feels a column is not positioned in its right place? Is there a way to …
Too many cooks spoil the broth! Similarly, it is never a wise decision to have all the different data interpretations in the same sheet. MS Excel provides the flexibility to store the desired data among the different sheets that it has to offer. Sounds great, right! But some may ask, ‘Now that we’ve taken the data …
It is not enough if one knows how to use formulae in MS Excel (For those who don’t, please do have a look at this article on How to Use Formulae in MS Excel). The formula constructed in one cell needs to be deployed across many other cells too. So, in this article, we shall …
Hundreds of thousands of entries recorded one below the other – a typical description of a massive spreadsheet constructed in MS Excel. Spreadsheets like these would take a lot of time to go through & one would be in dire need of something that could summarize the entries in a particular column. Let’s consider a …
One can’t be successful if one has got to do everything by oneself. Similarly, it would be an insurmountable task if one has to type in all that is needed to carry out a computation in MS Excel. So, in this article let’s explore the different ways to link the cells and their corresponding implications. …
We solve and deduce complex problems by analysing data using the formula in MS Excel, but these formulae are not foolproof and anyone with the privilege to access the sheet can fiddle with each & every formula to the extent that it becomes a web of spaghetti! It would really cost us precious time when …
Our mind goes for a bit of a wandering every now & then. What if it went for one when you were supposed to enter some data onto a spreadsheet, only to come back & realise that the entries have been swapped from their intended positions – as in, the columns have been entered as …
How dare they? Sneaking in whenever they want & waiting just for the moment where they can ruin everything – those stealthy duplicates. For reasons various, these guys could be found in any datasheets without any exceptions, unless there is some foolproof mechanism in place to prevent them from doing so. In this article, we …
So, you have got all the data recorded in a table categorized under different columns of your spreadsheet. You are very proud of yourself & bask in the glory of your achievement. What possibly can go wrong? – you might think. What if there are some blank rows in the middle to fiddle with your …
One can’t be at truce by knowing only the tricks that are needed to find one’s way around within MS Excel alone. Being the go-to spreadsheet of the era, at times, MS Excel would be needing to heed the requests of its fellow officemates (pun intended!). One such request shall arise from the requirement to …