Category Archives: Blog

Simplifying your workbooks

One of the biggest mistakes people make when constructing large Excel workbooks is they build [...]

Efficiency in assigning macro variables at runtime

Often there is need to run some analysis for each distinct value in a dataset. [...]

Sharing the knowledge

A major problem for organisations is that analytics consultants conduct (relatively simple) analysis but don’t [...]

SPSS table trick

For scaled questions, the output of SPSS tables places the mean scores in a separate [...]

SumIfs Vs VLookups / Index-Match

Standard Excel look-up functions suffer from a problem in that they only match on a [...]

Quick trick to check whether columns are identical

Excel stores the value for True as 1 and a False as 0. So, if [...]