Using SUMPRODUCT formula with OR operator which is something I was not aware of before: By coincidence I found a link to Excelhero’s blog which gives a really nice overview on some common use cases of the formula.
Continue Reading →Do you know these situations when you made some kind of a form in Excel, password protected the workbook, sheets and/or even VBA access…and months later people ask for password in order to modify it? This is were trouble starts – how should I know what password I used months ago and, of [...]
Continue Reading →Since we had this topic for several times within our team and people kept making fun of me because I like it nice & shiny…even in my spreadsheets…herewith a short explanation on how to customize the color palette in Excel 2003 and re-use adapted palette in other workbooks.
Continue Reading →Just a snippet to remember how to change default template in Excel 2003 – not much more, not much less…
Continue Reading →