• Authored Course

Microsoft SharePoint 2010 - Office Integration Level 1

Learn via: Classroom

Price: £525

Dates and Locations

About this Course

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.

Learn from the UK's leading Microsoft training provider

  • Comprehensive curriculum

    We deliver over 20,000 Microsoft training courses in the UK each year

  • Experienced experts

    Our first-class learning specialists all have a minimum of 5 years training experience

  • Superb satisfaction scores

    99% of our delegates are satisfied with their Microsoft course

  • Trusted training

    We are the largest Microsoft Gold Learning Partner in the UK

  • Microsoft Partner Gold Learning

Why people choose QA


There are over 20 QA learning centres and many other sites spread across the UK, providing a convenient choice of learning locations and ensuring that over 90% of the population is within 45 minutes of a training destination. Learn more

  • London


    International House

  • Manchester


    Oxford Street

Delegate portal

Booking courses with QA has always been easy, but now we've made it even easier. With myQA you can book, administer and manage all your bookings online, in one place. Login / sign-up

Detailed Information

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

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

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

Microsoft Certifications

Take the next step in your career by achieving certification in Microsoft Technologies.

Microsoft Azure
Microsoft Azure

Master Azure with QA, the 2015 Microsoft Worldwide Learning Partner of the Year.

Windows Server
Windows Server 2016

Learn to efficiently manage corporate IT infrastructures with Windows Server 2016.

MOC on Demand

Delivers Microsoft Official Curriculum (MOC) courses online straight to your device.