SharePoint Advanced: Working with PowerPivot

Download Tutorial 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.

Topics include:

  • PivotTables vs. PowerPivot and PowerView
  • Using SharePoint as a BI Center
  • Connecting PowerPivot to an existing Excel workbook
  • Connecting to external data sources
  • Exporting list data from SharePoint to create a workbook
  • Using PowerPivot and PowerView in Excel
  • Uploading a workbook to a SharePoint BI Center
  • Publishing workbooks and creating dashboards

Screenshot Tutorials/Courses

Download Tutorials/Courses

Password :

Related Articles

Leave a Reply

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

Back to top button