2010 soccer world cup spreadsheets - financial assistance spreadsheets

World Soccer Spreadsheets (PSL and English Premier League- see below)

The World Cup is done and Spain are the champions. Poor England. If only FIFA would use technology it could have been a different story.

In South Africa the PSL is about to kick off. Will Supersport do it again? Will the big boys make a comeback. Kaizer Chiefs for us! Download the PSL spreadsheet here.

For English Premier League fans who want to forget the World Cup and focus on the Premier league, click here for a spreadsheet for the EPL 2010/ 2011 season . The completed Word Cup Spreadsheet is still available below.

Try and predict the scores in our EPL or PSL spreadsheets. As the matches are finished you can update for the actual scores and then see what the knockout stages may look like. Might help with the planning for your ticket purchases (contact Monique for help) or perhaps you are betting on the league positions?

Feel free to download and tell others about the page. If you find any errors please contact us at info@AuditExcel.co.za . Come back often to get the updated versions. If you have any features you want to see included, email us at info@AuditExcel.co.za and tell us what you want.

So nothing is really free. We provide Excel training both in South Africa and Internationally. See what we offer on the Live Excel Training page . If you are from other countries, learn Excel online at www.AuditExcel.com

DOWNLOAD WORLD CUP SPREADSHEET v 6 for Computers (doesn't work on mobile phones)

This version will warn you if the scores you have chosen result in a dead heat in the group stages at which stage a coin toss (or in this case our calculation) decides the rankings. You may need to change some of your scores to get a more accurate ranking.

See version 9 for Excel Mobile friendly version below-

LEARN HOW TO DO THIS YOURSELF WITH ONLINE EXCEL TRAINING- www.AuditExcel.com

DOWNLOAD 2010 WORLD CUP MOBILE SPREADSHEET v 9 for mobile phones (works on both computers and mobiles)

This is a very new version to accommodate Excel Mobile which has less functions than the full version of Excel. It works on our HTC phones, but please tell us if it works on your version of Excel Mobile. If you are using the full version of Excel rather download version 6 at the top of this page.

LEARN HOW TO DO THIS YOURSELF WITH ONLINE EXCEL TRAINING- www.AuditExcel.com

Good luck to all the teams playing in the various leagues especially Manchester United and Chelsea in England, Real Madrid and Barcelona in Spain and Inter Milan in Italy.

We plan to create a similar spreadsheet for the English Premier league this year as well as for the Super 14 Rugby and World Cup Rugby for next year. All feedback appreciated.

PS- below are some ideas on how you could create these spreadsheet. This training is also useful for any other sporting events e.g. rugby spreadsheets.

Be aware that these video clips use Flash. Click on the hyperlink and, depending on your connection speed, you may need to wait a few moments.

Title

Price

Video Clip
(Windows Media Player)

Automatic sorting of a list
A clever way to have your soccer or football league tables automatically sort themselves based on the most recent results (with no macros!!).

In order to get this to work you need to know about the VLOOKUP and RANK functions which are shown below.

FREE

Automatic Sort

(5 min)

RANK Information

Rank
The Rank function allows you to rank a selection of cells in ascending or descending order automatically. Easier than using complex IF functions to achieve the same goal. Particularly useful for sporting spreadsheets where you want to automatically know the placing after entering the results.

FREE

Rank
(5 min)

VLOOKUP Information

VLOOKUP
Learn how to use the VLOOKUP function in Microsoft Excel. The VLOOKUP functions enables you to pull through various bits of information based on some reference point. So for the sporting spreadsheet once you know the order of the teams, you can pull through all the other relevant information e.g. wins, losses, draws, goals for and goals against.

FREE

VLOOKUP Basics
(7 min)

Handling Large VLOOKUP tables
Once you have mastered VLOOKUP you may find that you use it for large datasets. The problem is that when you make changes to your spreadsheet you sometimes need to go through all the VLOOKUP cells and change the column reference. Learn how to avoid this!

FREE

VLOOKUP Column reference issues
(6 min)

Typical errors made when using VLOOKUP
As useful as the VLOOKUP function is, there is a significant risk of errors. Learn what you must watch for.

FREE

VLOOKUP errors
(5 min)

Quote of the page: Some people think football is a matter of life and death....I can assure them it is much more serious than that- Bill Shankly

Spreadsheet Professional is the world's favorite auditing add in. Find out more on the Spreadsheet Professional pages!!

Do you like what you see. Tell your friends. If you have a training co-ordinator at your organisation tell them that there is free excel training available at this site.

Don't like what you see. Tell us at training@AuditExcel.co.za .

Do you have suggestions of what you would like to see. Tell us at training@AuditExcel.co.za .