The spreadsheet update, part 1
I have updated the Academy Awards spreadsheet to include a comparison table. This is my first experience using a pivot table, so I'm not sure that I've used it in the best way possible. At any rate, here's how to use the spreadsheet:
Setting up your preferences:
1. On the Nomination vs. Award Tracker tab, you can change the films that are shown. To do this, click on the dropdown arrow next to the word "Film". You can add or remove check marks in front of each film's name (check mark=visible, no check mark=not visible). When you've selected all of the movies you want to view, click OK.
Using the Tracker:
1. On the 2005 tab, type a "1" in the "Award" column when the winner is announced in each category.
2. On the Nomination vs. Award Tracker tab, right click in the table and select "Refresh"
Here's the updated spreadsheet for your review.
Setting up your preferences:
1. On the Nomination vs. Award Tracker tab, you can change the films that are shown. To do this, click on the dropdown arrow next to the word "Film". You can add or remove check marks in front of each film's name (check mark=visible, no check mark=not visible). When you've selected all of the movies you want to view, click OK.
Using the Tracker:
1. On the 2005 tab, type a "1" in the "Award" column when the winner is announced in each category.
2. On the Nomination vs. Award Tracker tab, right click in the table and select "Refresh"
Here's the updated spreadsheet for your review.

Comments