Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.
Formatting is a tedious task. It’s really hard to format your data every time when you present it to someone. But, this is the only thing which makes your data more meaning full and easy to consume. It would be great if you have an option which you can use to format your data without spending […]Check it out now
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
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
An excel heat map template can help you present your data in with a strong message about the conclusion. It will also help you to add some extra power in your data.Check it out now
If you have a cell with some specific font style, having a specific background color & you want to copy that formatting to some another cell, you can use format painter to do so.Check it out now
Few, days back, I had explained about how to convert non-standard date formats to standard date formats in my post. But, Sometimes it is required that we use some off track date formats rather than using simple date formats. As we know, excel blessed us with highly flexible options & Custom Date Formats is one […]Check it out now
Cell Comment is like a Small Note in Excel which you can put on the cell to deliver an important message related to that particular cell. By using customized cell comment you can add a plus to your data presentation. Here, I have listed 4 useful tips to customize cell comment in excel which can help you […]Check it out now