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

Category Archives for Excel Tips

Excel’s AUTO FORMAT Option

how to use excel auto format option for quick formatting

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

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

Automatically Add Serial Numbers In Excel

how to automatically add serial numbers in excel featured image

Serial numbers are an important part of data. Even every small data table in excel should have serial numbers. But, adding them manually is a pain. So, today I’ll show you 6 quick methods to automatically add serial numbers in excel. You can use any of these methods which you think is perfect for you. 1. […]

Check it out now

How To Multiply In Excel Using Paste Special

how to multiply using paste special in excel featured image

Sometimes, you have to perform some quick calculations in excel. And, you can use paste special for these quick calculations instead of formulas. In this post, you will learn a quick tip for these calculations. I will show you how can you use paste special to quickly multiply in excel. Not only multiple but subtract, divided, and […]

Check it out now

Bullet Points In Excel

It’s easy to capture data in lists and to create an organized list you can use bullet points. I mostly use bulleted lists in Excel to capture my day to day work.And, just a few days back I have realized that you can use 7 different ways to insert bullet points in Excel.And, all these […]

Check it out now
1 2 3 5