Microsoft recently unveiled formula suggestions and formula by example, both of which could assist in automating tasks that formerly required manual labour.
The idea behind formula suggestions is very straightforward: whenever you enter the equals sign in a cell, Excel for Web will attempt to propose an appropriate formula based on the data nearby.
[Via]
