One of the few reasons I've held out on excel - pivot tables seem to be such a great way to use SQL like queries on spreadsheet data. Excellent!
On a more serious note, this does open up some interesting possibilities for Business Intelligence "in da cloud". Pivot tables coupled with data fed through Google Docs API can resolve quite a few basic reporting needs of my small business customers.