Microsoft SharePoint Office Integration 2010 Level 1 - SPOI10L1

The goal of this course is to provide you with the knowledge and skills to combine SharePoint 2010 and Office 2010. You will use powerful features of Office applications such as Microsoft Word, Excel, Access, Outlook and more, to create an integrated set of tools providing you with powerful and yet simple solutions to business and team requirements. The course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.

You will discover how to work with SharePoint content offline using Outlook and SharePoint Workspace and synchronise changes back into your sites. You will see how to publish content into SharePoint for users to view without the required Office application being present on their PC. You will manage documents and SharePoint content without needing access to the browser, providing a faster more productive means to complete work.


During the course, delegates will cover the following:

Lesson 1: Office Document Control

  • Office 2010 Backstage
  • Manage your SharePoint Sites Lists
  • The Document Panel
  • Office Web Apps
  • Outlook Web Apps

Lesson 2: Content Editing

  • Library Properties in Documents
  • Check Out/In
  • Versioning
  • Document Barcodes
  • Blogging with Microsoft Word

Lesson 3: Data Management

  • Transport Data from Excel to SharePoint
  • Transport Data from SharePoint to Excel
  • Synchronising Excel Data with SharePoint

Lesson 4: Presentation Collaboration

  • Slide Libraries
  • Working with Pictures
  • Broadcast Presentations

Lesson 5: Co-Authoring

  • What is Co-Authoring?
  • Co-Authoring Interface
  • Co-Authoring in Microsoft Word
  • Co-Authoring in Microsoft PowerPoint
  • Co-Authoring in other Applications

Lesson 6: Working Offline

  • Managing Connections
  • Managing Content Offline
  • Managing Alerts in Outlook
  • SharePoint Calendar Invitations
  • Outlook 2010 Social Connector
  • Using SharePoint Workspace
  • SharePoint Workspace Environment
  • Working with Contacts
  • Pricing / Dates / Locations available on request

  • Please call us on 01285 711200
    Enquire below:

Course Information

This course requires delegates to meet the following prerequisites:

  • A good understanding of Windows
  • Experience using Internet Explorer 7/8 or equivalent browser
  • Experience with Microsoft SharePoint 2010 equivalent to our 'SharePoint 2010 End-User - Introduction' course
  • A good knowledge of the general Office 2010 applications is required (Word, Excel, Outlook and PowerPoint)
  • Open and save documents to SharePoint Libraries from the Office applications
  • Create, open and manage documents without using the browser
  • Blog using Microsoft Word
  • Integrate SharePoint content with Microsoft Excel
  • Use SharePoint to broadcast slide show presentations
  • Use live co-authoring to edit documents simultaneously with other users
  • Manage content offline using Microsoft Outlook and Microsoft Workspace
  • Add Web Parts pages to integrate and connect to Outlook account

Enquire about this course

Please leave this field blank: