A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.

It’s easy to display details in a PivotTable group if you know how to expand the group in Microsoft Excel.