Don’t compare apples with oranges! A common saying that we all would have come across at least once. When one tends to carry out a comparison, one ought to make sure that both the entities that are being compared are placed on a level playing field. The same logic also holds good when it comes …
The most underrated entity in any dataset would be the ‘Serial Number’. Imagine a life without S.No! It would be a nightmare, ain’t it? The ordering of the entries is tossed off into turmoil without this simple measure in place. All hell breaks loose if it weren’t for that S.No! One can easily type in …
Data can be handed over to us from any medium & so it is not necessary that all the entries available in the dataset are necessary for analysis. In some cases, there may be some erroneous entries that have come as a part of the bulk data. What if there are a set of rows …
Working with MS Excel, it is not always the case that one shall get data in the form of spreadsheets alone. There are other formats in which the source data might be provided such as the Comma Separated Values (CSV) or Text Delimited (TXT) format. Also read: How to Count Unique Values in MS Excel? …
Data is always not refined. This is the one thing that would always give migraines to those who work with tonnes of data. Getting down to those which really matter can be quite tedious & this article is going to suggest ways to tackle one such situation. In this article, we will explore the steps …
Everything we humans look into, we shall name. It’s near impossible for us to comprehend something without tagging a name to it. There has got to be a name for everything! It has been that way since time immemorial & it will be the same years into the future. How are we even going to …
Adding numbers is a straightforward operation but when it comes to adding time, it might be a bit tricky. When 40 minutes & 50 minutes are added, the result should be 1 hour and 30 minutes. One might argue, won’t we be better off with 90 minutes as a result? Well, we are more used …
Acts of mischief – that’s one word which comes into our mind when the spreadsheets we get have some ‘hidden’ agenda. Though it may be unintentional, it gets us into a grave problem when certain entries go hiding, especially when there is a formula involved. It makes us lose our precious time, leaving us scratching …
What are the chances you get a six when throwing a dice? What are the chances that there comes a tail when the coin lands after being tossed? What are the odds of anything happening? PROBABILITY! It gives the answer to everything while being a near prediction at that. In this article, we shall dive …
Calculating Probability with PROB function in MS Excel Read More »
At first glance, all the cells in a sheet of MS Excel may seem to be separated by the boundaries running top-down & across as shown in the below image. These lines are known as Gridlines, which serve as a reference for a user to locate the contents within any cell & differentiate it from …