Lynda - SharePoint Advanced: Working with PowerPivot

Lynda - SharePoint Advanced: Working with PowerPivot

PowerPivot can be connected to Excel to add advanced data functionality inside of SharePoint. In this course, learn how to use PowerPivot and SharePoint to move data between SharePoint and Office 365 apps, as well as visualize and manipulate data inside SharePoint. To begin, instructor Phil Gold describes the similarities and differences between regular PivotTables and PowerPivot and the benefits of using SharePoint as a BI Center for your team. He shares how to set up PowerPivot and PowerView in Excel, how to connect them to your data, and how to upload a workbook to a SharePoint BI Center. Plus, learn how to share your BI Center with your team.

https://www.lynda.com/SharePoint-tutorials/SharePoint-Advanced-Working-PowerPivot/743147-2.html

Introduction

1. SharePoint As a Data Tool

2. Start by Creating and Connecting

3. Use PowerPivot and PowerView in Excel

4. Upload a Workbook to a SharePoint BI Center

5. Publish Workbooks and Create Dashboards

Conclusion

Table of Contents

Would you like to be a Author?

Friends (email)