----- Forwarded Message -----

If forwarding further, please delete my id, and use the BCC field for addressees, to reduce spam, viruses and identity theft. Thanks!

From: Chandoo.org – Learn Excel, Power BI & Charting Online

Sent: Thursday, June 7, 2018 23:14

To: ...

Subject: FIFA Worldcup 2018 Excel Tracker – FREE Download (chandoo.org)

FIFA Worldcup 2018 Excel Tracker – FREE Download (chandoo.org)

Link to Chandoo.org – Learn Excel, Power BI & Charting Online

FIFA Worldcup 2018 Excel Tracker – FREE Download

Posted: 07 Jun 2018 03:35 AM PDT

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.

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