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.

Worth $20, Absolutely Free

Category Archives for VBA

Concatenate a Range of Cells

2 concatenate a range of cells with fill justify

CONCATENATE is a handy function to concatenate text from different cells. You need to refer to the cells which you want to combine. It’s simple and easy to apply.But here is a bad news. In concatenate, it’s not possible to refer to an entire range.You need to select all the cells of a range one […]

Check it out now

Count Unique Values in Excel

Let’s say you have a list of values where each value is entered more than once. And now, you want to count unique values from that list so that you can get the actual numbers of values which are there in the list. For this, you need to use a method which will count a […]

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

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

VBA IF Statement

a practical guide to learn about VBA IF Statement in excel

Conditions are everywhere, in our work, day to day life, in our conversation, everywhere. And when it comes to VBA coding, conditions are one of the most important things.If you want to be advanced VBA user then an IF statement is must learn. And, I believe that you are already familiar with word IF and […]

Check it out now