Want to own the videos below and view them offline? Check out the SharePoint 2007 End User and Site Admin Training DVD.

Table of Contents

Introduction and Overview

• What is SharePoint?

  An overview of SharePoint Products and Technologies. Why would you want to use it...

• What's new in Windows SharePoint Services v3

  An overview of what is new in Windows SharePoint Services v3 as compared to v2

• What's new in Microsoft Office SharePoint Server 2007

  An overview of what is new in Microsoft Office SharePoint Server 2007 as opposed to the older version SharePoint Portal Server 2003

Installation

• SharePoint Architecture Planning

  This video presents and talks through the architecture, pre-requisites and preparation required to plan for a WSS 3.0 or MOSS 2007 installation. It shows the supporting services required for the installation and also how to plan for the OS, IIS, and other requirements that serve as the necessity for planning a successful SharePoint deployment.

• Installing SharePoint

  This video demonstrates the process of installing WSS 3.0 and MOSS 2007 as a single server install. Then it shows how to setup some of the global settings that need to be immediately configured after the install. The video also examines how to assign server roles in a SharePoint server farm.

• Initial Configuration of a new SharePoint Installation

  This video shows the process of setting up initial configuration settings that need to be made on a new SharePoint installation. Administration tasks such as setting up services across multiple servers is also shown. Incoming and outgoing mail settings are demonstrated. Also, the installation of pdf ifilter is demonstrated so that pdf files can be indexed and searched by SharePoint.

Creating the SharePoint Site Structure

• Creating a SharePoint Site

  SharePoint comes with multiple site templates. This video shows how to create a SharePoint site using those templates

• Customizing Current Navigation in WSS

  Learn how to customize the Quick Launch navigation in Windows SharePoint Services

• Customizing Current Navigation in MOSS

  Learn how to customize the Quick Launch navigation in Microsoft Office SharePoint Server

• Listing SharePoint Sites in the Site Directory

  SharePoint Server comes with a Site Directory site template. This can be used to aggregate your sites and to give your users an easy way to navigate to the sites they are looking for. This video shows how you can manage the categories in the site directory and also how you can tag sites with categories.

• Manipulating a Site Collection Hierarchy

  If you are a Designer or a Site Administrator, you can manipulate a site collection's hierarchy (MOSS only feature). Using the Manage Content and Structure link in settings of the site, you can take many actions on a site including copying or moving it. This video shows how to perform the copy operation and more with the available Manage Content and Structure facility.

• Introducing Meeting Workspaces

  Meeting workspaces are similar to sites in SharePoint, but provide additional functionality such as a strong tie-in to Outlook and the ability to create and link meetings to SharePoint events list. Learn about these things and more by watching this video

• Creating and using Blog Sites in SharePoint

  Creating a Blogging site in SharePoint is now possible. Use this type of site to host internal or external blogs

• Use Wikis in SharePoint to Whiteboard your Thoughts

  Create a knowledge base using the Wiki capability in SharePoint

Configuring SharePoint Security and Roles

• Security Overview

  There are various levels of security that can be implemented in a SharePoint deployment. Content can be secured at the site, list, library, folder or at the item level.

• Adding Users to a Site

  Security in SharePoint is a necessity. Learn how to add users to SharePoint sites

• Item level Security

  Granular security at the Item level is new in SharePoint 2007. Learn how to secure items or folders within lists and libraries in SharePoint

Working with SharePoint Libraries

• Introducing Document Management

  Document Management is a robust feature in SharePoint. Learn the various capabilities that are offered out of the box by the document mangement features.

• Understanding and using Content Types

  Content Types are used to store multiple template types and associated meta data. Learn how to use Content Types by watching this video

• Control Content Approval and Publishing on a Library with Approval Workflow

  Learn how to route a document through the Approval Workflow process. Configure the workflow so that once it is completed successfully, the Content Approval column is automatically marked as Approved.

• Check In Multiple Documents at once

  The process to check in multiple documents at once in a document library - MOSS only feature

• Using a Picture Library and Image Web Part together

  Host your images in a Picture Library and show them using the Image web part

• Using a Slide Library in SharePoint

  Slide Library is a special type of a library that's been built to contain individual PowerPoint slides. You can use it to share PowerPoint slides with your team members. You can even assign Individual slide ownership to a team member and then retrieve the final slide deck at any time.

• Adding Metadata & Views to Document Libraries in WSS

  Metadata is used to classify data in lists and libraries in SharePoint. This video shows how you can use metadata to your advantage to easily categorize SharePoint list content. It also shows how you can work with List views to hide or show content to the end users.

• Show Documents in a Document Library using the Preview Pane view

  SharePoint Lists can be manipulated to be viewed in a variety of ways. One of the viewing options is to show the preview pane in a list or library so when you hover over the item, you can see the document metadata. This video shows how you can implement that functionality in a document library.

• Email enabling Lists and Libraries

  Email enable SharePoint Lists and Libraries so users can send an email directly to it. This is a great functionality for users to be able to contribute directly from their inboxes.

• Show links to Documents at other locations in your Document Library

  Document Libraries can be configured to hold links to Documents at another location alongside the actual Documents in the document library. You might want to use this technique if the document file is too big or you just want to provide the front end to access the file through the library for your users. This video demonstrates how to use a new content type to configure external links.

Working with SharePoint Lists

• Creating Lists in Sites

  Lists are used in SharePoint to manage and present like data. Learn how to create various lists in SharePoint sites

• Create Custom Lists

  Create Custom Lists in SharePoint if you want to create a list from scratch. Define your own custom columns and the type of data that you wish to store in each column

• Adding Columns and Data to a Custom List

  Learn how to create columns and add data to the custom list

• Copying Lists between sites

  Copying/Moving/Backing up lists. With or without data

• Subscribing to List or Library RSS feeds

  RSS (Real Simple Syndication) is very prevalant throughout SharePoint. Learn how to use RSS in SharePoint lists and libraries

• Understanding and using Site Columns

  Use Site Columns in SharePoint to create list column templates

• Enhanced Survey Functionality

  Implement Surveys within any SharePoint. You will also see how to use branching logic within the surveys

• Mobile enable Lists and Libraries

  SharePoint sites, lists and libraries can also be viewed through a mobile device. The mobile enabled functionality is demonstrated in this video.

• Sync SharePoint Lists with Excel - using Free Add-On from Microsoft

  With the release of SharePoint 2007, the two way sync functionality between Excel and SharePoint lists was taken away. Now, with an Add-On developed by Microsoft, you can once again synchronize SharePoint lists with Excel spreadsheets. This video shows you exactly how to obtain the add-on, install it and then use it in your environment.

• Move an Access 2007 Table to a SharePoint List

  Access 2007 is a very robust client application. However, at times it is better to move your data from Access to SharePoint so anyone can browse to it easily using just a web browser. This video shows how you can make that happen by transferring an Access 2007 table directly as a SharePoint List.

• Sync SharePoint Lists and Libraries with Outlook

  Microsoft Office Outlook is the application of choice for many people to manage their mail, contacts, tasks, calendars and more. You can connect your SharePoint lists and libraries with Outlook and work directly from that environment. All of your data is synced back into SharePoint as you make changes to it in Outlook (and vice versa). You can also use Outlook to take your documents offline, and synchronize them back as needed.

Managing SharePoint Content, Workflows and Web Parts

• Using Audience Targeting

  Audience Targeting is used in SharePoint to target specific content to users. Keep in mind that setting up security for content is still required to protect content. The audience targeting feature can be used to hide or show content as needed to specific users or groups of users.

• Setting up Alert Notifications

  Alerts can be setup on SharePoint lists, libraries or individual items to send out email notifications (ex: a new document is created, uploaded, modified etc). This video shows how alerts are setup. In addition, it shows how you can subscribe others to alerts as well.

• Using the Content Editor Web Part to render text as well as script

  Content Editor Web Part (CEWP) is an extremely powerful web part to render rich text or embed script onto a page. Embedding javascript, vbscript or even styles for a web page is a snap using the CEWP. Watch this video to see examples of how you can use this web part in your environment.

• Exploring built-in MOSS Workflows

  Microsoft Office SharePoint Server comes with many pre-built workflows out of the box. Learn how you can utilize those workflows and create additional ones directly from the browser

• Summary Links web part

  Summary Link Web Part ships only with MOSS and not available with WSS. When the built in Links list is not enough, look to the Summary Links web part to provide linked resources to your users. It provides a way to associate Pictures and Group links together. Also, a trivial but much needed functionality it provides is a way to open links in a new window.

• Using the Recycle Bin

  The first layer of protection for you list and library items in a site is the built in recycle bin. Watch this video to learn how the two tier recycle bin works in SharePoint.

• Adding Web Parts to a Site

  Web Parts are essential to providing componentized functionality in SharePoint. Watch this video to learn how to add web parts to a SharePoint site

• Closing versus Deleting web parts

  Watch this video to find out the difference between closing a web part and deleting it.

• Target Web Part to an Audience

  Learn how to target web parts in SharePoint Server (MOSS) to a particular audience. Audience can be a SharePoint Group, Active Directory Group or a Global Audience defined within SharePoint.

• Using the Disposition Approval Workflow

  This Video demos the Expiration Policy feature of the Records Management functionality in SharePoint Server 2007. In particular, the Disposition Approval Workflow is implemented as part of the Information Management Policy to properly dispose of the document once its specified retention period has been reached.

• Publish Web Parts to the Web Part Gallery

  Web Parts can be uploaded to the Web Part Gallery to make them available throughout the site collection. This screencast shows how you can take a Web Part file and publish it to the Web Part Gallery.

• Use Content Query and Site Aggregator web parts to roll up your data

  This video will show how a couple of web parts (Content Query Web Part and Site Aggregator Web Part) are used to roll up data from various SharePoint sites to display on one site

• Create a Master Detail relationship using web part connections

  Regular out of the box web parts can be used to create Parent and Child, Master and Detail relationships. This video shows how you can create these relationships by just using the browser and web part connections.

Administering your SharePoint Environment

• Exploring SharePoint's Central Administration

  Central Administration in SharePoint is where all the magic happens. Setting Farm Level or Server level settings for SharePoint is all done here. The creation of Web Applications and Site Collections also happens through here and a whole lot more. This video explores the various functionality that is accessible to the SharePoint Admin through the Central Administration site

• Introducing Search Center

  Use the Search Center capability to search Enterprise data in your environment

• Importing Profiles from Active Directory into SharePoint

  Import user profiles from your Active Directory directly into SharePoint. This allows for audience targeting features and people search

• Backing up Sites with STSADM utility

  The STSADM utility is a very powerful friend of a SharePoint admin. Watch this video to learn how you can use this utility to back up SharePoint sites

• Site Delete Capture - Recycle Bin for deleted sites

  SharePoint out of the box does not contain the functionality to archive deleted sites. Use the Site Delete Capture feature made by available by Microsoft IT team on CodePlex to implement the site delete capture functionality. This video walks you through obtaining this component, installing it and how to use it.

• Configure Single Sign On

  Single Sign On, or simply referred to many times as SSO, is a SharePoint Server feature that provides storage of credentials such as your username and password to your back end enterprise applications. Credentials are encrypted and stored within the SSO database in SharePoint and can be passed on your behalf to your backend Enterprise Applications. This video shows how to configure SSO and then use it with SharePoint Designer Data Views.

Advanced SharePoint Topics

• Understanding and using the Features concept

  The Features feature in SharePoint allows the site administrator to add/take away functionailty to the site

• Get to know My Sites

  The My Site feature in SharePoint helps to greatly enhance the user experience by providing them with a Personal site that they can use to share documents, links, pictures, their profile information and more. This video explores the My Sites capability in SharePoint

• Understanding Master Pages

  Master Pages are used to create a consistent layout of pages on a SharePoint site. Watch this video to better understand how they are used and where they are stored on a site

• Intelligent Dashboards made Simple

  This video shows how you can publish spreadsheets using Excel Services which comes as part of Microsoft Office SharePoint Server - Enterprise. Then a Dashboard is created using the figures in the published Excel Spreadsheet and filter web parts are implemented to filter information on the Dashboard page.

• Create a Custom Search site

  Use the web parts that come with MOSS to create custom search and result pages to customize and enhance the search experience for the end user

• Setting up the Business Data Catalog with Application File Definition

  This video shows how to setup entities in your Business Data Catolog to show your Line of Business data. An application definition file is first uploaded through Central Administration to create the entities. Then the information from your backend LOB application is displayed securely on a SharePoint page.

• Publishing Sites vs. Team Sites

  Publishing sites are usually used to publish content on a large Intranet or an Internet site. There are plenty of consumers for this type of site and only a few contributors. On the other hand, a Team site has many contributors who collaborate effectively with each other on documents, announcements, and other artificats. This video shows the differences between the two types of sites.

• Publishing Pages with Workflow in Publishing Sites

  Publishing pages are modified by a few and read by many. They are used in publishing sites that are usually internet sites. It is a good practice to put a publishing page through a workflow before it is published to be consumed by everyone. In this video, you will see how this process works.

Additional Content

Webinars

• Webinar - Smart Storage for SharePoint

  Webinar originally conducted on 9/18 /2009. Presenter: Wendy Henry (Author of Storage Considerations for Microsoft SharePoint) Host: Asif Rehmani Today's business users demand better, faster collaboration networks and Microsoft SharePoint is poised to fit their needs. But many SharePoint implementations disappoint over time due to inefficient storage and insufficient data availability. Don't let this happen! This webinar shows you the secrets of choosing and growing an appropriate storage platform for your SharePoint environment to gain the most return on your investment. We examine SharePoint's unique storage requirements and discuss how to scale your disk hardware to reduce contention, throttle bandwidth usage, improve data availability and establish redundant data for archiving or disaster recovery.

• Webinar - SharePoint Designer Data Views

  Webinar originally conducted on 10/1/2009. Presenter: Asif Rehmani SharePoint Designer 2007 can be used to integrate data from a variety of sources into a single integrated solution. This session demonstrates how the Data View web part in SharePoint Designer can be used for the task of retrieving data from SharePoint Lists. Also shown is how data in multiple lists can be connected to produce a unified view of related information. That's not all, also demonstrated is how you can make this view editable to commit any data changes back to the data source… All without a single line of code!