SharePoint tutorial: Sharing a workbook using an Excel Web Access Web Part | lynda.com



In this tutorial, Gini Courter goes step-by-step through the process in SharePoint 2013. Watch more at http://www.lynda.com/Office-tutorials/SharePoint-Server-2013-Essential-Training/121679-2.html?utm_campaign=3cwRLDJuM5Uw&utm_medium=viral&utm_source=youtube.

This tutorial is a single movie from the SharePoint Server 2013 Essential Training course presented by lynda.com author Gini Courter. The complete course duration is 14 hours and 35 minutes and shows how to get started using SharePoint Server 2013 for business collaboration and real-time documentation sharing. Delivering spreadsheet data for your colleagues in SharePoint is made easy using the Excel Web Access Web Part

Introduction
1. Introducing SharePoint
2. SharePoint Team Sites
3. Editing, Saving, and Sharing Documents
4. Working with Library and List Apps
5. Social Networking in SharePoint
6. SharePoint Sites and SharePoint Site Collections
7. Editing SharePoint Pages
8. Integration: SharePoint 2013 and Office 2013
9. SharePoint Permissions
10. SharePoint Workflows
11. SharePoint Content and Documents
12. Other SharePoint Server Site Templates
13. SharePoint Server Business Intelligence Features
Goodbye

source

7 thoughts on “SharePoint tutorial: Sharing a workbook using an Excel Web Access Web Part | lynda.com”

  1. I tried to edit the workbook from SharePoint to see if the charts update but they do not. I tried using the recalculate option but the graph did not update to reflect the changes I made in the workbook. Can you tell me if this is possible and if so how to do it?

  2. How we can add a PowerView report in the Excel Web Access? I have 3 sheets in one workbook, the first 2 sheets are pivot table and the 3rd sheet is a PowerView and I only want to show the 3rd sheet which is the powerview. Thank you for your thoughts and also for sharing this short demo so helpful! 🙂

  3. hi, i have an Annual Leave Resource Excel spreadsheet sitting on a SharePoint site, and i have a Resource Tracker Excel document sitting on my desktop. I am trying to figure out how if i update the "Annual Leave Resource Excel spreadsheet sitting on a SharePoint" to be linked and auto update my " Resource Tracker Excel document sitting on my desktop"

  4. That was a great video. Not sure if this was mentioned, but if the workbook is updated elsewhere (on a local machine) and re-uploaded to the same location just with different data, will the dashboard layer auto update, or will they need to be manually refreshed. In essence, I have around 30 tables of data within Excel, ( I could name each one with a naming range). And this workbook is updated each week. could I simply re-upload and expect the front end to auto update. – ( hope all that makes sense) 

  5. Thanks for the video!

    Question: I have the Excel Chart connected to a SharePoint list. How do I make the web-part refresh the Chart dynamically? I have all my connections/pivots set to "Refresh on Open" but when I updated an item in a list… it will not update the Excel Web Part.

Leave a Reply

Your email address will not be published. Required fields are marked *