This is more personal project, and I'm not totally sure it's what Excel is for, so if I should be using a database instead of a spreadsheet, let me know.

I want to count and quantify the movies I've seen over the past 10 years and all those going forward. The question is how to do this.

On the main sheet I'd like each year displayed with the number of movies seen, followed by how many I liked, then each genre of movies broken down by the same criteria

so it would look something like this:

2002:
19 movies seen, 11 liked, meaning you liked X% of movies overall
5 were scifi, 3 liked, so you liked X% of scifi movies this year
3 were comedies, 2 liked, so you liked X% of comedies this year

I'd also like it to calculate overall stats, something like this:

You've seen X movies total and liked X of them, which X% overall
Scifi movies, you've seen X total and liked X of them, which is X% overall for scifi

Now, how do I go about setting this up.

I was thinking the actual movie data per year should be on a separate sheet, arranged in rows like so:

Movie | Liked or not | Genre

Where for movie I input text, like or not is Yes or No type selection and Genre is drop down menu of pre-entered selections. This way each row is an "object" which Excel can then track.

If this is correct, how do I go about setting this up in Excel, I'm not familiar with forms or data or types. I've never really used Excel, I'm a graphic designer by trade and I haven't been able to figure it out myself. Help, please!