There may be some new analysis features in Excel but I would have thought you need to flatten the data into very tall table to be able to do all the clever Pivot Tables and Mail Merge functionality.
The structure I would be aiming for is:
Code:
Name | Class | Subject | Mark
Joe | Class 1 | Physics | 45
Peter | Class 1 | Physics | 42
Joe | Class 1 | Maths | 48
Peter | Class 1 | Maths | 41
Jane | Class 2 | Physics | 45
Sally | Class 3 | Chemistry | 42
Jane | Class 2 | RE | 48
Sally | Class 3 | Maths | 41
Once you have restructured along these lines, the sorting, collating and mail merges become simple.