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

Fill Justify

fill justify to replace with merging option

Fill justify is a life saver option.The single core motive to use fill justify in excel is to merge the data from multiple cells into a single cell.And, if you  have any other idea to merge text into one cell, leave it. Fill justify is a better option.So today, in this post, you will learn […]

Check it out now

Unpivot Data With Power Query

Data in a tabular form is good to use as a report format because it’s easily understandable. But the problem occurs when you need to use it for further analysis.​In this kind of situation, you need to put some efforts and spend your precious time to make it re-usable. And to make it, re-usable the […]

Check it out now

Count Cells With Text

Last week one of my readers asked me for a simple formula which he can use to count cells with text.Actually, he was trying to figure out which is the best methods he can use.In Excel, we have different formulas which we can use to count all the cells where we have text values. But […]

Check it out now

IFERROR with VLOOKUP

While using VLOOKUP, whenever the value for which you are looking for is not there in the data you get #N/A error. In simple words, whenever VLOOKUP is not able to find the value it returns #N/A. For example, you have a list of employees name and you want to lookup for the name “John”. […]

Check it out now