Got some very nice and useful video tips on Microsoft side on SharePoint Designer:
Creating Workplaces and Sharing Info on Long-Term Projects
Create sites where we share and store information.
How to Sync PowerPoint 2007 Presentations with SharePoint Server 2007
Shows how to add slides to a SharePoint Slide Library and get those files off of the library later.
Managing Documents in SharePoint Server 2007
Introduction to SharePoint Server 2007.
Versioning with SharePoint Server 2007
How to use versioning to revert documents back to file versions saved during previous work sessions.
Working Offline SharePoint Server 2007
How to create an offline copy in outlook to work on when not connected to the network.
Using SharePoint Server 2007 with OneNote 2007
Using Synchronized Notebooks so you can edit one set of notes on multiple computers.
Integrating SharePoint Server and the 2007 Office System
Use Excel Services to publish information out to Excel Web Access.