How to Link Cells in MS Excel?

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. …

How to Link Cells in MS Excel? Read More »

How to Lock Formula in Excel?

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 …

How to Lock Formula in Excel? Read More »

How to Count Duplicates in Excel?

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 …

How to Count Duplicates in Excel? Read More »

How to Use Formulas in MS Excel?

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 …

How to Use Formulas in MS Excel? Read More »