Gayathri (Chartered Accountant) (286 Points)
03 June 2011Which 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:
=IF(ISBLANK(B10),"-",VLOOKUP(B10,GRADES,2))
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?
pavankumarcma
(B.Com ICWAI (CA FINAL) SAP Consultant)
(147 Points)
Replied 03 June 2011
hi,
1, Don't Try to remember the functions.
2, Use Alt button, then the items in the menu bar will get highlighted and keep scroll to get your function.
Don't worry, It is only by practice,try to learn 5 new functions daily and reuse the same when situation demands.
You will be a master in excel.
Praneshx
(NA)
(21 Points)
Replied 08 August 2012
Hi,
This isblank function is used to find the given cell is empty or not.. i think the following link give you a better solution.
https://www.hscripttts.com/tutorials/excel2007/isblank-function.html
It will help you to remember the concept..
Live class on PF & ESI Enrollment & Returns Filing(with recording)
CAclubindia
