For the Brazil Soccer World Cup 2014 we have prepared our World Cup 2014 spreadsheet for download (in related news England to win the world cup according to excel)
Note: If you are here because the spreadsheet mentioned an update, please email adrian@AuditExcel.co.za for details and free update
Below is a video clip on how to use it to run an office pool or sweepstakes.
Much like the other spreadsheets we have built for sporting events ( AFCON 2013, Super Rugby Spreadsheet), the spreadsheet gives you the ability to enter your group stage results and predict the likely knock-out matches (without any VBA macros!).
In this one we have also included the teams FIFA rankings so that you can assess the head to head rankings as we get closer to the finals. Also, keep an eye on the top right corner which will tell you if an updated version is available. The spreadsheet is built in Microsoft Excel 2013 but will work in all versions with some loss of functionality if you are using Excel 2003.
We wish all the African teams best of luck and hope that one or more of Algeria, Cameroon, Côte d’Ivoire, Ghana, or Nigeria can do us proud.
Based on some initial scores we think the last sixteen will look like this
Brazil v Netherlands
Colombia v Italy
Spain v Croatia
Uruguay v Côte d’Ivoire
France v Bosnia-Herzegovina
Germany v Russia
Argentina v Ecuador
Belgium v Portugal
Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
It is exceptionally easy to link Excel spreadsheet together. However. sometimes you want to find these external links in Excel. Not only the link, but also which cells in Excel are using these links. This could be so that you … Continue reading
For the upcoming Advanced Excel Course in Cape Town, we can confirm that the venue is going to be the Rockwell Hotel. The venue has rooms as well so if you need accommodation while on the course, they can arrange it. … Continue reading
Your (AuditExcel) Advance Excel and Financial Modeling course is one of the best courses available on the market, it is well structured, relevant and insightful. I will recommend it to anyone who would like to improve his/her Excel and/or Financial Modeling skills.– Namibia