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

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

Milestone Chart in Excel [Timeline]

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

1 4 5 6 7 8 28