FIFA Worldcup 2018 Excel Tracker – FREE Download

FIFA world cup 2018 is around the corner. I love soccer, I love Excel, Let’s marry them. Here is an awesome, free FIFA world cup Excel Tracker to help you follow this year’s games in Russia.

Click here to download the FIFA world cup 2018 tracker.

What you can do with this FIFA world cup Tracker Excel?

You can use this tracker to,

  • View schedules in your local time for group and knockout stages
  • View summary and detailed points table
  • Refresh live points table. When you refresh, the tracker show updated points based on latest results (You need Excel 2016, Office 365 or older versions of Excel with Power Query)
  • View knockout stage matches as a bracket
  • See timeline of the matches

How to use the world cup 2018 tracker?

Start page – set up the tracker

When you open the workbook, use “Home” page to set up your local timezone and favorite teams.

FIFA 2018 world cup tracker - home page

Group Stage – Schedule & summary points table

The group stage view shows all teams. It highlights your team(s) in different color to see when their games will be on.

2018 soccer world cup Excel - group schedule

On this page, you can also see group-wise points table. This is a live table. So as the matches happen, just press CTRL+ALT+F5 to update this table. The data comes from Wikipedia FIFA 2018 page thru Power Query. So you need Excel 2016 / Excel 365  or an older version of Excel with Power Query to get the refresh work.

group level points table - football world cup 2018

Bracket View – Knockout Schedule

The knockout stage shows last 16, quarter-final, semi final and final matches in bracket view. This page is not dynamic. So as group stage finishes, go ahead and list the team names in the gray cells. 

bracket view - knockout stage - Russia world cup 2018

Timeline View

This shows all matches in a Gantt chart like view. From this you can track all your favorite team matches. It will also highlight current date so you know which matches are coming up next.

soccer world cup 2018 Russia - timeline of the matches

Download FREE FIFA world cup tracker

Click here to download the FIFA world cup 2018 tracker.

Which teams are you rooting for?

As usual, I am cheering for Germany and Brazil. I will also watch out how Denmark & Sweden (my former homes) are going to play.

What about you?

The post FIFA Worldcup 2018 Excel Tracker – FREE Download appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

[source: http://feedproxy.google.com/~r/PointyHairedDilbert/~3/AS74cuShPdU/]