[FREE Excel Course] Lesson 9 - Excel Formula Basics

แชร์
ฝัง
  • เผยแพร่เมื่อ 27 มิ.ย. 2024
  • In this video of this Free Excel Training, you will learn how to get started with Excel formulas.
    This video covers the following topics:
    -- Constituents of Excel formula
    -- Operators in formulas
    -- Entering a formula in Excel
    -- Editing a formula
    -- Absolute/relative cell references
    -- Copying/pasting formulas in Excel, and
    -- Formula auditing and debugging.
    ☕ If you're the videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
    This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
    You can find more details about this Free Excel Training + the download files here: trumpexcel.com/learn-excel/
    You can also access the Full Excel Training on TH-cam here: • Getting Started with E...
    Free Excel Course - trumpexcel.com/learn-excel/
    Paid Online Training - trumpexcel.com/excel-training/
    Best Excel Books: trumpexcel.com/best-excel-books/
    ⚙️ Gear I Recommend:
    Camera - amzn.to/3bmHko7
    Screen Recorder - techsmith.z6rjha.net/26D9Q
    USB Mic - amzn.to/2uzhVHd
    Wireless Mic: amzn.to/3blQ8uk
    Lighting - amzn.to/2uxOxRv
    Subscribe to get awesome Excel Tips every week: th-cam.com/users/trumpexc...
    Note: Some of these links here are affiliate links!
    #Excel #ExcelTips #ExcelTutorial

ความคิดเห็น • 40

  • @yousifabdulla9913
    @yousifabdulla9913 4 ปีที่แล้ว +45

    I cannot thank you enough Sumit for sharing your great effort for free!

  • @matteobiancardi9581
    @matteobiancardi9581 ปีที่แล้ว +4

    The best Excel tutorial I have found on TH-cam, while the others are too slow and usually not too deep. Great job!

  • @wayneedmondson1065
    @wayneedmondson1065 5 ปีที่แล้ว +14

    Hi Sumit.. thanks for this video. Good review of operators, order of operations, editing abs/rel ref and audit/debugging. Thanks for sharing this series for free. Thumbs up!

  • @RamS-yc7xv
    @RamS-yc7xv 4 ปีที่แล้ว +6

    thanks a lot sumit sir...I am a student going to class 11 and I thought I could spend this lockdown in a useful way by learning excel...and your videos are so useful.

  • @amiraboodi2075
    @amiraboodi2075 2 ปีที่แล้ว

    the topic of "relative, absolute, and mixed referencing" was new for me. also, auditing and debugging formulas are very helpful. thank you very much. I enjoyed it a lot.

  • @seenu99250
    @seenu99250 24 วันที่ผ่านมา

    Thanks a lot sir. Great work ...

  • @user-nd3id7bc1l
    @user-nd3id7bc1l 5 หลายเดือนก่อน

    Thanks Sumit for an insightful session. I came to know order of precedence first time and it really helps my concepts in excel. Keep inspiring and keep sharing more such tricks for excel.

  • @VarunGoyal777
    @VarunGoyal777 3 ปีที่แล้ว

    Thanks a lot Sumit. Concepts are explained deeply and so easily by you. Your videos are always clean with no time wasted on any rubbish. I have not found such an excellent course on youtube. I think your videos deserve many more views & likes. Thanks for the effort.

  • @shithila1987
    @shithila1987 3 ปีที่แล้ว

    Thank you for sharing your knowledge. Your explanation and teaching techniques are great and easy to understand.

  • @HalfdecayOfUranium
    @HalfdecayOfUranium 2 ปีที่แล้ว

    Thank you very much! The lesson helped me a lot!

  • @shaitansingh2249
    @shaitansingh2249 4 ปีที่แล้ว +2

    Hi submit your videos are very good .

  • @iliesboukhatem7803
    @iliesboukhatem7803 2 ปีที่แล้ว

    very good explanation, thank you !

  • @bhoopalijoshi8197
    @bhoopalijoshi8197 2 ปีที่แล้ว

    Thank you very much for your channel, your videos and your efforts. The videos are so deep and thoughtful, that one can really become an expert in excel by studying, practicing and applying them. The channel is greatly useful for me, I keep referring to your videos for my daily excel queries. Thanks again!

  • @ahmadshahkabeeri3893
    @ahmadshahkabeeri3893 4 ปีที่แล้ว

    Thanks a million from your great effort for free

  • @mejdihaidy
    @mejdihaidy 3 ปีที่แล้ว

    Awesome, thank you so much!

  • @margad-erdeneboldbaatar4704
    @margad-erdeneboldbaatar4704 2 ปีที่แล้ว

    Thanks for the this course.

  • @stephenebiloma4060
    @stephenebiloma4060 2 ปีที่แล้ว

    Thank you very much for sharing this.

  • @dheerajkushwaha1835
    @dheerajkushwaha1835 2 ปีที่แล้ว

    Thank you sir, 😊 Very easy to understand your English and excel topics

  • @amoln5497
    @amoln5497 4 ปีที่แล้ว

    Excellent tutorial.....

  • @drummersaad
    @drummersaad 4 ปีที่แล้ว +1

    Thank you.

  • @hihimanshuu
    @hihimanshuu 10 หลายเดือนก่อน

    Thank you for sharing it.

  • @sandeepgujar1371
    @sandeepgujar1371 4 ปีที่แล้ว +1

    great man

  • @MuhammadSohaib-qm6iw
    @MuhammadSohaib-qm6iw 11 หลายเดือนก่อน

    Very nice video summit

  • @himi1509
    @himi1509 2 ปีที่แล้ว +1

    Thanks Sir

  • @mohanvaze1
    @mohanvaze1 3 ปีที่แล้ว

    One of the best part so far. Thank you so much. Just one small observation, it seems that "Copying/Pasting formula" is missing in the video. Please check. Best regards

  • @Husshar_Ladka
    @Husshar_Ladka 4 หลายเดือนก่อน

    Nice

  • @shritejchavare4488
    @shritejchavare4488 4 หลายเดือนก่อน

    great video

  • @ozwellmuzinda5047
    @ozwellmuzinda5047 3 ปีที่แล้ว

    Helpful

  • @dominickalmilla989
    @dominickalmilla989 2 ปีที่แล้ว

    thanks!

  • @simuislam5752
    @simuislam5752 2 ปีที่แล้ว

    Thanks

  • @vlogbyheart4993
    @vlogbyheart4993 ปีที่แล้ว

    thank sir

  • @faujiDeepakKumar-fg8vk
    @faujiDeepakKumar-fg8vk 4 ปีที่แล้ว +1

    At 9:00 there ie bodmas rule

  • @bhavikjain088
    @bhavikjain088 4 ปีที่แล้ว +1

    Hi Sumit, thank you for this video but when i press Shift + F3, the insert function box doesn't pops up and i am using Excel 2007

    • @NarenderKumar-jc9cw
      @NarenderKumar-jc9cw 3 ปีที่แล้ว +1

      some command doesnt work in laptop i guess thats y might be

  • @garimachadha6239
    @garimachadha6239 4 ปีที่แล้ว

    Sir pls guide me from where can I download the training file

  • @jaypatil6713
    @jaypatil6713 2 ปีที่แล้ว

    sumit bansal my love

  • @Kashifnasir89
    @Kashifnasir89 3 หลายเดือนก่อน

    I don't think I get this... I haven't had a problem so far but I don't get this

  • @surendramehra4752
    @surendramehra4752 5 ปีที่แล้ว

    Sir aap CA ho