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..
Twenty Point Nine Five Ventures Private Limited
Noida
CA Inter
View Details
Interactive Media Pvt Ltd.
New Delhi
CA Inter
View Details
Chirag P Shah & Co. Chartered Accountant
Pune
B.Com
View Details
Naveen Fintech Pvt Ltd
Kolkata
CA Inter
View Details
CCI
Pro
CAclubindia
