Active Directory
- 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
Administration
- 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
- 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.
- Creating SharePoint 2010 site components
This video shows how to create components of a SharePoint 2010 site such as Lists, Libraries and Subsites.
- Managed Metadata and Term Store management
Managed metadata is a hierarchical collection of centrally managed terms. The terms are managed in the Term Store, in Central Administration. You can define, and then use these terms as attributes for items in your SharePoint farm. For example, you could create a list of vendors as a term set that can be centrally managed and the terms (each vendor) from this term set can be used as metadata (or columns) within lists or libraries. This scenario is demonstrated in this video.
- Creating a Web Application
After installing SharePoint 2010 and configuring the SharePoint farm, the first thing you need to do is create a web application. A SharePoint web application is an IIS web site that has been extended to run a SharePoint site. Creating a web application also creates an associated content database. This video shows the web application creation process.
- Setting up Site Collection Administrators
A site collection is administered by site collection administrators. You pick a primary and secondary site collection administrator when a site collection is first created. You can add more administrators afterwards if you like and this video shows you how to can do that. Keep in mind that site collection administrators can administer any site within the site collection even they have not been explicity given permissions to a site.
- Creating a Site Collection
A site collection is created under a web application. It comprises of one or more sites. Sites are the containers in which you place your content and secure your content with appropriate permission levels applied to SharePoint groups. This video shows how you create a site collection.
- Use Developer Dashboard to analyze SharePoint page performance
A feature in SharePoint 2010 called Developer Dashboard lets you analyze performance of your SharePoint pages. It is not only useful for developers, as the name suggests, but can also be used by IT professionals and site administrators to monitor how their site is performing and analyze for bottlenecks.
- Changing the default URL of Central Administration
By default, SharePoint Central Administration site uses the server name and a random port number (ex- http://spelserver:48583). However, you can change this address to be something more friendly by using the Alternate Access Mapping feature. Watch this video to see all the steps needed to make this change.
- Configure Central Administration with SSL
Secure Sockets Layer (SSL) is used to keep web or intranet transactions private using encryption. Applying a SSL certificate to a site provides the users with confidence in using that site knowing the transaction is secure. You can apply the SSL certificate on top of Central Administration as well to keep all transmission of confidential information secure when configuring SharePoint.
Alerts
- 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.
Audience Targeting
- 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.
- 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.
Backup and Restore
- Backup and Restore Sites using SharePoint Designer
This video shows how entire SharePoint Sites can be backed up from one location and then restored at another location using SharePoint Designer 2007.
- 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.
Blogs
- 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
Business Intelligence
- Use the Chart Web Part to visualize data from Excel spreadsheet
The Chart web part is shipped with SharePoint Server 2010 - Enterprise. It can be used to visualize your data with a variety of types of charts (bar graphs, pie charts, etc). This video shows how you can use this web part to visualize data in an excel spreadsheet through Excel Services.
- 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.
Business Connectivity Services
- External Lists
An External List is a way to surface external data as if it was stored in a traditional SharePoint list. In this video we show how to create External Lists from existing External Content Types using the browser and SharePoint Designer. We also look at how to customize views using SharePoint Designer.
- External Data Columns
External Data Columns allow you to use data from your external systems as metadata fields in SharePoint Lists and Libraries. This video shows how to create External Data Columns, how to customize the external data item picker dialog, and how to use your External Data Columns in Microsoft Office Word 2010.
- Introducing External Content Types
External Content Types are the backbone of all Business Connectivity Service solutions. In this video we explore the various components that make up an External Content Type and how they are represented inside of SharePoint Designer.
- Creating External Systems
External Systems are your data source for External Content Types. In this video we show how to create External Systems using SharePoint Designer using the three available data source types (.NET, SQL Server, and WCF Service) and how to switch the connected system for an External Content Type.
- Creating External Content Types
In this video we create two new External Content Types using SharePoint Designer. We show how operations are created and configured and how they relate to views in External Lists.
- Advanced Options for External Content Types
In this video we look at some advanced configuration options for External Content Types. We show how to use filter parameters in our Read List Operations and how to create Views for External Lists.
- BCS Associations
Associations allow you to define relationships between two External Content Types. In this video we show how to configure an Association using SharePoint Designer. We also look at how the relationship can be presented using the Business Data Related List Web Part.
- Business Data Web Parts
SharePoint Server Enterprise ships with a number of built in Web Parts that surface External Content Types. In this video we show how to add and configure several Business Data Web Parts.
- Creating BCS Actions
Actions in BCS allow you to create hyperlinks that are aware of the current Business Data Item you are working with. In this video we create several BCS Actions and use them to pass data into external websites to add additional value to External Content Types.
- BCS Profile Pages and Search
Profile Pages are dynamic pages that display default views for business data from external systems. These BCS Profile Pages can be indexed by SharePoint to provide support for searching external systems. In this video we show how to configure Profile Pages and how to configure SharePoint to search Business Data.
- BCS Administration & Security
In this video we look at some of the basic concepts administrators need to know when working with the BCS. We explore BCS related areas of Central Administration including the BCS Service Application and the Secure Store as well as how to export and import custom BCS solutions.
Content Types
- 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
Document Management
- 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.
- Convert Word Forms to InfoPath
This video shows how to convert Microsoft Office Word based forms to Microsoft Office InfoPath 2007 forms using built in converters in InfoPath
- Creating a Document Library
A document library is used to store any type of a document or an artifact in SharePoint. Once the document is stored in the library, you can take actions on it such as checking it out, versioning it, putting a workflow around it and a whole lot more. This video shows the creation process of a document library and also the additional options you have at the time of creation.
- Uploading Documents to Libraries
This video shows all different options of uploading files to libraries (any of the libraries available in SharePoint). The single document upload, multiple document upload and upload using the windows explorer are all shown here. Also discussed is the 'overwrite existing files' flag that you should be aware of.
- Versioning settings in Document Libraries
Document libraries provide the ability to have documents with both major and minor versions. A major version is usually a document that has been published while a minor version is still in draft state and being worked upon. The draft items can be set to be invisible to readers of the site. You will see in this video how to configure versioning settings and the best methods to utilize them.
- Check Out, Check In process in Document Libraries
When managing documents in document libraries, it is a best practice to utilize the Check out / Check in procedures for documents. This functionality is automatically available and turned on for All libraries in SharePoint. This video demonstrates how you can utilize this functionality properly to prevent losing valuable data. In addition, this video shows how you can require documents to be always checked out before being edited.
- Convert Excel Documents to InfoPath
This video shows how you can use out of the box conversion tools to convert Excel Workbooks to InfoPath forms
- 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
- Creating Document Sets
SharePoint 2010 introduced the concept of Document Sets. A document set is just what it sounds like - a set or package of documents defined as one entity. For example, a loan mortgage application packet could be considered a document set within which you would have individual documents such as personal information, existing properties you own, loan rate declaration etc. Each of these documents could be of any type, but together they make up the document set. This video shows the process of creating a new document set from scratch.
- Working with documents in Explorer View
The windows explorer view is a very easy and natural environment in which to work with your documents. This video shows how you can use the windows explorer environment for working with documents in SharePoint document libraries - easily copy/paste, drag and drop files, create folders and more.
- Send a copy of document to another library
All SharePoint document libraries provide the ability to send a copy of a document from one location to another. This can be done even across site collection boundaries. Once the document is sent, the link between the documents is still kept alive so if the source document changes, it can update the copy of the document.
- 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.
- Utilizing Site Columns
Site columns are reusable column definitions. They are template of columns which are defined at the site level as opposed to list columns which are created one at a time to be used in a list or library. Watch this video to learn why you would want to use site columns and how exactly to utilize them.
- Utilize Content Types to define and organize your content
Organizations create multiple types of content. For example, in any business, you have expense reports and status reports that need to be filled out by employees. In other organizations, you might have legal contracts, marketing proposals and more. You can get a handle on all this type of content and organize and manage it throughout your organization, utilizing content types in 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.
- Use Managed Metadata for navigating Documents
Managed metadata can be defined as your taxonomy at the site collection level. You can use this metadata to tag documents in a library. Then these tagged documents can be filtered using the metadata navigation settings at the library level.
- 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.
Features
- Understanding and using the Features concept
The Features feature in SharePoint allows the site administrator to add/take away functionailty to the site
Forms Server
- Publishing InfoPath forms to the Forms Server
Publish a form created using InfoPath 2007 to a Document Library in SharePoint server running InfoPath Forms Services.
- Publish an InfoPath Form to Forms Server and Digitally Sign it
Publish an InfoPath 2007 Form, with digital signatures capability already enabled on sections of the form, to Forms Server. Then Digitally Sign it using digital signatures issued by the Certificate Authority.

