SharePoint 2016: Managing Large Lists

Libraries and lists too long for practical use? Optimize SharePoint to increase the speed and efficiency of viewing and analyzing large lists.

Customization can increase the speed and efficiency of SharePoint users with large libraries of documents and lists. In this course, Gini von Courter shows how to optimize SharePoint when libraries and lists become too long for practical use. Learn how to use indexes and folders; filter lists with dynamic views; and load data faster with item limits and groups. Gini also shares three different strategies for using Access and Excel to work with list data outside of SharePoint. These are not only programmatic changes but also best practices for managing large libraries of content, which will help you become a better SharePoint user and admin.

Introduction

• Welcome
• What you need for this course

1. Working with Large Lists and Libraries

• Large lists and libraries: The issues
• Strategies for managing large lists and libraries
• Import Excel data into SharePoint
• Troubleshoot a blocked list in SharePoint Online

2. Using Indexes and Folders

• Indexed columns: The basics
• Create a simple index
• Create a folder
• Search a large list

3. Use Filtered Views

• Create a filtered view
• Know your filter functions
• Create a dynamic time-filtered view
• Create a dynamic user-focused view

4. Use Item Limits and Grouping for Faster Load Times

• Set item limits
• Use a Group By view

5. Advanced Topics

• Export a SharePoint list to Excel
• Link to a SharePoint list in Access
• Create an Access web app

Conclusion

• Next steps