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:
=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?
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.
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..
Naveen Fintech Pvt Ltd
Kolkata
CA Inter
View Details
Gupta Sachdeva & Co. Chartered Accountants
New Delhi
CA Final
View Details
CAclubindia
