Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

All posts by Puneet

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

➲ Continue Reading

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

➲ Continue Reading

5-Popular Ways to Concatenate a Range of Cells in Excel

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

➲ Continue Reading

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

➲ Continue Reading

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

➲ Continue Reading
1 7 8 9 10 11 27