Next Live Training Date:

13-17 April 2015 (JHB)

World Cup 2014 spreadsheet

World Cup 2014 spreadsheet

RelatedHave you tried the English Premier League Spreadsheet?

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.

Premium Version

Enhancements include:

>>>DOWNLOAD > Brazil Soccer World Cup 2014 spreadsheet  < DOWNLOAD <<<

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

Handy Tips & Tricks

Rearrange Columns in Excel

Rearrange Columns in Excel A recent query involved how to rearrange columns in Excel into a specific order. In this case it involved a weekly download from SalesForce and a requirement to (easily) move the columns around into a specific … Continue reading

Excel IF date greater than

Excel IF date greater than A common check required in business is if date greater than another date say yes otherwise no or something along those lines (overdue/ current etc). This is easily achieved with the IF function. What people … Continue reading

It was most interesting and filled with very useful and relevant tricks and tools that one can start to use immediately. The course was well constructed with a logical flow to be able to reference information easily in the take home materials, with exercises covering many different scenarios.

– Hyatt Hotels

Video Library & Tutorials //

View Entire Video Gallery ››

Tables in Excel for PowerPivot use

Tables in Excel for PowerPivot use

Excel see formula instead of value 2013

Excel see formula instead of value 2013

Excel Quick Sum 2013

Excel Quick Sum 2013

Excel Group Rows 2013

Excel Group Rows 2013

Some of our Featured Clients