Before we dive into pivot tables in Excel, letâ s have a quick word about it. A pivot table is a powerful tool in Excel to summarize and analyze your vast database in different ways.

Click the Data tab. In the Get & Transform Data group, click From Table/Range. Doing so will open Power Query with your data. Click the Department header cell to select that column.

Select one of the colored cells in the Excel spreadsheet. From there, click on the Data tab above the Ribbon area. Via the Sort & Filter section, please click on Sort.