Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

We’ll demonstrate in Excel for Windows with a Microsoft 365 subscription. If you use a different version of Excel, most steps will work similarly, but you may not have all the features shown here.