Is there any way to apply random values to cells within Excel?

ddrap14 

I will assume you are familiar with the RAND function.  So you want formulas to derive a random number for each team, but retain that value in a cell until you explicitly reset it (without having to change the formula, of course).  So if this is the upper left part of your worksheet (i.e., team names in column A):

The formula I put in cell B2 computes a (linear-distribution) random number from 60 to 100, rounded to the first decimal place, but only if the content of cell A1 is "RESET":

=IF( $A$1="RESET", ROUND(60+RAND()*40,1), B2 )

(Depending on your region settings, your syntax might require semicolons instead of commas as the list separators.)  Copy that formula down for each team in the list.  Then, change "Premier League" to "reset", (do a manual recalculation of formula values, if you don't have automatic recalculation on,) and then change it back.  And for the start of each year, make that pair of changes again to cell A1 to generate new random values.

You can of course choose some cell other than A1.  You may want to add a reminder note to A1/the cell that you choose, and/or more explicit documentation elsewhere in the workbook.

(This is one of the few instances when you want a formula that refers to the cell in which it is located.)