Use an Excel Template to Track FIFA 2010 World Cup Schedules

FIFA World cup 2010 is going to start from June 11 and there is already some craze among the soccer fans. Here is a nice way to keep a schedule of all the matches in your hard drive.

Diego Oppenheimer, one of the employees of the Microsoft Excel product team has created an Excel template which can be used to keep track of all the upcoming world cup games, venues, league matches, match timings and also the points table.

Here is how the template looks:

Filter the matches of a particular team: The left column shows all the matches from the preliminary group stage. You can search and filter the matches of a particular team by using the search box at the top.

Let’s say you are a fan of Brazil and want to know the dates when Brazil has matches. Just enter the team name in the search box, hit Enter and the dates are highlighted as shown below:

Maintain the points table: After a match is over, you can enter the winning team and the losing team in the pink text box and the points table will be automatically updated.

This will decide the toppers of the Group standings and you can know the schedule of matches to be played in the next round. You can know which team is going to face a particular team in the Quarter finals, semi finals etc.

Sure, you are going to have a small text leaflet containing the match schedules, but why not use the same thing in a geeky way ?

Also see some iPhone and iPad apps to watch FIFA 2010 matches.

Tip: Create Timelines in Excel