Expanded

Manage Office Data with SharePoint 2013

By Bill Kulterman
In this course you will learn how to use SharePoint 2013 to work with various types of Microsoft Office data from Access to Visio. SharePoint can extend your Office experience and offer new ways to work with your data that you never expected.
Course info
Rating
(87)
Level
Intermediate
Updated
Mar 12, 2014
Duration
3h 40m
Table of contents
Customize a SharePoint List Form with InfoPath
Introduction 3m The SharePoint List 4m Create the Form 5m Add Form Fields 14m Save and Publish 5m Edit the Form 8m Submit the Form 8m Summary 2m
Create a SharePoint List Using Excel Data
Introduction 1m The Import Spreadsheet App 3m The Input Range 7m Modify a List View 3m Create a New List View 7m Summary 2m
Connect SharePoint Libraries to Outlook
Introduction 1m Connect to Outlook 4m Edit Offline 4m Update to SharePoint 3m Summary 2m
Connecting SharePoint Calendars to Outlook
Introduction 1m Connect to Outlook 5m Add an Event 4m Edit an Event 5m Delete an Event 2m Summary 2m
Using PowerPivot for SharePoint 2013
Introduction 2m About PowerPivot 5m Excel Add-in 4m Tabular Data 5m Using PowerPivot 7m Slicers 6m PowerPivot Gallery 8m Data Cubes 4m Publish 4m Data Refresh 2m Summary 2m
Using Power View in SharePoint 2013
Introduction 2m Power View 1m Excel Power View Report 6m Visualization 6m PowerPivot Gallery 2m More Visualization 3m Summary 2m
Creating Web Applications for SharePoint 2013 with Access 2013
Introduction 2m Service Apps 4m Create Web Applications 5m Access App from SharePoint 3m External Data 8m Customize 6m Summary 2m
Using Visio Services in SharePoint 2013
Introduction 3m Link Data to Shapes 6m Publish to SharePoint 3m View in the Browser 2m Summary 2m
Description
Course info
Rating
(87)
Level
Intermediate
Updated
Mar 12, 2014
Duration
3h 40m
Description

In this course see how SharePoint 2013 can help extend your Microsoft Office capabilities as well as how Office can help you to get more out of SharePoint. You’ll learn how to customize a SharePoint List form using InfoPath and import Excel data into a SharePoint list. Outlook and SharePoint work hand in hand to bring your SharePoint libraries and calendar into your Outlook for easy access and this course will show you how. Get a glimpse into the powerful ways to analyse data using PowerPivot and Power View with SharePoint and Excel. See how SharePoint can bring in data from external sources like SQL and other ODBC databases and give you the tools to make business decisions fast. You will also learn how to quickly and easily create a no code web application using Access 2013 and SharePoint. Finally we wrap the whole thing up by unleashing the power of Visio working alongside SharePoint. Allow users to view complex Visio drawings with just a web browser and SharePoint 2013.

About the author
Bill Kulterman
About the author

Bill Kulterman is an educator, author, and a Microsoft Certified Trainer (MCT). Bill has been a trainer for more than a dozen years, educating students in Excel, Visio and a bevy of additional solutions. In recent years he has focused solely on SharePoint and SharePoint Online through Office 365. When he's not creating courses, he can usually be found riding his bike or relaxing near his Koi pond.

More from the author
Visio 2019 Power Users
Intermediate
2h 45m
Sep 24, 2019
Excel 2019 Power Users
Intermediate
3h 26m
Aug 20, 2019
Excel 2019 Pro
Advanced
5h 20m
Aug 7, 2019
More courses by Bill Kulterman

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT