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

Calculate Age in Excel

How To Calculate Age From Date Of Birth 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 […]

Check it out now

Generate Barcode In Excel

how to create a barcode template in excel featured image

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

Check it out now

Apply Strikethrough

A few days back, I wrote about different ways to add a check mark 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 tab […]

Check it out now

Add a Horizontal Line in a Chart

featured image to add horizontal line in excel 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 […]

Check it out now

Milestone Chart

how to create a milestone chart in excel

Tracking all the steps of a project is an important task. It’s as important as the execution of the each step. In fact, tracking makes execution easy.And, if you are searching for a perfect chart template in which you can track your project in the simplest way, Milestone Chart should be your first choice.The basic […]

Check it out now