Count Words in Excel [Cell + Range + Worksheet]

count words in excel featured image

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

Check it out now

Add Vertical Line in a Chart

how to add a vertical line in excel chart featured image

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

Check it out now

Dynamic Drop Down List

quickly create a dynamic drop down list in excel featured image

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

Check it out now

Group Dates in a Pivot Table

group dates with in pivot table in excel

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

Check it out now

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

Check it out now
1 2 3 27