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 […]

Check it out now

Excel’s AUTO FORMAT Option

how to use excel auto format option for quick formatting

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 […]

Check it out now

Pivot Table Tips & Tricks

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 […]

Check it out now

Concatenate a Range of Cells

2 concatenate a range of cells with fill justify

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 […]

Check it out now

Watch Window

Delete A Cell In Watch Window In Excel

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 […]

Check it out now
1 4 5 6 7 8 27