Friday, 23 November 2012

Forecast Function - Excel

Forecast future values based on historic trends
             =FORECAST(x,known Ys,known Xs)

E.G. = FORECAST(future date, known sales, known dates)
             =FORECAST(A12,$B$2:$B$11,$A$2:$A$11)




Sunday, 4 November 2012

Calculate Largest Number(s) - Excel

Type =LARGE(range,#)

# = #th largest number in the range. E.G to determine the 2nd largest number enter 2:

Type =large(range,2)

Saturday, 3 November 2012

Calculate Maximum Number - Excel

Type =MAX(range)

To calculate the maximum number from a range.