The 3 best FIFA World Cup Excel Templates

Make or get a 2018 FIFA World Cup Excel Template for recording results! Following the matches is a great way to practice Excel! I recommend 3 great Excel templates.

The point is to use Excel and learn from it. Good experiences (like the FIFA World Cup) can change your attitude to Excel, and also help you remember more information (Excel features), since you are emotionally or intellectually tossed.

Make your own World Cup Excel template!

First I recommend you to create an Excel table on your own, that reflects your thinking and preferences. If the whole task is too big, just model subtasks!

You can practice the following:

  • Create a database: for example make teams and players lists, schedule of the matches
  • Write formulas: Calculate the difference in the goal or HA to the forward team
  • Color by Conditional formatting: you can automatically color good results.

You can find the details and rules of the 2018 FIFA World Cup on the Wikipedia page.

Use ready-made World Cup Excel templates! I show you 3 of them

If you do not want to start recording and editing now, or you need some inspiration, I recommend you these Excel Templates. You can track not only the results, but also write down your tips, and plan the result of your favorite team. World Cup Excel Template

Download file from, there are several templates for sports events, and track all matches of the international football tournament.

World Cup Excel template (

  1. Set language on the “Settings” tab (cell C4). There are also Hungarian, so you can find your own language, too. You can write it, or choose from the drop-down list.
  2. You can also set your time zone to GMT + 1:00, so you will see exactly the time of the matches.
  3. Enter the final result of the games on the main table (2018 World Cup), and everything will be automatic: the winner is marked in blue, and the losing team will become red in. Excel calculates the scores for the Football Team according to FIFA standards – without macros. World Cup Excel Template

I also recommend the template of the football which you can download by clicking here.

World Cup Excel Template (

You can also set the time zone on this template, although the days are unfortunately not shown properly – on my Hungarian version.

On the BOOKIE tab, you can record bets with 3 players, which will  be immediately evaluated. If you want to play more, you have to pay for the 20-50-100 version (a symbolic € per person). FIFA Worldcup 2018 Excel Tracker

Chandoo's World Cup Excel TemplateWith this Excel Tracker (click and download from here) you can view summary and detailed points table, and also have a bracket and timeline view.

In the settings, you can give you favorite teams, so you can follow them throughout the World Cup.

More Excel secrets

Please share this article with those who may get closer to Excel with these templates.

If you need help with Excel learning or interpretation of templates, we would be happy to help you on a Privat Excel Lessons through Skype.

What is an Excel Hyperlink, and how to use them?

With an Excel Hyperlink you can link another file or website to your Excel file, so you don’t have to search for it again and again. Or if the Excel file or Word document is too large, you can make a link inside the file, so you can jump from one point to another with a single click.

Excel hyperlink shortcut is Ctrl KIt’s simplier than you think, and it works in Excel, Word, Outlook and even on the Internet (for example, online email or web site editors) and it even has a hotkey!

Insert an Excel hyperlink

The name of the “link” in Office programs is “hyperlink”.  To insert a link:

  1. First, select the part you want to assign the hyperlink to. This can be an Excel cell, any length of text, or even a shape (eg image or button).
  2. Use Ctrl K (on Mac: Cmd K) shortcut to locate the link. If you are searching for the icon on the Ribbon: Insert tab / Hyperlink button.
  3. Fill out the fields.

4 main types of Excel Hyperlink

Insert Excel Hyperlink

On the left you can choose from 4 options:

  • An existing file or web page
  • The specific point of a document, eg. a specific cell or named range in an Excel worksheet or file
  • New document
  • Email Address: By clicking this button, you automatically open an email with this address in your email.

Excel Hyperlink function

In Excel, there is a function called HYPERLINK. You can use this to make texts as clickable links. The function has 2 parts: HYPERLINK(link_location, [friendly_name])

  • Link_location: The hyperlink itself, the path and file name to the document or webpage you want to open. Link_location can be a referred from a cell, or it can be a text string enclosed in quotation marks.
  • Friendly_name: It is the text that appears as a link. It’s optional, in case of missing, the link itself will appear. Friendly_name will be displayed in blue and is underlined. 

For example: =HYPERLINK(A2; “link”)

You can specify text, cell references, and more complex formulas in both parts, for example, you can paste text from different cells.

For example: =HYPERLINK(A2; B2 & ” company contract”)

Use Excel hyperlinks, and make your own life and your colleagues’ lives easier, as you don’t have to spend hours with searching.

If you would like personal help with Excel, come and learn Excel with us via Skype.

Tricky secret to move cells in Excel

Move cells and columns with your mouse

If you want to copy cells or columns to a nearby location, simply select the cells and then hold the mouse over the border. In this case, the 4-way arrow is displayed, which means that you can move the cells. Simply move them with the mouse (drag-and-drop).

move cells easilyIf you also press Ctrl, the arrow changes to +.

If you are moving the range this way, the original cells will be preserved and there will be a copy on the other place, too.

Always pay attention to the shape of the mouse as it indicates that you are moving or copying the selection.

Changing columns, or move columns within the table

move cells simplyIf you press the Shift button while moving the cells, you can move the column (or cells) so that it insert additional cells – and doesn’t overwrite the original data.

In this case, a gray “strip” shows where the data is transferred. (In the small gray window, the exact cell range is displayed.) As you release the mouse (still hold down the Shift key), the cells will slip right, and the cell or column exchange is ready.

More Excel secrets

Come and learn with us, take Privat Excel Lessons through Skype.