One feature of Excel 2007 that I think is really cool, and also a little hidden, is the “Offline OLAP” feature. If you insert a pivot table connected to an OLAP cube into Excel 2007, and go to the PivotTable Options Ribbon Menu, You will see the “OLAP Tools” Button. Click on that and then [...]