The 2014 world Cup: Own schedule with Excel to create

The 2014 world Cup is at the door! The Overview of all events to keep you with a schedule that you create in Excel. Here, you will learn how it's done.

Step 1: world Cup groups to enter

GA map of the world Cup in 2014 with all the information you find here. First, create a table, in the groups field.

1. Open Excel with a new document.
2. Click at the bottom left with a right-click on the "table 1" and then click "Rename". For the title, type "groups".
3. Here, you enter the groups as seen in the picture. For each group, you need the columns "winners" and "Second".

Step 2: Group Stage

The new table / table rename the New table / table rename next, enter the matches of the group stage in your document.

1. Rename "table 2" to "group stage". (As explained above)
2. Enter the meetings, as in the example below, ordered by groups.

For Example: Group A

Meeting of the group A meeting of the group A In the Following, we explain to them the example of the group A step-by-step, how the meetings here.

1. In A1 write "group A".
2. Select the cells B2 and C2, click with the right mouse button and select "format cells".
3. Click on the tab "orientation" and put a check mark in the "merge cells". Confirm with "OK".
4. Now enter in the connected cells "result", and at the top, choose the alignment, "Centered".
5. In the cells A3 to A8 and D3 to D8 enter the meetings as in the picture.

Step 3: create finals

The second round, The second round, in order not To each team individually in the final rounds, enter the need to create a reference that does this for you.

1. Create the tables, "the next round", "the quarter-finals", "semi-finals" and "Finale & the game for 3rd place". A new table, you can use the small icon at the bottom next to the Table to create.
2. As soon as the Gruppenplatzierungen fixed, enter the first and runner-up in the Leaderboard.
3. Look in the schedule to, anyone against whom in the round of play. The first round would be, for example, "the winner of group A" against the "second group B".
4. Set the Overview for the knockout stages exactly as it was from the group stage to know.
5. Instead of the individual teams to enter, refer to the cells in which the group winners and second have entered. Write it in the desired cell "=", click on the table "groups" and then on the first or second team. Then confirm with Enter.
6. Behind the meetings of the Achtelfinals enter the following formula: "=IF(B3>C3;A3;D3)". To determine the winner. (The references are valid for the example in the picture)
7. The following final rounds create according to the same scheme, as the knockout stages. This time, they point to the cells in which the winner of the previous finals.

2014 World Cup Internet The 2014 world Cup: Own schedule with Excel to create

The 2014 world Cup: Own schedule with Excel to create

By David Amoyal → Friday, May 16, 2014

The 2014 world Cup is at the door! The Overview of all events to keep you with a schedule that you create in Excel. Here, you will learn how...