The simplest way to start documenting Excel formulas like a coder is by using the N () function. Although its primary job is to convert non-numeric values into numbers, it has a hidden quirk: because ...

By dividing (/) the running total by the sequence number, Excel returns the average of all the values from the start to the ...

In 12 years since the Scot retired the club have spent more than £2bn on players – here our experts assess them all ...