Tagged: tutorial excel

Interactive Chart Example – 2

This chart is a very cool looking chart with very nice spinning effect. There is no macro used for this interactive chart, only formulas and...

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.

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