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.
 
Trackbacks
  • Trackbacks are closed for this post.
Comments
  • No comments exist for this post.
Leave a comment

Submitted comments are subject to moderation before being displayed.

 Enter the above security code (required)

 Name

 Email (will not be published)

 Website

Your comment is 0 characters limited to 3000 characters.