Links stolen from – http://parkesy.wordpress.com/2008/01/31/learning-office-2007/ (hey it saves me having to type it!)
Office
Office 2007 Demo: Spice Up Your Text With SmartArt Graphics
2007 Office System Demo: Enable blocked macros
2007 Office System Demo: Apply Your Brand to Office Documents with Themes
Windows Vista and the 2007 Office System Demo: Better Together
Excel
Excel 2007 Demo: Analyze product sales with a PivotTable report
Excel 2007 Demo: Freeze or unfreeze rows and columns
Excel 2007 Demo: Hide or unhide rows and columns
Excel 2007 Demo: Data Takes Shape with Conditional Formatting
Excel 2007 Demo: Create Charts in Excel 2007
Word
Word 2007 Demo: Word 2007 — Work with Documents Created in Earlier Versions
Word 2007 Demo: Make Documents Look Great
Word 2007 Demo: Up to Speed with Word 2007
Word 2007 Demo (set of 2): Let Word manage your table of contents
Word 2007 Demo (set of 4): Create a set of labels with mail merge
Outlook
Outlook 2007 Demo: Create and use an e-mail signature
Outlook 2007 Demo: Customize your calendar
OneNote
OneNote 2007 Demo: What is OneNote?
OneNote 2007 Demo: Organize, Search, and Find Information in a OneNote Notebook
OneNote 2007 Demo: Keep It Together with OneNote 2007
InfoPath
InfoPath 2007 Demo: View the Business Logic in an InfoPath 2007 Form Template
InfoPath 2007 Demo: Create reusable template parts
Sharepoint
Windows SharePoint Services 3.0 Demo: Tour a Windows SharePoint Services 3.0 Site
Forms Server 2007 Demo: Deploy an Administrator-Approved Form Template
SharePoint Server 2007 Demo: Add a Library to a Records Center Site
Powerpoint
PowerPoint 2007 Demo: Up to Speed with PowerPoint 2007
PowerPoint 2007 Demo: Add animation and sound to text and objects
Project 2007 Demo: Add, hide, and show columns
Project
Publisher
Publisher 2007 Demo: Personalize Newsletters with E-Mail Merge
Visio
Visio 2007 Demo: Get a New Perspective on Data with PivotDiagrams