Microsoft has just posted the first Office Visual How To Videos for SharePoint 2007 on MSDN. These new articles describe everything in full detail, explaining ste-by-step on how to achieve the desired result. All the code is available for your copying and pasting needs, plus new is the visual how to videos, as well as related links. Here is the list of Visual How To’s that have just been released:

• Filtering One Business Data Catalog List from Another by Using Associations in SharePoint Server 2007
• Creating Business Data Catalog Entities in SharePoint Server 2007
• Retrieving an Entire Workbook or a Snapshot of a Workbook in Excel Services

Visual How To’s Business Data Catalog

• Filtering One Business Data Catalog List from Another by Using Associations in SharePoint Server 2007 - the Business Data Catalog allows you to define multiple entities for a given line-of-business (LOB) system. Furthermore, within the metadata file, you can create associations that define a hierarchy within the entities. For example, if there are two entities defined, such as customers and orders, you can create an association to tie the customer entity directly to the order entity. This allows users within your Microsoft Office SharePoint Server 2007 portal to create master-child behavior. [direct link to video]
• Creating Business Data Catalog Entities in SharePoint Server 2007 - the Business Data Catalog is a Microsoft Office SharePoint Server 2007 feature that exposes and incorporates Line-of-Business (LOB) data into other baseline portal functionality, such as lists and enterprise search. To incorporate this data into your portal, you must build an XML file that identifies where the data is stored (either Microsoft SQL Server or a Web service) and what the data looks like (for example, what the data types and primary keys are). [direct link to video]

Visual How To’s Excel Services

• Retrieving an Entire Workbook or a Snapshot of a Workbook in Excel Services - if you want to save a copy of an up-to-date workbook, store it somewhere, send it to someone, and so on, you can retrieve an entire workbook or a snapshot using Excel Web Services. When a user or application requests a snapshot, Excel Services opens the Excel file on the server, refreshes data sources, and calculates all Excel formulas. Excel Services then generates and sends a snapshot back through the Web service API. [direct link to video]

I’m not able to currently view, as its blocked at work, but will definitely find time on the weekend. Thanks to Randall for being the first to post about this - Announcing the 1st Office Visual How to Videos for MOSS! 3 BDC and Excel Services Screencasts Posted on MSDN!

For additional screencasts check out Learn Office Screencasts.