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.

10000+ Copies Already Downloaded

All posts by Puneet

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

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

People Graph

ready to use people graph in excel

I have been always fascinated about info graphics and story based visuals. These kinds of things help me to tell a story with data.A pictograph is a great example of this. But apart from this, there is a chart in Excel about which most of us are not aware.That is called: People Graph. It was […]

Check it out now
1 2 3 26