News

Azure For IT Professionals

Learn more about implementing Azure as part of your infrastructure.

Staying Sharp on Microsoft Office Can Save Time & Money

Learning the latest Microsoft Office tips and tricks can benefit you greatly.

"How do I determine if this new technology is for real?"

Michael Bird explains how to navigate new technology waters.

CONTACT US
Training partners

Spindustry Training

spindustrytraining.com - (515) 334-9556

Bookmark and Share

Using Microsoft Office 2013 with SharePoint 2013

Course Code: STTOSP2013
Length: 3 Days
Tuition: $1,325.00

Schedule for this Course

There are no dates scheduled for this course.
If you would like to be added to the wait list for this class Click Here

Course Description:

This course provides students with an overview of integrating MS Office 2013 files and features with SharePoint 2013.  Work with Microsoft Office documents, spreadsheets, databases and more, directly from your SharePoint site.  Share information easily using SharePoint Lists and Libraries.  It is designed as a hands-on, instructor-led training class.

At the end of this course, students will be able to appreciate and use the common features of Microsoft Office 2013 and SharePoint 2013, carrying out everyday tasks in an efficient and simple way, using SharePoint as a hub for all of their MS Office files.

Prerequisites

There are no pre-requisites for this class.  A basic understanding and some knowledge of Microsoft Office 2013 (Access, Excel, Outlook, PowerPoint, Word) is a bonus, but not essential.

Course Outline:

Introduction to MS Office 2013

  • Getting Started with MS Office 2013
  • MS Office Ribbon
  • MS Office Task Panes

Introduction to SharePoint 2013

  • Getting Started with SharePoint 2013
  • SharePoint 2013 Ribbon
  • What is a SharePoint List?
  • What is a SharePoint Library?
  • Using SharePoint Lists and Libraries

Using SharePoint 2013 with MS Access 2013

  • Save an Access Database to a SharePoint Library
  • Access Web Apps
  • Working with Access Services
  • Synchronizing a SharePoint list with Access

Using SharePoint 2013 with MS Excel 2013

  • Creating a SharePoint List from an Excel Spreadsheet
  • Creating an Excel Spreadsheet from a SharePoint List
  • Save an Excel Spreadsheet or Workbook to a SharePoint Library
  • Publish, Edit, and Remove an Excel Workbook to a SharePoint site
  • Exporting a SharePoint List to an Excel Spreadsheet
  • Using Excel Data Analysis tools within SharePoint (Sort, Filter, PivotReports)
  • Use Excel Reports with SharePoint
  • Using Business Intelligence
  • Excel Services in SharePoint Server
  • Building Dashboards with Excel in SharePoint

Using SharePoint 2013 with MS InfoPath 2013

  • Overview of InfoPath and SharePoint
    • What it is
    • What it does

Using SharePoint 2013 with MS Outlook 2013

  • Working with SharePoint Calendars in Outlook
  • Working with SharePoint Contacts in Outlook
  • Working with SharePoint Tasks in Outlook
  • Receiving items from SharePoint in Outlook
  • SharePoint Workflows and Outlook

Using SharePoint 2013 with MS PowerPoint 2013

  • Save a PowerPoint Presentation to a SharePoint Library
  • Collaborate on Presentations using SharePoint
  • Using Slide Libraries

Using SharePoint 2013 with MS Word 2013

  • Creating Word documents from a SharePoint Library
  • Save a Word Document to a SharePoint Library
  • Collaborate on Documents using SharePoint
  • Comparing document versions

Creating Library Templates In SharePoint 2013

  • Word 2013
  • Excel 2013
  • PowerPoint 2013

Collaboration / Co-authoring MS Office2013 files with SharePoint 2013

  • Word
  • Excel
  • PowerPoint

File Versioning in SharePoint 2013

  • Word 2013
  • Excel 2013
  • PowerPoint 2013

Using SharePoint 2013 with MS SharePoint Sync 2013

  • Add MS Office files to a SharePoint Sync / SkyDrive Pro

back to top