Attention all football fans around the globe! The biggest soccer festival will kick off on 20 November 2022 in Qatar and everyone is guessing who will have the honour of lifting the golden trophy. Could the European teams edge off their South American counterparts and keep the trophy in Madrid, Berlin, Paris or London? Please let us know your opinion in the comments below.
To celebrate the greatest FIFA football games, we have created a free interactive Excel spreadsheet to predict the World Cup finalists! Keep track of the FIFA schedule and fill in your score predictions in Excel! Our template can be customized.
To celebrate the greatest FIFA football games, we have created a free interactive Excel spreadsheet to predict the World Cup finalists! Keep track of the FIFA schedule and fill in your score predictions in Excel! Our template can be customized.
If you would like to review our Excel spreadsheet templates for previous World Cups here are the links to FIFA World Cup 2014 Brazil and World Cup 2018 Russia.
The decimal place can be used for penalties and ties in any stage.
Video Review In English
Watch this video by Excel MVP John Michaloudis to learn how our FIFA World Cup 2022 prediction simulation works
Watch this video by Excel MVP John Michaloudis to learn how our FIFA World Cup 2022 prediction simulation works
Video Reviews In Spanish
Video review of our schedule template by Excel MVP Sergio Alejandro Campos from Mexico
Video review of our ribbon user interface on an Apple iPad by Excel MVP Otto González from San Salvador
LAMBDA Functions Explained
Since 2021, LAMBDA functions allow users to define new functions written in Excel’s own formula language. After being defined and named, LAMBDA functions can be used anywhere in a workbook.
Please click here to learn how our World Cup 2022 Qatar template is made
Please click here to learn how our World Cup 2022 Qatar template is made
Custom UI Ribbon
Users who prefer an Excel dictator application rather than a spreadsheet template look can hide worksheet tabs and the formula bar using the Show/Hide Tabs ribbon button. Group and knockout stages are accessible either via ribbon buttons or hyperlinked shapes within the worksheets.
The custom XML code was generated using the Ribbon Commander framework.
The custom XML code was generated using the Ribbon Commander framework.
Custom UI ribbon in the macro-enabled World Cup 2022 template (xlsm)
XML code generated with the Ribbon Commander framework
XML code generated with the Ribbon Commander framework
Change Log
Changelog
|
Templates for Office
v1.0 - Oct 24 - Macro free version v2.0 - Oct 28 - Macro enabled version v3.0 - Nov 12 - Updated ribbon UI in xlsm v3.1 - Nov 15 - Help tab updated v3.4 - Nov 23 - Score updates / Chinese translation v3.5 - Nov 25 - Score updates / All-time winners table v3.6 - Dec 01 - Score, formatting & ribbon updates |
VBA Add-in (xlam)
Coming soon |
Free Download For Excel
A macro-free (xlsx) and a macro-enabled (xlsm) template with a ribbon UI and an unlocked VBA project are bundled in the zip file. Please click on the Readme.png before opening a workbook in Excel.
Download
For Office 2007-2021 & 365
Formula calculations with built-in functions & arrays |
For Office 365 only
Formula calculations with LAMBDA functions |
Template Modification Rights
|
Please click the icon or here to learn how to unprotect worksheets & workbook structure in order to customize the World Cup 2022 schedule to your needs. |
A spreadsheet with World Cup 2022 squad data is offered to all soccer fans who buy the modification rights of our Excel template. The list is the ultimate guide to team players who will be looking for glory in Qatar!
World Cup 2022 Squads in Excel Table
Scores & Hyperlinks To Video Highlights
|
Click the icon or here to download a spreadsheet updated daily with scores and links to video highlights in YouTube! |
Also included: Spreadsheet with links to video highlights and daily scores
Free Printable Wall Chart PDF Schedule
Please click the icon or here to download our FIFA World Cup 2022 template in a printable PDF schedule for use as a Wall Chart!
Free World Cup 2022 Sweepstake Kit
Everything you need to create your sweepstake with friends, family and colleagues. Sweepstakes can be fun and a great team bonding activity, assuming winners spend their prize money on drinks or confectionery!
Free World Cup 2022 PDF Sweepstake Kit
Golden Boot Players
|
|
What Do You Think?
I would love to get your input on how to make this Excel World Cup template better. If you notice any bugs or have a new feature request or would like to suggest modifications to existing features, please let me know in the comments section below. I look forward to your feedback :)
