@Sparqcorporatetraining
As a computer trainer for over 30 years, I'd have to say you are by far the best online video tutorial creator that's on YouTube. Every single one of your videos is very clear and easy to understand and the fact that you provide the files for people to use/practice with makes your videos truly exceptional. Thank you!
@jackbmeere5367
Thank you Leila, I have watched other people's Excel Video's but tend to get lost in the technical jargon, however, since I found your video's, I am soaring ahead due to your no nonsense, easy to learn approach to each and every part of the exercise, and they guarantee success every time. I won't watch anyone else's video's anymore because your video lectures are easily miles ahead of the field and as a consequence I have now subscribed and will recommend you to all my family and friends.
@jimp7181
As an instructor myself, I appreciate your skills. This video and the several others I have watched cover the material efficiently, without breaking the material down to a painfully basic level. There is no magic amount of detail for every audience as their diverse skill set is the uncontrollable variable, but you are nailing it for my needs. Thank you, and keep them coming!
@apsleychenstra4221
I am a senior Excel user transferred from Lotus 1-2-3 for over 30 years, now a retiree. Nested IF was my headache to write a lengthy and complex formula. It’s very hard to debug or modify when the conditions changed. Hence, I used an alternative way to solve this headache. I split the nested if into one to one comparison if formula. If the comparison is true, then give 1 at the same row right to the raw data matrix, else give 0. Therefore, I will get several 1s or 0s in the computing cells. Then, multiply or add the results in the computing cells, AND is equivalent to “multiply” and OR is equivalent to “add”. This will simplify the Nested IF formula and make it easier to be maintained.
@DIgitusSmartas
By far the best and correct tutorial, I have did excel 11 years ago but forgot a lot and many videos ppl use to feed their ego and showing ppl incorrect ways to do it and this is how I remember. Being taught at Tafe. Full formula no shortcuts no fancy ways of explaining. Perfect and to the point. Calm voice, clear instructions and best of clear voice and at perfect tempo. Any faster talk and you could miss half the talk. Awesome
@thomasprais2919
Leila, you have the best Excel tutorials I've found on YouTube. By far. Clear, concise, excellent examples. Thanks so much!
@susans6794
Wow, girl, you are very good. Thank you very much. You explained it very well. You remind me of my maths tutor who taught me maths so well that I passed with an A+ even though I used to suck so badly at maths in the past. Keep the good work, please. The world needs great teachers like you.
@cengizgenc3701
After searching for an hour how to use "if" multiple times: you are the only one come up with this most accurate and proper formula. Thank you so much Leila from the bottom of my heart for this well prepared tutorial.
@nwonyeemmanuel3554
Honestly I have never understand if function like this before even after my Two months class.. God bless you for this wonderful teaching
@bemshamtv7047
Hella Leila Ma, I'm in Africa and have come to fall for your videos just recently. But this particular video, you 've just overwhelmingly captivated me with your flawless presentation. Indeed, you are a gift to humanity. On a lighter side, please any time you are in Africa, I will gift you a beautifully sculpted African calabash as my humble show of appreciation.❤👍
@Brukn0ws
Since discovering your channel I've improved my excel skills by a loooot. Thank you!
@vanthadoun1
Excel is one of those programs where most people have a basic knowledge, and most people just assume you know how to use, I had a coworker who had a background in Accounting, and she could run laps around me in Excel and I was just scratching my head and asking "could you do it one more time, but slower?" having Leila explain it makes it so much easier to learn. I wish there were more people like Leila who are willing to help out in Excel.
@pratirup9829
Hi Leila Your explanations and exolaining technique is brilliant. A real nice work. Keep up the fabulous job. It is really helpful for so many users like me. Thanks again for the brilliant explanation.
@samirbitar806
Thank you! After two days of googling and youtubing, you're the first person/video to make sense of nested IF forumulae. please post more of the more complicated nested IF/AND/OR, etc statements. you're a natural teacher.
@mushthepig
This is 1000x better than a course I paid for. I'm glad I found you on YouTube and I've subscribed. Thanks so much!
@rashawnjones793
I just got my associates and working towards my cs bachelor's. I have been importing excel sheets into mysql because i was unaware you could use elif statements in excel. This saves so much time and makes it easier to cleanse and organize. Best randomly suggested video ive ever watched.
@chrisp5818
You present information in a polished but not over-produced way. It's less like teaching ideas and concepts and more like a confident professional passing on information to peers conversationally. You have a great combination of skills and attributes that allows the viewer engage almost like you are speaking with them personally. I'm subscribed, thank you.
@masiel2010
¡Gracias!
@billandrews7870
Besides learning how to correctly use conditional functions in formulas, I learned how to structure my table of requirements. Once I followed your table structure, the logic easily fell into place. Thank you and may God's face shine on you...
@LeilaGharani