From the course: SharePoint for Enterprise: Data Management
Unlock the full course today
Join today to access over 24,000 courses taught by industry experts.
People store spreadsheets rather than using lists - SharePoint Tutorial
From the course: SharePoint for Enterprise: Data Management
People store spreadsheets rather than using lists
- [Instructor] I talked a little bit earlier in the course about how you could improve Excel spreadsheets by applying metadata collection principles and data tables. Now I'm not going to knock Excel in general, it can be a tremendously useful tool. However, in many cases, I think it may not be the right tool, especially if you've got a SharePoint site handy. It's very typical to see Excel spreadsheets stored in file libraries. My take on that is that it's not the most effective way of recording and using the type of information that many spreadsheets contain. My recommendation is to use a list in SharePoint instead. Lists are a collection of information organized into columns and rows, just like a spreadsheet, but using lists in SharePoint gives you the ability to use your data in some pretty cool ways. It also makes it a simple task for your users to keep that information up-to-date. Now I'm going to get deeper into lists…
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.