5.5. Records using Excel spreadsheet/database
If you’re using Excel, filters can be added to enable the selection of certain groups of students to establish their date of birth, tutor group, Key Skills block, etc. (see illustrations below). However, it’s much more efficient to use Access. Both of these are packages that some of your students may be using for their own work. So, it would be a good idea to learn how to use them effectively yourself.
This selects students in Key Skills block C2.