Excel Tables

I think that Pivot Tables should work. For the first, you would only have the names as your row labels. For the second, do the same, except include "favorite color" as a report filter.
If necessary, you could go into your Pivot Table Options, then Data, then check the box to refresh data when opening the file.

Hope this helps