Next Live Training Date:

9-13 Feb 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

Accessing the task manager from excel

Accessing the task manager from excel A nice shortcut from @TomUrtis shows a quick way to get access the  Task Manager from Excel. Normally trying to access the Task Manager is a bad sign in Excel, and in fact you can’t do anything … Continue reading

Excel quiz answers- 11 Dec 2014

Excel Quiz Answers Answers for the quiz on our 11 Dec 2014 Newsletter. To subscribe to the newsletter visit the subscribe page. Excel Questions 1)   The biggest risk with linking spreadsheets together is a.   Rows and columns are added/ deleted when … Continue reading

....As an example, the training in VLOOKUP had applicability in differing ways for each employee and they learned then and there how to use it in their own work. They left the training with clear expectations on improvement in their areas of responsibility...

– Benefits of inhouse training- Health and Accident Underwriting Managers

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