Last week, I notified you of the Just Released! Visual How To’s for SharePoint 2007 on MSDN, this week I just wanted to give you another heads up. Microsoft has just posted the an additional set of 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:

• Creating and Exposing Managed Properties in the Advanced Search Page of SharePoint Server Enterprise Search
• Creating and Exposing Search Scopes in SharePoint Server 2007 Enterprise Search
• Creating Managed-Code UDFs for Excel Services
• Refining Business Data Catalog Search with Scopes

Visual How To’s: Seach Oriented

• Creating and Exposing Managed Properties in the Advanced Search Page of SharePoint Server Enterprise Search
  Learn how to customize the Advanced Search page’s property picker which can be populated with managed properties (custom metadata that is collected by the crawler). This article explains and illustrates how to expose managed properties to the user, and also explains how developers can programmatically create managed properties… [direct link to video]
  
• Creating and Exposing Search Scopes in SharePoint Server 2007 Enterprise Search
  Search scopes in SharePoint Server 2007 are used to narrow the search results returned to users executing a search query. Search scopes can be shared or locally defined. You can use different rules in the definition of a search scope, from simply scoping based on a content source to more complex scoping with conditions using custom metadata… [direct link to video]
  
• Refining Business Data Catalog Search with Scopes You can easily refine the results of these Business Data Catalog searches with scopes. When you define the scopes, you can use them to segregate your Business Data Catalog search results from the rest of your SharePoint Server 2007 search results. You can display this data in a separate Web Part on the Search Results, or in a separate landing page altogether. This ability to segregate yet display the data side-by-side allows the searcher to easily see what they have searched on…[direct link to video]

Visual How To’s: Excel Services

• Creating Managed-Code UDFs for Excel Services
  You can use UDFs to provide functionality that is not available with the native Excel function library and to build custom data feeds for legacy or unsupported data sources, and application-specific data flows. UDFs can be created to call custom mathematical functions, get data from unsupported data sources such as legacy databases, Microsoft Office Access, and Microsoft SQL Server into worksheets and to call Web services. [direct link to video]