VLOOKUP with Multiple Criteria

VLOOKUP is one of the most popular Excel Functions. But, it’s one of the most limited functions as well.Advanced Excel users know that there are so many things which we can’t do with VLOOKUP or they need to put some extra efforts to make it work.For example, using VLOOKUP with multiple criteria.By default, VLOOKUP allows […]

Excel’s AUTO FORMAT Option

Formatting is a tedious task. It’s really hard to format your data every time when you present it to someone.But, this is the only thing which makes your data more meaning full and easy to consume. It would be great if you have an option which you can use to format your data without spending […]

Top 31 Pivot Table Tips & Tricks for Advanced Excel Users

No doubt, Pivot Tables are the single most important tool which can help you to become an advanced Excel user.When it comes to data analysis, quick and effective reporting or presenting summarized data nothing can beat a Pivot Table.The best thing about pivot tables is they are powerful and flexible.​Even when you compare formulas and […]

How to Concatenate a Range of Cells in Excel [5 Methods]

CONCATENATE is a handy function to concatenate text from different cells. You need to refer to the cells which you want to combine.It’s simple and easy to apply.But here is a bad news.In concatenate, it’s not possible to refer to an entire range.You need to select all the cells of a range one by one. […]

Watch Window

Often there are some cells in our worksheet where we have important formulas. And, those formulas help us to calculate some crucial values.In this situation, it’s really important to take an eye on those cells, whether the calculation is correct or there is no error.But the point is, the more you have this kind of […]

1 8 9 10 11 12 28