Did you know that you can highlight a portion of an Excel formula, press F9 and it will show you the result of the calculation.
I find it really useful when dealing with lots of nested IFs and Indexs etc
Blog of IBM Cognos TM1, Cognos BI, Cognos Express, CDM and other related stuff.
