There are a lot of interesting applications in the fantastic 40 (available in Templates). Also note that the SharePoint site is actually running on SharePoint Server, Microsoft Office SharePoint Server , and it does a good job of showing off some of the capabilites of SPS 2007.
As far as the authentication question goes, to keep users from being prompted for login when going to a SharePoint site, you need to add the site to either your Local Intranet or Trusted Sites zones in your Internet Explorer security settings. If you are using Internet Explorer 7 and add the site to the Trusted zone, then you also need to modify the authentication type for the zone itself. I'd recommend adding it to local intranet myself, but there are times that you'd want it in trusted.
By default Internet Explorer 7 is set to pass through authentication only for the Local intranet zone. So, to make the prompt go away in trusted zones you must modify the security settings for Trusted zones. Go to your Internet Options, on the security tab select the Trusted zone and then click the Custom level button. Scroll all the way to the bottom and change the setting for Logon to Automatic logon with current username and password.
Uploading Excel to a list is simple in Excel 2007:
- data--list--create list (follow the prompts)
- data--list--publish (follow the prompts)
- the URL is the URL of the site without default.aspx