Author: melih

Quick Excel Tip: Transpose

Did you know that you can easily switch rows and columns of a list of values in an instant by copy-paste using transpose option ?

Dynamic Chart Title

Are you updating your chart title manually all the time for certain changes in data. It is time that you set a dynamic chart title...

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.