This video is a follow up to one of my earlier and more popular tutorials where I demonstrate how to connect a SharePoint Online list to a Microsoft Excel spreadsheet. In my earlier tutorial, I demonstrate how you can connect SharePoint and Excel, but I did not cover how to display the values of complex column types such as the email of a user selected in a person type column, or even their name. You will note that when you establish the connection, these complex column types will display as [List] or [Value]. Since publishing that tutorial, I've received countless questions asking how to do this. And so in my latest tutorial, I demonstrate how you can use Microsoft Power Query in Excel to display the values of complex column types after connecting a SharePoint List to Excel. Check it out below!