Friday, May 6, 2011

2 excellent articles from Clearly & Simply

Charts in Excel Table TooltipsHow to display a Chart in the Tooltips on Microsoft Excel Tables visualizing the selected value within the context of the data distribution.

Tooltips on Microsoft Excel TablesHow to display Tooltips on Microsoft Excel Tables including additional information on the selected cell and aggregation results for the entire column.

Wednesday, May 4, 2011


When we have a database we could have some difficults to read the "row" and the "column". With a highlight will be easier... Just press "Alt"+"F11" and insert the code in the respective sheet:

A few formulas for "dates"

Usefull VLOOKUP formulas without "#N/A"

If you are using VLOOKUP function you know the result "#N/A". To avoid this result you can return "0" (zero) or " " (empty space):

Sunday, May 1, 2011

Excel how to videos on Youtube

Excel "how to" videos on Youtube are a great source of knowledge. You can learn several tips for help you on your daily work.

You can find videos about anything that you need and see step by step how is done.