Count Words in Excel [Cell + Range + Worksheet]

There is one option which I always wish Excel should have.That’s ==> Count Number of Words.If you work in Microsoft Word, there is an inbuilt option on the status bar which shows you how many words are there in the sheet.But, when it comes to Excel there is no such option to count words. You can […]

Add Vertical Line in a Chart

Sometimes while presenting data with an Excel chart we need to highlight a specific point to get user’s attention there.And, the best way for this is to add a vertical line to a chart.Yes, you heard it right.You can highlight a specific point on a chart with a vertical line. Just look at the below […]

Dynamic Drop Down List

A drop down list is a powerful tool.It can help you to make your data entry simple and quick. You can use a drop down list with your dashboards, charts or even with normal data.While using it, one thing always gave me nuts that you need to update its data source whenever you add a new […]

Group Dates in a Pivot Table

A pivot table is full of awesome features. It doesn’t matter how big your data is, there is no problem for pivot table to handle it.Creating a group of dates in a pivot table is one those features. With this, you can instantly create insightful and ready to present reports.When you work with a data […]

Insert a Timestamp in Excel

A few years back when I was working for a tech company I was one of those people who were Excel help point for all.And, that’s the real reason I’m fascinated to learn more.One day the lady who was working as a reception coordinator came to me and asked:“Puneet, I’m managing a list of tasks […]

1 3 4 5 6 7 28