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

➲ Continue Reading

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

➲ Continue Reading

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

➲ Continue Reading

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

➲ Continue Reading

Calculate Age in Excel

Let’s say you are preparing a data where user’s age is one of the important things to capture.Now, the thing is.If you ask every user to enter his/her age, chances are they can give you an approx number.But here’s the kicker:If you ask them their date of birth then you can easily calculate their accurate […]

➲ Continue Reading