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

How To Create Barcode Generator Template In Excel

how to create a barcode template in excel featured image

Do you want to create a barcode in excel? So today, just for you, I will reveal the method to create barcode generator template in excel. In this post, I will show you how to generate code 39 barcodes. Code 39 is known as Code 3 of 9 which is the most used barcode and able to scan […]

Check it out now

How To Highlight Duplicate Values Using VBA

highlight duplicate values using vba

While working with huge data, Duplicate Values are always a concern. And, I am sure most of the time you remove them with remove duplicate option. But, removing duplicate values or just counting duplicate values never sort out the problem. The important thing is to review all the duplicate values before deletion. So, today I will […]

Check it out now

Add a Horizontal Line in a Chart

featured image to add horizontal line in excel chart

You can add a horizontal line in an Excel chart to use as a target line. All you need, 30 seconds to add a horizontal line to an excel chart. And, without much efforts. You know what, my company’s CEO told me these things a year back. It is better to have a comparison to […]

Check it out now

How To Add Leading Zeros In Excel

how to add leading zeros in excel featured image

You can’t add a zero before a number in excel. Whenever you try to add a leading zero, it disappears. Not matter what, how many zeros you trying to add, it will disappear. Let me tell you what’s the reason for this. In below example, I am trying to start a number with 0 but I […]

Check it out now

8 Examples for Using Formulas in Conditional Formatting

how to use formulas in conditional formatting featured image

The best part of conditional formatting is you can use formulas in it. It has a very simple sense to work with formulas. Your formula should be a logical formula and result should be in TRUE or FALSE. If that formula returns TRUE, conditional formatting will apply. And, if it returns FALSE, conditional formatting will not […]

Check it out now
1 7 8 9 10 11 25