Category: Formulas

Unit Conversion In Excel

Excel has a built-in unit converter. Not surprising isn’t it? Unit conversion is excel is done with CONVERT() Function. Here is how it works…

Fancy Characters

Do you know that you can use symbols from different fonts as fancy indicators? You just need to know which characters to use with which...

Index-Match Combination

We all love and use Vlookup Function very much. It is a great way to find and fetch values from big lists easily. But Vlookup...

Excel Tip: Excel Wildcard Characters

Are you looking for certain items that share last 3 characters? Are you not certain that the name you are searching for is Anna or...

Excel Date Functions

As we all know by now, there are several functions in excel for handling date values. But they don’t seem much useful at first sight....