||Conferences & Workshops. Tables—called lists in previous versions of Excel—make it easier to work with ranges of Excel data. By turning an Excel range into a table, you can work with the table data independently from the rest of the worksheet. You can quickly sort and filter the table columns, add total rows, and apply table formatting to an Excel table. There are many ways to analyze worksheet data, including sorting and filtering records. This workshop will also explain how to use a PivotTable to analyze data ranges.