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, the pivot table is 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 is, it is powerful and flexible. Even when you compare formulas and pivot table, […]

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

Excel Fill Justify to Merge Text from Multiple Cells to One Cell

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

1 9 10 11 12 13 28