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. 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!

2. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'



2014/ 2015 Bundesliga predictions

2014/ 2015 Bundesliga predictions

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

2015-bundesliga-predictionsWe have created a 2015 Budesliga predictions spreadsheet to use in an office pool or sweepstakes. So now you can document everyone’s opinions at the beginning of the season and then refer back to them at the end of season and they won’t be able to change their minds.

Will Bayern Munich walk it again or can one of the others come back and challenge?

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. Bayern Munich, Borussia Dortmund, Schalke and Leverkusen) 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.