Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!


2015 premier league predictions

2015 premier league predictions Excel spreadsheet

2015-premier-league-predictionsWe have created a 2015 Premier League predictions spreadsheet to use in an office pool or sweepstakes. So when the know-it-all claims that they can predict who will win what you can get them to put there money where their mouth is.


Update: See all our latest fun office pool sweepstake spreadsheets for sporting events


Do you think Manchester United will recovery or will Manchester City win again. Will Chelsea be the one to beat or have Arsenal finally got it right? What about a Liverpool without their bite! Now you can document everyone’s opinions and see who actually knows what they are talking about.

Using some clever Excel techniques we have made it possible to run a sweepstakes where people can make there predictions (easily) and then sit back and watch the results roll in.

To avoid the problem of people not wanting to enter all the results we have included a ‘Guess the Rest’ feature. So you can predict the results for the matches of your favourite teams (e.g. Manchester United, Liverpool, Chelsea and Manchester City) match by match. Then you can rank the┬áteams and specify what the benefit of each team playing at home is. Then, using Excel’s RANDBETWEEN function you can guess the rest of the results and choose the final league table that makes most sense to you (watch the video clip to see how this works).

Once you have your specific predictions and the ‘Guess the Rest’ predictions you can go back and change the predictions with a Hyperlink that takes you to the correct spot.

The organiser of the spreadsheet has a master file that makes it easier to update the results and see who is leading the sweepstakes.