With the FIFA World Cup 2018 starting tomorrow, excitement is reaching fever pitch. In this blog post are three awesome World Cup 2018 trackers to choose from.
With these trackers you can easily follow the World Cup as the results come in, and improve your Excel skills at the same time.
I have an online course in how to create automated sports league tables. And these World Cup 2018 trackers utilize some of the skills I cover in that course.
So check them out, enjoy the football, and look under the hood of the spreadsheets to see how they work.
World Cup 2018 Schedule by Excely
The Excely website have templates for everything and anything so it was no surprise in how quickly they had this schedule available.
What is good
- I like that the schedule fits onto one sheet. No flicking between sheets to see the knockout stages, or the group tables.
- A settings tab allows you to select which language to view it in, your timezone and your favourite team to track them easily.
World Cup 2018 Excel Tracker by Chandoo
You can find this World Cup tracker on the Chandoo.org blog (one of the most respected around).
What is good
- You can select up to 5 teams to easily follow throughout the competition (shown below). No trouble seeing when they play at a glance.
- There is also a lovely timeline view of the schedule to see what is happening each day. This is modelled on a Gantt Chart view (see how to create a Gantt Chart in Excel).
- The result are live. You can just click refresh and the result update (no manual entry). This has been done with the Power Query feature of Excel (learn about Power Query).
World Cup Russia 2018 Sweepstake by Jacek Cetnarski
This sweepstake spreadsheet (try saying that lots of times) was created by Jacek Cetnarski, and Excel Expert living in London. He runs a blog at eexcel.co.uk.
What is good
- This spreadsheet double as a predictor league as well as a planner. There is a bookies tab where up to 3 players can predict the outcomes of matches and earn points for correct result and scores. These are then tallied in a league table (shown below).
- The schedule and results are all on one sheet to save navigation.
- You can select your time zone and favourite team to track.
If you love the World Cup and Excel, then you may also be interested in the World Cup history dashboard.
This was created by me for the 2014 World Cup and has been updated with the current data. It is a great way of seeing Excel skills applied in a fun way.