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

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

Useful Macro Codes Examples

useful macro codes

Macro codes can save you a ton of time. You can automate small as well as heavy tasks with VBA codes.And, do you know with the help of macros, you can break all the limitations of excel which you think excel has?So, today, I have listed some of the useful codes to help you become more productive […]

Check it out now

Consolidate Data From Multiple Worksheets In A Single Worksheet

consolidate data from multiple worksheets in a single worksheet featured images

In my starting days with Excel, I was really bad in capturing data. If you asked me to capture sales data for four different zones, I will create four different worksheets for that. Yes, I was really bad. But, you always learn with your mistakes. Am I right? And, if you are doing the same […]

Check it out now

How To Highlight Blank Cells With Conditional Formatting

how to highlight blank cells with conditional formatting featured image

It’s hard to recognize blank cells from a large data table. Because a blank cell is just a white cell without any value. In most of the cases, blank cells represent some sort of gap or missing data. It’s recommended to highlight these cells with a color so that we can recognize them. And, I found that […]

Check it out now
1 8 9 10 11 12 25