How to Group Dates in a Pivot Table [Step by Step Guide]

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.One of my favorite feature of a pivot table is to group dates.With this, you can instantly create insightful and ready to present reports. When you work with a data […]

How to Insert a Timestamp in Excel [Formula + VBA + Shortcut]

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

Steps to Install Font to Generate Barcode In Excel

People who track stock, sales, and purchases in Excel often ask me “how can we generate a barcode in Excel?”.Well, in Excel there is no default option to generate a barcode.And, the bad news is:There is no plan of Microsoft to add any option like this.But here is the good news:You can generate a barcode […]

How to Apply Strikethrough in Excel [Shortcut + Command]

A few days back, I wrote about different ways to add a checkmark in Excel for completed tasks. But there also one more thing which we can use:That’s ➜ Strikethrough It means to draw a line through a value in a cell.In Microsoft Word, the option for striking through a text is there on the home […]

How to Add a Horizontal Line in a Chart

While creating a chart in Excel, you can use a horizontal line as a target line or an average line.It helps you to compare achievement with the target you want to meet or an average you need to maintain.Let’s say you have an average value which you want to maintain in your sales throughout the […]

1 4 5 6 7 8 28