FIFA 2022 World Cup Schedule & Results – Excel [FREE Download]
It is the Soccer WORLD CUP time !!! Here is an Excel Workbook to keep track of the schedule, results, group standings and more. Download it today.
Group & Knockout Stage Views
Two separate tabs provide clear view of the schedules & results from Group Stage & Knock out stage of the football worldcup. They will auto-update whenever you refresh the workbook.
Fantasy View (set your own Group Stage Winners)
Pick your own winners for each of the 48 group stage matches and then see how that pans out at the knock-out stages (bracket view) with this cool Fantasy view. Switch between Fantasy and actual standings anytime.
Match Schedules:
The workbook also provides match schedules (dates & times as per local Qatar timezone) and quick access links to the match report.
Refreshable Scores & Group Standings:
The workbook is refreshable. If you hit CTRL ALT F5 (or Data ribbon > Refresh All), the group standings, points etc. will automatically update. The workbook uses Power Query in Excel to connect to Wikipedia page and fetch standings & results.
I plan to make a video explaining the process if time permits. But here is the quick run-down of the process:
As this workbook relies on the Wikipedia page, if something changes there, the workbook can break. I will check the file once every few days and fix any known problems. Comeback to this page and download latest version if possible.
If there are any issues with the file, please post a comment so I can fix them.
Alternative trackers:
These kind of files are a great little project to build up your Excel skills. I suggest reading up below pages to learn some of the skills:
The post FIFA 2022 World Cup Schedule & Results – Excel [FREE Download] appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.
