About this Course

Tech Type Specialist
Duration 1 Day

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.


  • 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)

Learning Outcomes

At the end of this course you will be able to:

  • 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

Course Outline

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
Specialist Course

1 Day

Microsoft SharePoint
Delivery Method

Delivery method


Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0113 220 7150 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.