Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

SharePoint for Enterprise: Data Management

via LinkedIn Learning

Overview

Learn how to use lists, libraries, and views properly to manage SharePoint data.

Managing data is key to making SharePoint effective and accurate in reporting. In this course, Philip Gold explores the best practices for data management inside SharePoint, and across all SharePoint sites. Learn about the importance of metadata, and how well-formatted lists can perform the heavy lifting you used to do in Excel spreadsheets. Find out how to adjust permissions for sensitive libraries, and use version control to make sure no change is ever irrecoverable. Philip also shows how to create more dynamic views that allow users to sort and filter results, and integrate Excel and Project into your SharePoint data management workflow.

Syllabus

Introduction
  • Improve your data management strategy
1. Understanding Digital Information
  • The folder paradigm is out of date
  • What is metadata?
  • The power of metadata
2. Common SharePoint Challenges
  • Libraries often mirror existing structures
  • People don’t understand version control
  • People store spreadsheets rather than using lists
3. How Can You Use Metadata for Your SharePoint Site?
  • Understanding your data
  • Understanding how the data is used
  • Metadata structure for libraries
4. Metadata in SharePoint Lists
  • Lists instead of spreadsheets
  • Adding "choice" columns to capture metadata
  • Lookup columns
  • Calculating columns
5. Smarter Document Libraries
  • What do lists and libraries have in common?
  • Permission protection for access and editing
  • Co-editing and checkout/check-in
  • Using version control instead of multiple versions
  • Restoring old versions
6. Getting the Most Out of Views
  • Creating multiple views
  • Sorting and grouping results in a view
  • Totaling and counting results in a view
  • Filtering results
  • Staging views on pages
7. Integrating with Other Office Applications
  • Exporting from Excel to SharePoint
  • Importing to SharePoint from Excel
  • Exporting from SharePoint to Excel
  • Linking to Microsoft Project
Conclusion
  • Next steps

Taught by

Phil Gold

Reviews

Start your review of SharePoint for Enterprise: Data Management

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.