From the course: SharePoint Advanced: Working with PowerPivot
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Export list data from SharePoint to create a workbook
From the course: SharePoint Advanced: Working with PowerPivot
Export list data from SharePoint to create a workbook
- [Instructor] Okay, something I want to talk about for a minute. So I really like SharePoint List. I think they're a great way to capture information and I love how you can add all kinds of custom fields and perform calculations and use them with alerts and workflows to automate processes. I also think that the idea of having custom views that you can add that will sort the data for you and filter the data for you however you want it, being able to make those and stage those views all over your site to make a better user experience, well this is terrific. I often tell people not to use Excel if they need to manage information and make it available for teams. And in many cases, I recommend that they use SharePoint lists instead. However, getting nice visualizations of this information is not something that SharePoint currently does very well. Yeah, there are add-ons that will help, or you can export information to use in Microsoft Power BI. As of the time that I'm writing this class…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.