How to learn excel functions?

Gayathri (Chartered Accountant) (286 Points)

03 June 2011  

Which is the best way to learn Excel functions? These functions appear very difficult to follow & remember. For instance, I was going thru a youtube tutorial, where I found the following function:


The function was well explained, I also understood it thoroughly. But How to remember the sequence of commands & remember thousands of functions & commands.

Whether it has to come only thru experience, or else is there any easy way to learn them?