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.
Microsoft describes Office 2010's Backstage as the place where you do things with documents; it's also where you'll find Outlook's account configuration tools.
Outlook 2010's default view is the conversation — finally giving Outlook threaded email. It's not perfect, but it works. You can clean up conversations to delete redundant messages while keeping the entire message thread. You can even see messages that have been moved into different folders.
Pasting into documents is always a gamble. Is my content going to look the way I expect? Office 2010's paste preview shows you just how your document will look — and lets you try out all the paste options without all those Ctrl-Z, Ctrl-Y moments.
The new calendar schedule view gives you a slice across the working day for several calendars — and makes it easy to see who's free and when, if you're trying to schedule meetings for a team. Outlook 2010 uses this as the basis for its new Calendar Groups.
It may not look like much, but Outlook 2010's new taskbar icon takes advantage of Windows 7's enhanced taskbar — changing the icon to show when you've got new mail.
PowerPoint 2010 can now host web videos — just drop in the embed code from a site, and away you go. It's ideal for adding viral video snippets to a presentation, or showing what you've put on YouTube.
The image editing tools in PowerPoint 2010 almost make business graphics tools redundant. They're not Photoshop-standard, but they do get the job done — even with complex effects like removing the background from an image to blend it into a slide.
PowerPoint 2010's embedded video player means you can now add video effects without worrying about whether your player will load. One click and you can recolour, another adds reflections, while yet another adds a complex border.
You can now broadcast your presentations through the web. Just share a URL and start presenting, with no need for an expensive web meeting service. The underlying technology is the same one that will power the online Office applications — and it works in more than just Internet Explorer.
Not every font will look like this, but Publisher 2010's stylistic sets now mean that complex typographic effects are just a mouse click away.
The Office Backstage has different uses in different applications. In Publisher 2010 it's also where you'll find your template gallery — ready to get you started with your document design. There are also print preview tools, including tools for working with commercial printers.
Office 2010's new image editing tools work across the entire suite — although you'll get different features with different applications. Word 2010's implementation is one of the most complete, with a range of artistic effects that can quickly spice up even the most pedestrian of pictures.
What used to be a tool for exploring document outlines is now a key Word 2010 feature. You use the navigation pane to explore documents, seeing the structure and searching for content. You can also use it to quickly add new sections or rearrange an existing document structure.