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 …
Things don’t really happen, the way we want them to. The same holds true for MS Excel too where there can be an unprecedented turn out of events even with the slightest change. Additional spaces within the contents of the cell are a real pain! They find their way in when data is being downloaded …
Appearances are often deceptive! It is true in the case of MS Excel too where numbers would wear the disguise of text. The implications can be brutal since we would be looking around to find out why everything has gone haywire, especially when formulae are involved. So, in this article, we would be exploring the …
All the rows and columns in the spreadsheet not only contain data in form of text or numbers, but at times we would be needing to play around with colours to make them more appealing visually. So, that leaves us wondering whether we’d be able to perform some computations using these colours & the answer …
Spreadsheets are the medium to pile up tonnes of data. But for what use the data might be if we cannot interpret them to deduce some meaningful inferences? That’s where the most needed in-built function of MS Excel kicks in! – The FORMULA. In this article, we would be looking into the techniques on how …