Sharepoint 2007 Advanced Customization without Programming

You'll be surprised how much you can do in SharePoint without writing code. This class is four intensive days of advanced customization of SharePoint sites. Learn how to brand and redesign web sites inside SharePoint, work with SharePoint Designer 2007, and even work with Workflow and Process Management, Business Intelligence and KPIs.

What do I need to know?

This course is not an introduction to SharePoint - you must know how to use and create sites in WSS and MOSS.

Our suggested prerequisite to this class is:
SP350 SharePoint 2007 Advanced Core Features

You also need to have basic web skills with XHTML and CSS.
Our WEB100 XHTML and CSS 1-day is always held the day before this class and will get you up to speed.

What will I learn?

Day 1  

• Creating and Customizing WSS Sites  
• WSS as a site provisioning engine
• Understanding Web Applications, Site Collections, Sites and Site Elements
• Activating a feature within a WSS site
• Site customization using WSS collaboration templates and Web Parts
• Managing security within a Site Collection with users and groups
• Lists, Document Libraries and Content Types  
• Customizing a list by modifying its properties and adding columns
• Configuring a document library with a custom document template
• Creating custom site columns and content types
• Configuring a document library to multiple content types
• Making customizations reusable with list templates and site templates
• Introduction to SharePoint Designer 2007  
• Customizing a site’s virtual file system
• Understanding site pages and the default Master Page
• Using WSS themes to modify the look-and-feel of a site
• Adding Web Part Zones to a site page
• Customizing pages using the DataView Web Part

 Day 2  

• Creating Corporate Portal Sites  
• Anatomy of a Corporate Portal Site
• Adding child sites and pages to a Corporate Portal Site
• The process for approving content
• Shared Services Provider (SSP) Architecture
• User Profiles, MySites and Audience Targeting  
• Importing and configuring User Profiles
• Extending user profiles using custom properties
• Creating and customizing MySites
• Updating a user profile through a MySite
• Content Personalization through Audience Targeting
• Configuring and Extending Search  
• Configuring content sources
• Working with search scopes, best bets and relevance
• Customizing Search Center sites
• Leveraging the Search Web Parts
• Customizing Search Results using XSLT

 Day 3  

• InfoPath 2007 and Forms Services  
• Working with the InfoPath 2007 forms designer
• Publishing an InfoPath form to a WSS Forms library
• Creating and publishing browser-enabled forms
• Accessing databases from InfoPath forms using trusted connections
• Working with administrator-uploaded forms
• Workflow and Process Management  
• Workflow Templates, Workflow Associations and Workflow Instances
• Managing the features that control workflow template activation
• Using the out-of-the-box workflows included with MOSS
• Leveraging the MOSS Approval workflow to automate business processes
• Creating custom workflows with the SharePoint Designer 2007
• Web Content Management using Publishing Portals  
• Creating sites from the Publishing Portal site template
• Managing content and customizing the navigation menus
• Branding a Publishing Portal site with a custom Master Page
• Creating custom Page Layouts with the SharePoint Designer
• Considerations for Internet-facing Publishing Portal sites

 Day 4  

• Leveraging the Business Data Catalog  
• BDC Architecture and Application Definitions Files
• Extending a BDC entity by adding custom actions
• Leveraging the out-of-the-box BDC Web Parts
• Customizing the Profile Page for a BDC entity
• Integrating BDC data with WSS lists and search
• Publishing Spreadsheets with Excel Services  
• Understanding Excel Services architecture
• Configuring Trusted File Locations
• Publishing Excel workbooks that render through the browser
• Publishing server-side Excel Workbooks which use data connections
• Creating a server-side Workbook containing pivot tables
• Creating Dashboards with Report Center  
• Understanding the Business Intelligence (BI) features of MOSS
• Creating dashboard sites with Report Center site template
• Integration with SQL Server 2005 Reporting Services
• Creating and displaying lists of Key Performance Indicators (KPIs)
• Drilling down on data using the MOSS Filtering Web Parts