Excel

We have come far in our series of Excel 101, exploring various functions and formulas of the service and how best to use them in real-world scenarios. For those who are new to this, make sure to check out the complete list of Excel functions that we have covered so far in the links shared […]

If you have ever looked at a professional spreadsheet, you must have noticed titles spanning across multiple columns. That is the most essential and widely used example of a popular Excel function called Merge. Continuing our Excel 101 series, we shall explore the Cell Merge function today. We shall understand what it allows us to

In our previous article of the Excel 101 series, we learnt all there is about conditional logic and operators in Excel. These operators help massively in functions like IF, AND, OR, etc. However, there is another family of functions that is used massively by Excel users and largely makes use of these operators to yield

You reading this tells me you wish to learn more about Excel. This article continues our Excel series, where we explored the VLOOKUP function in the last iteration. The complete VLOOKUP guide demonstrated how the function works and how best to use it. This time, we shall bring the same focus to conditional logic and

Try the following – ask any Excel user for his/ her favourite Excel formula. More often than not, you will hear just this one name -VLOOKUP. And this fame is for all the right reasons. From finance teams reconciling numbers to analysts cleaning messy datasets, this function quietly powers the most crucial operations in a