Navigate between sheets and understand data relationships.
Create a pivot summary showing how many employees are in each department (by Dept ID)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| # | Employee ID | Name | Department ID | Salary | Hire Date |
| 1 | 101 | Alice Johnson | 1 | 75000 | 2020-03-15T00:00:00.000Z |
| 2 | 102 | Bob Williams | 2 | 68000 | 2019-07-22T00:00:00.000Z |
| 3 | 103 | Carol Brown | 1 | 82000 | 2018-11-01T00:00:00.000Z |
| 4 | 104 | David Miller | 3 | 71000 | 2021-02-10T00:00:00.000Z |
| 5 | 105 | Eva Davis | 2 | 79000 | 2017-09-05T00:00:00.000Z |
| 6 | 106 | Frank Wilson | 1 | 85000 | 2016-04-20T00:00:00.000Z |
| 7 | 107 | Grace Lee | 3 | 67000 | 2022-01-08T00:00:00.000Z |
| 8 | 108 | Henry Taylor | 2 | 73000 | 2020-08-14T00:00:00.000Z |