The Excel spreadsheet has one really perplexing improvement: It now displays more than one million rows and 16,000 columns per work sheet. I'm a very infrequent user of Excel, but something tells me I'm not going to like the kind of guy who needs all 16 million cells.
On the other hand, I think I would like the guy who knows how to use Excel's PivotTable feature, which was an interesting and powerful tool, but is has been something of a mystery to use; it's no clearer in Excel 2007, sadly. Microsoft is proud of the ease with which you can find Excel's tools, and it may be right about that, but what do you do with something like PivotTable once you've found it?
Excel 2007 now allows conditional formatting to colour the backgrounds of cells based on their value, and inserts a coloured bar in the cell with a length proportional to the value of the cell.
It can also publish the results as HTML so it can be viewed as a Web page.
