Some excel madness. Somehow fascinating, no?

Ah hah! An excel data table. I used to have to do sensitivity analysis using these.

How do you find MS Excel?

I like the concept of it and the keyboard short cuts. It's the best thing for playing around with numbers and equations.

But the formulas are hopeless. For example if cell A1 contains the number "2", and cell B1 contains "=-A1^2", then B1 will show 4, not -4.

? It violates mathematics.

VLOOKUP sucks, as do 'array' functions such as SUM(IF(A1:A100=true, 1, 0)) {ctrl+shift+enter} since they don't work with non-array functions. For example SUM(IF(AND(A1:A100>0, A1:A100<1, 1, 0)) will not work. You have to do SUM(IF((A1:A100>0)*(A1:A100<1), 1, 0)) which is quite frustrating.

I also hate how there's 30 ways to paste a copied cell except there's no way to copy the textual contents (formula text) of a cell without manually highlighting the text within the cell.

Also, VBA sucks compared to Java. I still don't know how to use it, it appears to have no structure to its method names.