Microsoft/SharePoint Lists: Successor to Excel?
Microsoft Lists is a new product which combines the classic SharePoint lists with a modern user interface which seems to be inspired by table-based project management products such as Air Table and SmartSheet. I will go through what does Lists have over and above Excel (like alerts, notification support, form customisation, a gallery view), when Excel sometimes fails and how is the look and feel of the product. I will also compare it to Google Sheets which has some surprising benefits over both features.
I refer to the underused Excel Tables feature on the video, check it out here: / top-5-speed-up-tricks-revolutionise-your-a...
Table of contents:
00:00 - Introduction
00:45 - First look
01:16 - Editing
02:36 - Gallery view
03:07 - Edit form
03:29 - Flows & alerts
04:09 - Filters & views
04:45 - Audit history
05:06 - Export to Excel
05:41 - What Excel lacks
06:50 - Why Excel causes issues
08:15 - The ideal spreadsheet
08:44 - Format columns
10:14 - Grouping and totals
10:43 - Where Lists fails
11:44 - Google Sheets: The best of both worlds?