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 Formulas

Count Words in Excel [Cell + Range + Worksheet]

count words in excel featured image

There is one option which I always wish Excel should have.That’s ==> Count Number of Words.If you work in Microsoft Word, there is an inbuilt option on the status bar which shows you how many words are there in the sheet.But, when it comes to Excel there is no such option to count words. You can […]

Check it out now

Calculate Age in Excel

How To Calculate Age From Date Of Birth In Excel

Let’s say you are preparing a data where user’s age is one of the important things to capture.Now, the thing is.If you ask every user to enter his/her age, chances are they can give you an approx number.But here’s the kicker:If you ask them their date of birth then you can easily calculate their accurate […]

Check it out now

Calculate Ratio

how to calculate ratio in excel

A ratio is one of the common methods to compare two values with each other. It can help you to compare variation between those two values. Even in our daily life, we use this word RATIO to define the comparison between two different things.When it comes to Excel, we don’t have any specific single function which can […]

Check it out now

Add Leading Zeros

how to add leading zeros in excel featured image

There are few default rules in Excel which can annoy you. And, one of those rules is you can’t add a zero before a number.The reason behind this is, a zero before a number makes no sense and no value to the number itself.Whenever you try to insert a zero before a number, Excel removes […]

Check it out now

VLOOKUP with Multiple Criteria

VLOOKUP is one of the most popular Excel Functions. But, it’s one of the most limited functions as well.Advanced Excel users know that there are so many things which we can’t do with VLOOKUP or they need to put some extra efforts to make it work.For example: using VLOOKUP with multiple criteria.By default, VLOOKUP allows […]

Check it out now
1 2 3 8