Beat Excel! Get to next level in 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...

Interactive Chart Example-1

Did you know that you can make interactive charts in excel? It is pretty easy and once you learn how to, making interactive charts will...

Excel If Formula

Excel If function lets you make calculations or selections based on conditions. Excel if formula is likely one of the most used formulas in Excel. From...