Excel World Cup cake: how to organize bets on a spreadsheet | Productivity

The 2018 World Cup cake can be organized in Excel no matter how many sites and apps there are for the task. The program is an option to create your own world cup table and register bets for the cake with friends.

The good old spreadsheet for those who make a point of doing all the manual work and filling in the information, who knows, as a way to become more familiar with the games and groups of the tournament. See the tutorial below on how to create a simple table in Excel for the Russian Cup.

2018 World Cup cake: see sites to place bets with friends

Ready spreadsheets in Microsoft Excel to enjoy the holidays

Ready spreadsheets in Microsoft Excel to enjoy the holidays

Step 1. The first step is to research the organization of the World Cup groups on the web. Type cup 2018 on Google to see the list of games;

Search the cup table on Google Photo: Reproduo / Paulo AlvesSearch the cup table on Google Photo: Reproduo / Paulo Alves

Search the cup table on Google Photo: Reproduo / Paulo Alves

Step 2. With the information in hand, start by creating the first group of the competition. Type the name in the first cell, check until column E and select the option Merge and center to create the title;

Create a title in a row up to column E Photo: Reproduo / Paulo AlvesCreate a title in a row up to column E Photo: Reproduo / Paulo Alves

Create a title in a row up to column E Photo: Reproduo / Paulo Alves

Step 3. Then, mark a rectangle from column E to line 7 and click the right mouse button. Select the All Borders option;

Create a box with borders up to line 7 Photo: Reproduo / Paulo AlvesCreate a box with borders up to line 7 Photo: Reproduo / Paulo Alves

Create a box with borders up to line 7 Photo: Reproduo / Paulo Alves

Step 4. Fill in the country names in the order in which you will play the matches, according to the Google table. Type the names in the side columns, leaving the center empty. Then, align the cells with the content and place x in the center column;

D each table with country names Photo: Reproduo / Paulo Alves

D each table with country names Photo: Reproduo / Paulo Alves

Step 5. Format the table's colors and shapes only in Group A. The pattern will be replicated to the other groups later;

Format colors, fonts and other visual details only from the first group Photo: Reproduo / Paulo Alves

Format colors, fonts and other visual details only from the first group Photo: Reproduo / Paulo Alves

Step 6. Name worksheet 1 as First phase and create a second one in the same document called Eliminatrias. Then, copy the contents of the Group A table and arrange on the screen until Group H;

Name the spreadsheet and copy the table from the first group Photo: Reproduo / Paulo AlvesName the spreadsheet and copy the table from the first group Photo: Reproduo / Paulo Alves

Name the spreadsheet and copy the table from the first group Photo: Reproduo / Paulo Alves

Step 7. This is the most laborious part of the spreadsheet. Leave the dates and times of the games out to reduce worry about the order of the games. In the first phase, it is important to have matches between all countries within the same group;

Replicate the design to Group H using the official tournament information Foto: Reproduo / Paulo AlvesReplicate the design to Group H using the official tournament information Foto: Reproduo / Paulo Alves

Replicate the design to Group H using the official tournament information Foto: Reproduo / Paulo Alves

Step 8. In the Eliminatorias worksheet, paste the group design again and change the title to Eighths. In place of the countries, align the first placed left and the second placed right, according to the order shown in the image. At this stage it is also important to number the games. Create a new right column and name each match as Octaves 1, Octaves 2 and so on;

Number the games from the round of 16 Photo: Reproduo / Paulo AlvesNumber the games from the round of 16 Photo: Reproduo / Paulo Alves

Number the games from the round of 16 Photo: Reproduo / Paulo Alves

Step 9. Copy the octave design to create two new quarterfinal and semifinal tables. This time, use the winners of the octaves in the country fields in ascending order: the winner of the game Oitavas 1 faces the winner of Oitavas 2, and so on. Remember to cut the number of lines in half in each of the two phases;

Halve the lines in the quarterfinals and semi-finals Photo: Reproduo / Paulo AlvesHalve the lines in the quarterfinals and semi-finals Photo: Reproduo / Paulo Alves

Halve the lines in the quarterfinals and semi-finals Photo: Reproduo / Paulo Alves

Step 10. Finally, paste again the design of the groups from the initial phase to create the tables of the last two games. The lines do not need to be numbered or filled in, since the winners of the semifinals will necessarily be in the grand final.

Leave the third and final fields blank in the "Eliminatrias" tab Photo: Reproduo / Paulo AlvesLeave the third and final fields blank in the "Eliminatrias" tab Photo: Reproduo / Paulo Alves

Leave the third and final fields blank in the "Eliminatrias" tab Photo: Reproduo / Paulo Alves

Once the spreadsheet has been created, just share it with friends so that everyone can fill in and compare the guesses at the end.