I have basic knowledge of excel so please bear with me as I'm sure my question is quite basic for the experts on here. I have a spreadsheet which details student names, their year group and the date they became home educated. I want to create a summary worksheet which breaks down the data from the master spreadsheet as follows - to show the number of new home educated students by month, year group and gender. Can anyone point me in the right direction to go about this - would pivot tables work?
| Month | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 | Male | Female | |
| September | |||||||||||||||
| October | |||||||||||||||
| November | |||||||||||||||
| December | |||||||||||||||
| January | |||||||||||||||
| February | |||||||||||||||
| March | |||||||||||||||
| April | |||||||||||||||
| May | |||||||||||||||
| June | |||||||||||||||
| July | |||||||||||||||
| August | |||||||||||||||
| Total | |||||||||||||||
