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 …
Got a truckload of data? There is something which you might use to put them in an orderly & structured manner – MS Excel. A file created using the MS Excel application is called a workbook & it is so massive both by its length and also by its sides. What is more interesting is …
We in QuickExcel have covered how to calculate the days using the difference between the dates in this article. If you have not been there yet, now would be a good time. This article would also be dedicated to the operations that can be carried out in MS Excel using dates, but this time it’s …
Data is not always about numbers with comma separators. Sometimes, it could be a text describing something or sometimes, it could be a day or a month or a year indicating the occurrence of a certain activity. It is common sense that numbers can be subjected to all sorts of arithmetic, but what about dates? …
Lots & lots of data! A single glance at these would be breathtaking, let alone our ability to count these entities. So, what helps us here is the most rudimentary technique of them all; the oldest trick in the book, in fact, this might even predate the origins of that book – the SERIAL NUMBER. …
How many decimal places does this number have? Do its decimals really end? If yes, what would be the very last digit of it? The above questions still remain an enigma in the field of science, especially in that of its Queen – Mathematics & the number in question is pi denoted by the Greek …
The data which we get won’t always be in the way we desire them to be. At times, we would be needed to extract the wheat from the chaff. While separating the wheat from the chaff can be done using a colander, what shall be used to extract the desired data within a cell? Also, …
How to Separate Text in MS Excel – Split Text in Excel Read More »