Sorting moves whole rows: the order, the manager and the amount stay together. Click any cell of the column you need and choose Sort A to Z or Sort Z to A (Data or Home → Sort & Filter). Excel finds the table edges itself and recognises the first row as headers.
- Numbers sort by size, text alphabetically, dates by time. Blank cells always go to the end.
- Do not select a single column before sorting: Excel asks "Expand the selection?", and if you answer no, that column is reordered on its own — the data is ruined.
- Multi-level sorting — Data → Sort (a dialog with levels): "by region, then by amount". Sorting the levels in reverse order gives the same result: the secondary key first, then the main one — Excel keeps equal rows in their order.
- Custom lists (Mon, Tue, Wed…) and sorting by colour are in the same dialog.
In the trainer there is a toolbar above the sheet: Sort A→Z, Z→A, Filter, Format as Table. The column of the active cell is sorted.