Learn how to use Microsoft Lists for data entry and multi-user data capture. Stop using Excel. Eliminate the need for multiple file copies, copy paste and manual consolidation. Get direct, live and auto-refreshable reports in Excel and Power BI. Manage security of data – each person can see and edit only their own data. Automate what happens after data is added. Choose from a wide range of data types. Learn everything about using Microsoft Lists. Watch the video and learn from detailed Q&A.
Microsoft Lists – event video – watch, try and learn
Microsoft Lists video Table of Contents
Use this TOC to jump directly to a specific topic within the video. Remember to watch the extensive Q&A where common questions are answered in detail – with demos.
- Problems with Excel based data entry
- How to start using Microsoft Lists
- Create a new List for lookup
- Version History
- Create new list for data capture
- Types of columns
- Lookup from another list
- Enter data into a list
- Using views in a list
- Sharing a list with others
- How to prevent people from editing other’s data
- Multi-user data entry
- Adding column to know who added which row
- Export to Excel
- Refreshing data in Excel
- Auto-refresh while opening the file
- Create Pivot Table report from a list
- Adding Lists to Teams
- Automating actions after data is added to list
- Power Automate Demo
SharePoint List – create custom permission levels
A single list can have up to 30 million rows. SharePoint capacity and limits
The TOC links dont show the correct video about MS Lists….
Thanks for highlighting the issue. The problem is resolved. The links are now pointing to the Lists video.