Fifa World Cup 2014

For all the soccer lovers around the world. The games have started and everyone is trying to figure out who is going to win the trophy.

In order to honour the greatest FIFA football event, the people behind Spreadsheet 1 have created a free Excel spreadsheet to predict the World Cup Finalists. They have done a fantastic job once again!!!

In order for us to download it just click on the link below. There are two versions, one in German and one in English. Just select the one appropriate for you.

http://www.spreadsheet1.com/world-cup-2014-free-excel-prediction-template.html

Once we have downloaded the Excel file, we just open it and voila!!! All the Groups are presented to us. All we have to do is select the group that we want and all the games of the particular group appear in front of us. Once we know the result of a game, we just insert it in the appropriate cell, and all the statistics appear at the right.

World Cup 2014

In the image below, we can see the group that Greece is in. So all that we do as the days go by of the tournament, is to select the group and insert the results.

Groups

Group winners are automatically shown in the knock-out stage and their country flags are looked-up without using macros !

Knock Outs

The World Cup 2014 tab is divided in three parts, which are the following as shown in the images below:

Venues (Stadiums): If we select the command a drop down menu appears with all the stadiums that the games will be played. Once we select a stadium, an image of it appears with information.

Stadiums

Teams: Once we select the Teams command, all the groups appear in a drop down list, where we just select the group that we want, then the team that we want and finally the position that we are interested in. In the image below, I have selected Group C, then Greece, then Goalkeeper and finally the three goalkeepers appear.

Teams

Matches: Once we select the command Matches, all the games will appear along with the date, the time, the stadium as shown in the image below.

Matches

Hope you enjoy the tournament and I hope you enjoy the prediction sheet. Great job for everyone that participated in creating this excellent spreadsheet.

May the best win (hope it is Greece)!!!

Below you can check out the video about World Cup 2014 Spreadsheet.

Fifa World Cup 2014 Spreadsheet

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on June 17, 2014, in Spreadsheet1 and tagged , , , . Bookmark the permalink. Comments Off on Fifa World Cup 2014.

Comments are closed.