by
Kashif Ashfaque , Manager Financial Planning & Analysis , Al Ajlan Group (Pure Beverage Company)
depends on the use, for accountants following should be known
1- all arithmetic
2- logic (if, sumif, sumifs)
3- search (lookup with all variants)
4- reporting (pivot report)
5- presentation (graphs)
6- data management (tables, scenarios etc)