1 of 15Image
Excel 2010's new slicers replace traditional pivot table filters, and make it easier for inexperienced users to work with complex data sets. They're certainly a lot clearer than the old filter drop-downs.
Straight out of Tufte, 'sparklines' are in-cell graphs that add a spot of visualisation to tables full of numbers, quickly showing trends. You can use line or bar charts to quickly enhance your spreadsheets — and as they're inside standard cells, you can paint them along rows and columns just like formulae and formatting.