Tagged: Formulas

Vlookup Function

Vlookup function is one of the most important functions in excel for me. It helps you fetch a value from a list of values looking...

Picture Link

Here is another useful feature of excel. Picture link or “Paste as linked picture”. Lets see how it is done and what are the benefits.

Named Ranges

Did you know that you can give a name to your ranges or cells in excel? And using these named ranges, while you can work...

Sumif Function

When you need to get sum of a list of vaules depending on one condition, sumif function is here to help.

Choose Function

When you need to pick a value from a list of values depending on an index number, choose function is the one you need.

Nested functions

While excel has a lot of built-in formulas ready for your use, sometimes they may not fully fit the task at hand. In this kind...