Tagged: tutorial for excel

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...

Enable Excel Developer Tab

Excel developer tab houses some very useful shortcuts. Macro buttons and form controls are just 2 examples of these. But unfortunately developer tab is not...

Combining Two Chart

For combining two chart into a single one in excel , you just need to know a couple of small tricks. Here is how it...