Archive for September, 2009

Very useful excel function: TÆL.HVIS (CountIf)

Saturday, September 19th, 2009

This is the function that is worth of knowing as soon as possible. This function was the solution for most of the queries for help arriving to me, as I said this is a very useful function, use as often you can! :) For the ones that are just now getting to ...

Absolute, relative and mixed cell-references in excel

Saturday, September 5th, 2009

One of the most important advances of the spreadsheet programs such as Excel and others, is the possibility to have references between the cells. With a cell-reference we can refer the content of other cells in the calculation / formula. In excel, often we do the same calculations in bulk (e.g.: for ...