Euro 2020 Excel Predictor

Photo of author
Post By:

Euro 2020 is finally upon us, albeit a year late due to Covid and what better way to showcase Excel than with a free Euro 2020 Predictor tool built with….Excel 🙂

Background

The Euro 2020 Championships will take place between Friday 11th June 2021 and Sunday 11th July 2021. In a change from the norm matches are spread across various nations in Europe with the semi’s and final taking place at Wembley, London.

Reigning champions Portugal and their talisman Cristiano Ronaldo are looking to retain their title in what may be his last tournament. At 9/1 they are outsiders to the likes of France, England and Belgium but you can never write off a team with one of the worlds greatest players leading the line. Perhaps you can chart Portugal’s journey to the final using this Euro 2020 Excel predictor and see if you fancy their chances this time around?

Excel Download File

The free Euro 2020 Excel Predictor can be downloaded from the link at the end of this post, it does not contain any macros. The predictor tool has been developed using Excel 365 although the functionality should work in older versions of Excel if you haven’t upgraded yet.

To use the file enter your predictions for the matches starting with the Group Stage worksheet. The league tables will update when you enter the scores so you can see which teams are in the qualifying positions for the knock out stages as you update.

Excel Predictor tool for Euro 2020

When all scores for the group stages have been entered the Knockout Stage worksheet shows the latter stages of the tournament.

Excel Predictor tool for Euro 2020

Teams are auto-populated from their league positions to the Last 16 matches and then auto-populated to each round thereafter. Basically this means all you do is enter a score for each match and the Excel file will do the rest!

Bonus

As an added bonus there is a Euro 2020 Sweepstake kit included in the file. On the Sweepstake Kit worksheet you have a printable sheet of tickets containing all 24 teams in the finals and a handy tracker so you can log the ticket holders.

Enjoy the tournament!

Download the Euro 2020 Predictor Excel File

Keep Excelling,

Explore our treasure trove of Free Excel tools and insightful posts for all skill levels. Dive into our detailed guide on adding a trendline to an Excel chart and unlock your own prediction skills. It’s more than just a guide, it’s your step into advanced Excel mastery!

With over 20 years in the field, I've become a go-to consultant for all things Excel. From basic formulas to complex macros and dashboards, I've tackled a wide range of Excel challenges. My goal? To demystify Excel's vast capabilities and empower you with practical skills and insights. Join me in this journey to unlock the full potential of Excel, one step at a time. I'm here to share the exploration of Excel's capabilities and help you learn a few things along the way!