How to Count Words in Excel
There is one option that I always wish Excel should have and that counts the number of words from a cell. If you work in MS Word there is an
Formulas
How to Count Cells with Text in Excel
Last week one of my readers asked me for a simple formula which he can use to count cells with text. Actually, he was trying to figure out which is
How to Insert a Check Mark Symbol [Tickmark] in Excel
Last week while traveling I met a person who asked me a smart question. He was quietly working on his laptop and suddenly asked me this: “Hey, do you know
How to Quickly Generate Random Letters in Excel
Ever faced a situation where you need to generate random letters?Well, sometimes you do need to generate some random alphabets.Right?In Excel…You have functions like RAND and RANBETWEEN to generate random
How to use Wildcards with VLOOKUP in Excel
I’m sure you want to make VLOOKUP more powerful. Well, using wildcards with VLOOKUP can do this for you. It can help you to look up for a value using a partial
How to Quickly Calculate Ratio in Excel
A ratio is one of the common methods to compare two values with each other. And it can help you to compare variation between those two values. Even in our