Excel Formulas and Functions You NEED to KNOW!

Поділитися
Вставка
  • Опубліковано 13 жов 2024

КОМЕНТАРІ • 322

  • @LeilaGharani
    @LeilaGharani  8 місяців тому +5

    Grab the file I used in the video from here 👉 pages.xelplus.com/formulas-functions-file

  • @Jycatgc6282
    @Jycatgc6282 6 місяців тому +9

    Finally found a person like you willing to share your information in English Captions cuz sometimes other people who made their own videos, they never even made their videos in English Captions. Bummer! Why did I say that? Reason is because I am DEAF & I truly believe that through captioning, there’s something to learn for the DEAF community.
    Thank you! You deserve an award for that❣️ Keep up the awesome work‼️

  • @iDelta77
    @iDelta77 2 роки тому +14

    This lady actually talks in a language that i can understand. Now I can actually start learning

  • @PoeticJusticeSC
    @PoeticJusticeSC 3 роки тому +65

    Having watched some of your more advanced videos this feels like a doctor kindly explaining how to apply a band-aid. It's nice to see you explain basic concepts as well as you explain the complex ones. Definitely worth subscribing.

  • @phantompawn
    @phantompawn 2 роки тому +10

    Thank you so much for not only showing the functions, but also how to self-educate within the program. Knowing how to explore through the program to feel more comfortable within it is a godsend.

  • @tiffanyrollinscannon3568
    @tiffanyrollinscannon3568 2 роки тому +22

    I cannot explain how simply and beautifully you break down information -- from the most foreign, to the most basic -- you somehow still seem to make things much more understandable and less intimidating than your viewers thought possible. I could not hit subscribe fast enough! Professor Gharani is definitely one of THE top professors at "UA-cam University"! lol. Hands down!

  • @derranstokes8760
    @derranstokes8760 3 роки тому +4

    Thanks Leila - A very experienced Excel user, who has forgotten the basics and grateful to be reminded of the basics and alternatives.

  • @petermoorhouse5994
    @petermoorhouse5994 3 роки тому +12

    Value the way you are mixing basic, revision for some, and advanced together with a prank or two, I really appreciate your channel

  • @djjammindave
    @djjammindave 3 роки тому

    I JUST STARTED WORKING WITH EXCEL ON THE FIELD. OUR SPREAD SHEETS ARE A COMBINATION OF NUMBERS AND TEXT. I'M NOT FAMILIAR WITH EXCEL, BUT LOOKING FORWARD TO LEARN THE BASICS WITH YOU. I'VE BEEN A SUBSCRIBER FOR YEARS NOW, BUT I NEVER REALLY SPEND TO MUCH TIME STUDYING THESE COURSES. THANK YOU FOR SHARING YOUR KNOWLEDGE...

  • @andrewmoss6449
    @andrewmoss6449 3 роки тому +109

    Good to see the Excel rookies are not being neglected.

  • @2JSinc
    @2JSinc 3 роки тому +13

    Hello everyone, just want to say that this is the best channel for learning excel / sheets for beginners to advance users, the way she teaches things is very simple to follow, she has that gift of teaching and explaining things easily... thank you Gorgeous Ms. Leila...

    • @djjammindave
      @djjammindave 3 роки тому +2

      I GOT IT (GIFT)

    • @2JSinc
      @2JSinc 3 роки тому

      @@djjammindave thanks for noticing...

  • @TBUniversalGroup.
    @TBUniversalGroup. 3 місяці тому

    Thank you for sharing how to use excel and formulas and functions to get the numbers necessary when adding and subtracting numbers.

  • @Mohamed-yq4fj
    @Mohamed-yq4fj 4 місяці тому

    Thank you for the simple and coherent way of explaining.

  • @roselinembonu2192
    @roselinembonu2192 6 місяців тому

    Leila Gharani, you are the best I have ever seen on this field! Thank you for your simplicity and excellent presentations! Now I can learn Excel!

  • @kemiesan1908
    @kemiesan1908 2 роки тому +2

    I love your video, it is so easy to follow. Thank you, in just one night I have been able to boost my confidence

  • @ProfreshionalLifeBeyond
    @ProfreshionalLifeBeyond 2 роки тому +2

    Thank you for your video with clear and simple instructions. I am touching up on Excel and I really appreciate your teaching methods. Best wishes from beautiful autumn Melbourne Australia.

  • @wazmink2459
    @wazmink2459 Рік тому

    Good that I found this vlog, now I'm able to see how to solve complex function.

  • @excelismagical-shakeel4793
    @excelismagical-shakeel4793 3 роки тому +4

    With so many advanced videos of yours, Nice to see a basic formula one for the fresher's...
    Honestly you are an inspiration for me to start an UA-cam channel of my own in Excel recently...
    I need wishes from genius like you for the success

  • @tliani1494
    @tliani1494 Рік тому

    clear explaination.. I tried several time but I still found it challenging about the formulas. Now, you really help me.

  • @islandcactus1508
    @islandcactus1508 3 роки тому +7

    Brilliant stuff! Us Mac users still don’t have quick analysis so manually learning Min / Max is necessary. Lets get this girl to a Mil sub!

  • @henryifeanyi2181
    @henryifeanyi2181 11 місяців тому +1

    I learnt something the advance tutorials never touch on, the Function icon and how useful it can be. Thanks

  • @steveplyler8077
    @steveplyler8077 8 місяців тому

    Well done, easy to follow, no wasted time as you covered most options to apply to normal business. Thanks

  • @juditedsouza8369
    @juditedsouza8369 Рік тому

    You made it look so easy and you have such a pleasant voice. Thank you.

  • @Alexthefrench1
    @Alexthefrench1 3 роки тому +4

    The way you teach is.. EXCELente!! You make everything sound so easy to learn. Love from Portugal

  • @lynnjohnson3669
    @lynnjohnson3669 9 місяців тому

    Wow, just found your video. Thanks for explaining Excel formulas in such a simple and easy way to understand. Thank you. I will be watching more of your talks.

  • @ironempath7261
    @ironempath7261 2 роки тому

    Thank you.
    Easy to follow, and lovely office furniture set up.

  • @dfsupport
    @dfsupport Рік тому +1

    So much to learn! I practice all of these formulas as I go through your videos, Leila. I ran into an issue when using the =COUNTA formula. I had 10 names in my list but the formula was giving me $10.00 instead of 10. All my names were formatted as text but the cell that I inserted the formula in was formatted as currency! Silly mistake but I learned a lot because I was deep into the research. Thanks for another great video!

  • @simbarashemakwedza1640
    @simbarashemakwedza1640 8 місяців тому

    Thanks, Leila, for making me understand the concept.

  • @Lodgeitude
    @Lodgeitude 3 роки тому +2

    Always making videos easy to understand. Thanks a lot.

  • @paulussantosowidjaja93
    @paulussantosowidjaja93 2 роки тому

    learning is for a life time while still alive, I subscribe. Cheers,Leila.

  • @stevengarcia1719
    @stevengarcia1719 2 роки тому

    By far the most detailed explanation, that is understandable and will not make you go to sleep.

  • @chh8860
    @chh8860 3 роки тому +2

    Possibly the 'only' Leila video that I could follow from beginning to end and understand each topic without replaying (and replaying again) different segments. But Alt=Sum ... that was new to me ... HA! ... always something new to learn.
    PS
    Still marvel at the effortless delivery ... so well done.

    • @LeilaGharani
      @LeilaGharani  3 роки тому

      Well, at least there was something new for you in there. Not sure about the effortless part though. Sometimes it takes a lot of takes :)

    • @chh8860
      @chh8860 3 роки тому

      " ... Sometimes it takes a lot of takes ..."
      My Mom used to say "Fred Astaire and Ginger Rogers made their dancing look so easy ... because they worked so hard". You make it 'look' easy ... but I have no doubt there is a lot of preparation ... but your delivery 'appears' effortless ... a great skill (IMHO)

  • @kaisykaisy
    @kaisykaisy 2 роки тому

    This video or lesson is very important to start in Excel formulas. My best regards to Ms. Leila

  • @veronicarizescu1364
    @veronicarizescu1364 3 роки тому +3

    Thank you for the simple and coherent way of explaining. Wish I had teachers like you when I was in school.

  • @normanbayvel8727
    @normanbayvel8727 2 роки тому

    Listened to u for the 1st time - u explain brilliantly and remove the fear aspect of starting Excell

  • @yinyin6998
    @yinyin6998 2 роки тому

    Thanks teacher...it's helpful a lot for beginner.

  • @roxannelewis5129
    @roxannelewis5129 2 роки тому

    STARTING A NEW JOB TOMORROW AS A MARKETING ADMINISTRATOR AND THESE ARE CRAZY HELPFUL TO NEWBIES

    • @LeilaGharani
      @LeilaGharani  2 роки тому

      Glad to hear that. Good luck with the new job!

  • @margarettodd1074
    @margarettodd1074 6 місяців тому

    Clear and concise bravo at last I can learn how to use this, speaks slowly and explains the format perfectly for a total beginner 🥳👏🩷🩷🩷🙋‍♀️ I shall subscribe and send a thank you

    • @LeilaGharani
      @LeilaGharani  6 місяців тому

      Great to hear! Happy to have you aboard :)

  • @5sbarokah336
    @5sbarokah336 3 роки тому +1

    Thanks for your video, it help me adding a knowledge of excell function.

  • @Chrissanthumum
    @Chrissanthumum 6 місяців тому

    That was an epic,nicely explained video.I am familiar with Excel,but I did not know how to do one or two.I subscribed.

  • @claramumba9124
    @claramumba9124 2 роки тому

    Your presentation is passionate and easy to grasp I will teach with patience like you

  • @sachinrv1
    @sachinrv1 3 роки тому +8

    Nice to see the basics. Even after using excel for so many years, sometimes I still find that function argument box very useful especially when using complex integration, as one can get inside the formula to ensure that it is heading in the right direction. One simple trick, while using function argument box is, you can press F2 to select cells or range of cells while you build formula. Using a mouse is coward man's work. LOL. Thanks Leila. Cheers :)

    • @LeilaGharani
      @LeilaGharani  3 роки тому

      Haha, I like that 😂 Thanks Sachin!

  • @SavageGothamChess
    @SavageGothamChess 3 роки тому +3

    Thanx. Amazing video Leila. I am in formula but this video helped me alot. Great video.

  • @wayneedmondson1065
    @wayneedmondson1065 3 роки тому

    Thanks Leila. Always a pleasure to watch your videos. Thanks for sharing! Thumbs up!!

  • @d.g.1986
    @d.g.1986 10 місяців тому

    Very helpful! Thank you for your channel

  • @SDEXCELArt
    @SDEXCELArt 3 роки тому

    waoooo... there are people who dislike also.... Strange! Fantastic work.. I wish channel like these were there when we started using Excel, it could have been so easy.......Good work........I use Excel vividly... Off late I surprised myself and started using Excel for ART... Any feedback will be hugely appreciated....I don't intend to misuse this comment section... cheers

  • @CandaceJDunkley
    @CandaceJDunkley Рік тому

    This was very helpful. Thank you!

  • @cybertaiga9534
    @cybertaiga9534 2 роки тому

    Extremely wonderful explanation and demonstration. I am truly grateful to you, Leila Gharani.

  • @glisdidee
    @glisdidee 2 роки тому

    Thank you so much for making excel easy for me to understand as I have always been not confident using it.

  • @gtclicks
    @gtclicks Рік тому

    Leila inspires me to keep posting Excel videos every time I watch her videos.

  • @Garce227
    @Garce227 3 роки тому +1

    Excel for Financial Advisers would be a great help!

  • @farhanasheoraj8843
    @farhanasheoraj8843 2 роки тому +5

    Love the videos, always professionally presented and easy to understand, great job. Keep it up.

  • @mrkhalidhafeth5823
    @mrkhalidhafeth5823 3 роки тому

    I really appreciate your method of demonstrating these basics.

  • @azizurkhan1153
    @azizurkhan1153 2 роки тому

    Excellent vedio presentation.
    You explain details and tone is very pleasant. Easy to understand. Great vedio.

  • @agh6452
    @agh6452 Рік тому

    Excellent teaching shot, please have video on how to count the same text in cell with different text

  • @stacesprinkle7822
    @stacesprinkle7822 Рік тому

    (As someone who says, “ of course I can do excel” on my resume, 😊I love these videos! Subscribed!

  • @ShubhamMathur14
    @ShubhamMathur14 3 роки тому

    Always enjoy learning from you

  • @RA-rh5lb
    @RA-rh5lb Рік тому

    I liked average ifs which I never used. good information. thanks

  • @randhib5918
    @randhib5918 2 роки тому

    Wow. Been following you for some time. Thank you.

  • @dimanthagamage9895
    @dimanthagamage9895 2 роки тому

    Thanks for letting us know very useful features of excel. ♥️

  • @dennissaji
    @dennissaji 3 роки тому

    I had made a template with the help of your videos to calculate monthly mess account in my organization. Thanks

  • @arezou9520
    @arezou9520 2 роки тому +1

    You are the simply AMAZING, Leila :)

  • @vintageguitarz1
    @vintageguitarz1 2 роки тому

    I learn best when the hot teacher is sitting on my lap. Great presentation, clear and concise, and you keep my attention.

  • @arindambasu8343
    @arindambasu8343 2 роки тому

    Hi Leila, Undoubtedly. it is a highly helpful video. Thank you.

  • @markdavies-ei8sf
    @markdavies-ei8sf 10 місяців тому

    Powerful, thank you.

  • @deannewton3534
    @deannewton3534 4 місяці тому

    @LeilaGharani I appreciate the explanation of your knowledge. Thank You

  • @cuda8538
    @cuda8538 2 роки тому

    Great tutorial! I your explanation of the insert function and autosum in specific. I haven't seen a video of those explained this well.

  • @jocky1027
    @jocky1027 3 роки тому +2

    What a fantastic video, so well put together and explained. Thank you so very much, I will be watching the rest of your videos to get me up to speed with Excel

  • @irwankurniawan1737
    @irwankurniawan1737 3 роки тому

    Thank you. I use your video as the starting point for my kid entering the spreadsheet world. Awesome!

  • @niudartakh2058
    @niudartakh2058 2 роки тому

    Thank you. This video is very useful.

  • @suleimanshaik
    @suleimanshaik 3 роки тому

    I am a fan of your videos and the presentation style. Thanks, as I'm learning so much.

  • @Galileo2pi
    @Galileo2pi 3 роки тому +4

    Leila, as always, brilliant.

  • @furious-choehaalen1525
    @furious-choehaalen1525 3 роки тому +1

    Thank for tips teacher😊

  • @amraref9116
    @amraref9116 2 роки тому

    I'm very happy to listening to you

  • @consistentlylearning6895
    @consistentlylearning6895 2 роки тому

    great video, I think i learned enough to have a great start on excel

  • @queenbodicea
    @queenbodicea 3 роки тому

    Brilliant. That was very helpful and you were easy to follow.

  • @FarhanMerchant
    @FarhanMerchant 3 роки тому

    Simple yet good insights into getting started ; Thanx

  • @kalaisa79
    @kalaisa79 Рік тому

    Well! Whereas, the video was fantastic by-the-way! Thank you, bro!

  • @peterm6081
    @peterm6081 2 роки тому

    I am very new to excel and I loved the way you explain information needed to navigate excel. I will have to practice what I seen from you and will definitely be spending a lot of time on your channel. Thank you!

  • @tha2irtalib343
    @tha2irtalib343 3 роки тому +1

    Great gob , I can hit thumbs up even before watching, thanks for sharing .

  • @olgakukh9512
    @olgakukh9512 2 роки тому

    You are amazing! this is a great help and clear explanation))) Thanks a lot for your work!)))

  • @kondehyirah292
    @kondehyirah292 Рік тому

    Thank u so much am very very greatfull, i always love your lecture thank u.❤❤❤❤❤❤❤❤❤❤❤

  • @AlexAlex-pi4hh
    @AlexAlex-pi4hh 3 місяці тому

    Thank you very much for sharing.

  • @kurmaraoguggilapu3879
    @kurmaraoguggilapu3879 Рік тому

    Nice tutoring..no need to go institute for learning ..thank you so much mam..

  • @vijayarjunwadkar
    @vijayarjunwadkar 3 роки тому +2

    I never used the Function Arguments Box, although I was aware, but looking at it's utility, I am going to use it now, while exploring new functions especially. Thanks for this tip. Whether "basics" or "advanced", we can rely on Leila for everything Excel! Stay blessed! 😊👍

    • @LeilaGharani
      @LeilaGharani  3 роки тому +1

      Yes, it's a great way to getting to know new functions. Thanks for watching even my basic videos!

  • @shakil1075
    @shakil1075 Рік тому

    Hi, your way of explaining is amazing. I liked that. Would you please upload the video on Qualtrics for beginners!!!

  • @WafiAljunaedi
    @WafiAljunaedi 3 роки тому

    you are an Excel hero, i really got a lot of benefits from your explanation , i mean form the advanced videos😄 , even though i've more than 15 years experience in IT failed 🌹🌹

  • @kettymulenga6710
    @kettymulenga6710 2 роки тому

    Literally had no idea...all thanks to you

  • @umeshb-z9l
    @umeshb-z9l Рік тому

    Hi .. your videos are awesome & very much useful.. I need to know weather we can automate the sheet.. if I need to get the Bill of Material direclty by just putting the size of the product..

  • @shariffmigaliza7789
    @shariffmigaliza7789 2 роки тому

    i like your breakdown its fantastic

  • @mensahemmanuel3814
    @mensahemmanuel3814 Рік тому

    very nice and easy way of doing that operations. wow.

  • @LOISLANE99999
    @LOISLANE99999 Рік тому

    thats very helpful. good video! i learned alot!

  • @JitenderSingh-hg8wl
    @JitenderSingh-hg8wl 2 роки тому

    Nice video. Thanks.

  • @ThérèseNgoNdebi-b1n
    @ThérèseNgoNdebi-b1n Рік тому

    wow i have been searching for this will love to watch more videos

  • @VIJER47
    @VIJER47 3 роки тому

    Nice video for us rookies. Thanks.

  • @EXCELWORLD-ez8xy
    @EXCELWORLD-ez8xy 8 місяців тому

    nice teaching leila,

  • @Nkie-gi8yg
    @Nkie-gi8yg Рік тому

    I really appreciate you for your help

  • @PranveraKrasniqi
    @PranveraKrasniqi 3 роки тому +1

    Thank you very practical

  • @ykrakesh1984
    @ykrakesh1984 2 роки тому +1

    Totally enjoyed watching your video, superb demonstration and totally worth for me as I was also looking for tips/knowledge on how and where in Excel!! Thank you for making such great videos...A great help for beginners like me :)

  • @wallyortizjr71
    @wallyortizjr71 2 роки тому

    You are awesome thank you for this video