Join Gini von Courter for an in-depth discussion in this video Excel and SharePoint, part of SharePoint 2016 Essential Training.
- [Voiceover] Integration between SharePoint and Excel…ranges from the simple to the truly magnificent.…On the simple end, we start with the basic collaboration…that we have whenever we're using Excel, Word, PowerPoint,…any other Office application, with SharePoint.…By saving my document in a SharePoint library, I've made…it possible for other people to use it as well and I've…opened door to collaboration.…All I have to do is choose File, Save As, and save my file…here in this documents library or in the resource library…and I have a document that I can share with others.…
Or I can upload documents.…So, for example, this Excel document,…Events by Location 2015, I can click in the library…and open it in Excel online.…We'll see a note in the yellow banner that says there are…some features in the workbook that can't be…shown in a browser.…That's because Excel is more complex than a browser.…Shapes or other objects, but you can see all the content in…this workbook by opening the file in Excel.…In other words, it's not displayed but it's also not…
Author
Gini von Courter
Released
6/28/2016- What is SharePoint?
- Understanding SharePoint roles
- Searching SharePoint sites
- Editing, saving, and sharing documents
- Using OneDrive for Business for file storage
- Working with libraries and list apps
- Creating custom and dynamic views
- Changing file, item, and list settings
- Using the SharePoint social features, including your newsfeed
- Creating site collections and sites
- Working with app parts and web parts
- Displaying images and media
- Integrating SharePoint 2016, Office 2016, and Office 365
- Customizing search in SharePoint
- Adjusting SharePoint permissions
- Creating content types and document sets
- Using SharePoint site templates
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome48s
-
-
1. Introduction to SharePoint
-
SharePoint: The basics9m 4s
-
Log in to SharePoint2m 32s
-
Edit your profile5m 20s
-
-
2. Working with SharePoint Sites
-
Team sites: The basics5m 6s
-
View all site content5m 38s
-
Follow a site2m 22s
-
-
3. Editing, Saving, and Sharing Documents
-
Navigate in a library9m 47s
-
Open and edit a document6m 54s
-
Save a document in a library6m 46s
-
Share a file, library, or site15m 47s
-
Use checkout and check-in7m 21s
-
-
4. Working with List Apps
-
Use a list app6m 31s
-
Other ways to create lists3m 28s
-
Create a custom list6m 14s
-
Export a list from Excel9m 26s
-
Group items in a view4m 24s
-
Create a dynamic view6m 49s
-
Subscribe to an RSS feed9m 15s
-
5. Building Site Collections and Customizing Sites
-
Create a team site9m 52s
-
Apply a logo and theme8m 47s
-
Modify site navigation5m 4s
-
Create a project site8m 51s
-
Use your custom template1m 48s
-
6. Modifying SharePoint Pages
-
Add or remove an App Part5m 55s
-
Add a Web Part5m 56s
-
Show an image on a page4m 20s
-
Create a wiki page8m 30s
-
Create a Web Part page7m 29s
-
7. SharePoint Online on Mobile Devices
-
Set an alert5m 53s
-
8. Integration: SharePoint 2016 and Office
-
Outlook and SharePoint11m 23s
-
Word and SharePoint5m 26s
-
Excel and SharePoint7m 52s
-
OneNote and SharePoint4m 45s
-
PowerPoint and SharePoint3m 16s
-
Coauthor in Excel Online4m 35s
-
InfoPath and SharePoint12m 42s
-
Access and SharePoint4m 32s
-
Visio and SharePoint Online3m 55s
-
-
9. Social Networking in SharePoint
-
Follow everything5m 13s
-
10. Customizing Search in SharePoint
-
Search in SharePoint 20165m 19s
-
Set an alert for a search1m 10s
-
Use find and advanced search3m 23s
-
-
11. SharePoint Permissions
-
12. SharePoint Content and Documents
-
Content types: The basics5m 46s
-
Create a content type9m 9s
-
Use a custom content type6m 20s
-
13. SharePoint Workflows
-
Workflows: The basics4m 26s
-
Run the three-state workflow4m 49s
-
-
14. Advanced Topics
-
BI in Excel and SharePoint8m 42s
-
Compliance and security3m 42s
-
Goodbye
-
Next steps2m 31s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Excel and SharePoint