Tagged: excel tutuorial

Multi Level Data Labels in Charts

When you have a big data set for a chart you naturally get too many data lables. But if your data can be grouped in...

Offset Function

When you want to select a cell (or range of cells), that is 2 rows down and 3 columns to the right from Cell B12,...

Interactive Chart Example – 3

  Here is another interactive chart example. This time I’ve made a chart that shows data as you click. Great for presentations.

Sumproduct Function

Sum product function lets you calculate sum of values with corresponding arrays. For example, if you have sales quantites and unit prices for a series...

Calling Macros to Action

You can call your macros by a couple of easy ways. In this post I’m going to explain how to call your macros to action.

Excel Macro Recorder

You don’t need to know how to code VBA in order to make macros that does basic tasks. There is a handy tool named Excel...