Using Sharepoint Designer one can create a custom data view that can get data from several sources such as web services, xml data, database queries, and Sharepoint Lists. The view populates the data in real time and hence can be made available to the user's as a web page. This article outlines the method of creating a data view from a SP List.

If you have a macro enabled worksheet and would like the user to have the option to refresh data as required, have a macro button in the worksheet to initiate refresh of the data.. This article is for Excel 2007. If you are interested for Excel 2003. click here

If you have a long list of items in a Sharepoint list, you may find it convenient to highlight the current row the cursor is on. While there are couple of ways of accomplishing this, this article explains the method of highlighting using Behaviors in Sharepoint Designer. Several tasks can be done using Behaviors, this article highlights one of them.