30 Advanced Excel Formulas and Functions You Need To Know | Most Useful Excel Formulas

Поделиться
HTML-код
  • Опубликовано: 26 янв 2025

Комментарии • 237

  • @DeepakEduWorld
    @DeepakEduWorld  6 месяцев назад +71

    Toh kaisi lagi ADVANCED FORMULAS ki ye master class dosto ?

  • @anujgesslar2357
    @anujgesslar2357 3 дня назад

    Thank you for such a nice Technique

  • @maheshbisht6286
    @maheshbisht6286 5 месяцев назад +6

    मुझे नहीं लगता इतना बेहतर तरीके से कोई excel formula समझा सकता है । जवाब नहीं गुरु जी । धन्यवाद ।

  • @anumayank6544
    @anumayank6544 6 месяцев назад +15

    YOU TUBE KA PAHLA SABSE EXCELLENT EXCEL VIDEO...
    THANKS....🎉❤

  • @UltraB
    @UltraB 2 месяца назад +3

    आपका Explaination खूब अच्छा है आपने कम समय में one shot में 30 फार्मूला समझा दिया 😊

  • @NobodyXY-NOBODY
    @NobodyXY-NOBODY 3 месяца назад +1

    Must Watch Video. Thank you so much for the Excel Sheet.

  • @ZaidiS-dd8mf
    @ZaidiS-dd8mf 4 месяца назад +2

    Excellent Explanation

  • @AmitKumar-tc3uv
    @AmitKumar-tc3uv 28 дней назад

    Great video sir. Thank you😊😊

  • @Patelson1509
    @Patelson1509 5 месяцев назад +2

    Excellent Workshop by DEEPAK,
    I Learn so much from this video,Generally i know basic Vlookup formula and now due to my job profile change i am thinking to do Advance EXCEL course classes but now after watching this wonderful video i am not going to join any class,
    thank you DEEPAK ji for such a wonderfull work,
    Because of you i saved my money
    god bless you:)
    You are Excel guru

  • @amitpatil6441
    @amitpatil6441 28 дней назад

    Thanks for Educate to People Sir.🙏

  • @vasantkumarkantilal2973
    @vasantkumarkantilal2973 6 месяцев назад +1

    Bahut shandar ❤

  • @mathsbyunknown
    @mathsbyunknown 17 дней назад

    I appreciate your hard work.

  • @thebesttechnical3608
    @thebesttechnical3608 Месяц назад +1

    Thank you so much for this. I have this urge to learn more about Excel!

    • @DeepakEduWorld
      @DeepakEduWorld  Месяц назад

      Keep exploring! Excel has so much to offer. 👍

  • @r.srinivasyadav3057
    @r.srinivasyadav3057 5 месяцев назад +1

    Very good explanation thank you.

  • @vivekkumarsingh7403
    @vivekkumarsingh7403 5 месяцев назад +2

    best video to learn excel formulas in a detailed way with examples

  • @pallavbansal7576
    @pallavbansal7576 4 месяца назад +1

    Thank you so much sir 😊

  • @sanghpalkamble5114
    @sanghpalkamble5114 3 месяца назад +1

    Great 👍

  • @rajashreebhavsar4708
    @rajashreebhavsar4708 4 месяца назад +1

    Very useful video with simple language and sample data

  • @birendrakumar8577
    @birendrakumar8577 4 месяца назад

    ❤ many many thanks 🙏

  • @JayBK-l5h
    @JayBK-l5h 5 месяцев назад +1

    Your are the Great one sir jee

  • @JattSahabJi
    @JattSahabJi 6 месяцев назад +3

    Bhai aapke video se bht aram se sab kuchh samjh aa jata hai 😊bht achhi tara se smjhate ho aap, thanks😊

  • @RahulKumar-wj9qd
    @RahulKumar-wj9qd 5 месяцев назад

    Excellent sir 💯✅✅

  • @amitrelan3795
    @amitrelan3795 5 месяцев назад

    Great Sir❤

  • @saqi1187
    @saqi1187 Месяц назад

    Sir apki videos se e m ne Excel bht learn kya h. Bundle of thanks 🎉❤

  • @PritamDas264
    @PritamDas264 6 месяцев назад +1

    Tank you Sir kya training file banaya hai sir ek dum jabar dast😍

  • @TigerZindaHai-pf2oz
    @TigerZindaHai-pf2oz 6 месяцев назад +1

    Superb se bhi uperb

    • @hareshdarji2252
      @hareshdarji2252 6 месяцев назад

      ruclips.net/user/shortsrwnFHKGJOuE?si=GmhrpHD8f0elr8GH

    • @hareshdarji2252
      @hareshdarji2252 6 месяцев назад

      ruclips.net/user/shortsYCQoYqEBfPM?si=ZN-4w5DVr-_8VtK3

  • @Amiyo_Kumar
    @Amiyo_Kumar 5 месяцев назад

    Thank you so much. Very well explanation.

  • @manmantsethi6386
    @manmantsethi6386 5 месяцев назад

    excellent. kamaal kar diya

  • @sunitamahesh3498
    @sunitamahesh3498 6 месяцев назад +1

    Picture quality also very good, thank you sir 🙏

  • @QamruzzamaAnsari-d8p
    @QamruzzamaAnsari-d8p 5 месяцев назад

    gone through all the 52 videos. amazing. may God bless

  • @AmitKumar-gi4fo
    @AmitKumar-gi4fo 5 месяцев назад

    Wow Superb sir its very helpful

  • @SajibAnwar-e5c
    @SajibAnwar-e5c 3 месяца назад +1

    Nice Tutorial

  • @hariomjadon3999
    @hariomjadon3999 6 месяцев назад +1

    Very useful fungution in excel thank you much sir ji 🙏🙏🙏

  • @radhikasaha8702
    @radhikasaha8702 6 месяцев назад +1

    ❤ thank you so much you are great bhaiya❤

  • @riyazsuperb6017
    @riyazsuperb6017 6 месяцев назад +1

    Very good bro....waiting for more video

  • @456nitin
    @456nitin 6 месяцев назад +1

    Excellent video , explained very fine , and specially sample data with all formulas like -"icing on the cake"❤❤

  • @SOUMENSAMANTA-n3i
    @SOUMENSAMANTA-n3i 6 месяцев назад +1

    Thank you sir ❤

  • @abhimanyuSingh-tp7hx
    @abhimanyuSingh-tp7hx 3 месяца назад +1

    Superb sir

  • @ArYTshort
    @ArYTshort 6 месяцев назад +1

    Bohut Badiya I loved it

  • @monu247
    @monu247 5 месяцев назад

    Bahut kuch sikhane ko mila sir ❤❤

  • @swetaschabanayak5241
    @swetaschabanayak5241 Месяц назад +1

    Deepak ji Awesome Excel formulla. But where u Learn, pls

  • @techwolves7441
    @techwolves7441 3 месяца назад +1

    Awesome Work Deepak! The way you teach is just fabulous. Keep going, you're helping many who cannot afford expensive courses.

  • @vpal15566
    @vpal15566 3 месяца назад +1

    Great video

  • @tofikqureshi6507
    @tofikqureshi6507 6 месяцев назад +1

    Thanks ❤❤

  • @c_p_k_7767
    @c_p_k_7767 2 месяца назад

    Love you sir ...sch me aap jesa khi nhi pda...

  • @rakeshtanna-y5n
    @rakeshtanna-y5n 5 месяцев назад

    Best God bless you 🙏

  • @riazmahmud54
    @riazmahmud54 5 месяцев назад

    thanks a lot for your excellent work

  • @shraddhajhinjorde3369
    @shraddhajhinjorde3369 5 месяцев назад

    Thanku So much for useful information

  • @dreams202t
    @dreams202t 5 месяцев назад +1

    Very useful video 📷

  • @easycommerceclasses8241
    @easycommerceclasses8241 5 месяцев назад

    Too good..thanks

  • @osamarahmani4577
    @osamarahmani4577 5 месяцев назад

    00:00 Intro
    00:37 Subtotal Formula
    06:02 Sumproduct formula
    07:34 Datedif formula
    10:51 If formula
    16:48 If And formula
    23:10 If Or formula
    29:09 Ifs formula
    32:53 Switch formula
    36:58 Sumif formula
    40:39 Sumifs formula
    42:45 Unique formula
    43:55 Countif formula
    45:34 Countifs formula
    47:03 Averageifs formula
    48:56 Vlookup formula
    57:50 Iferror formula
    59:12 Hlookup formula
    01:03:42 Index formula
    01:07:09 Match formula
    01:09:03 Index + Match formula
    01:15:55 Sum + Vlookup formula
    01:17:13 Xlookup Formula
    01:24:00 Picture Lookup formula
    01:25:55 Sort formula
    01:29:32 Filter formula
    01:33:44 Trim formula
    01:36:52 Dynamic formulas
    01:38:47 Textsplit formula
    01:40:15 Textjoin and Concatenate formula
    01:42:59 Protect formula

  • @sunitamahesh3498
    @sunitamahesh3498 6 месяцев назад +1

    Thank you sir, very nice Sir

  • @vaishnavimali3611
    @vaishnavimali3611 3 месяца назад +1

    I never cmt on any video bt must say really excellent video and your Hardwork 🔥

  • @tofikqureshi6507
    @tofikqureshi6507 6 месяцев назад +1

    Nice 😊

  • @Suraj-j1p9s
    @Suraj-j1p9s 5 месяцев назад

    Bahut achi hai ❤❤❤

  • @AmanSharma-gf1mq
    @AmanSharma-gf1mq 6 месяцев назад +1

    Brilliant sir

  • @ItsAmaranthMaurya
    @ItsAmaranthMaurya 6 месяцев назад +1

    आज तक का सबसे बेस्ट वीडियो है सर जी यहां कुछ लोग दो चार फार्मूला सिखाने के लिए कोर्स बेचते हैं।

    • @hareshdarji2252
      @hareshdarji2252 6 месяцев назад

      ruclips.net/user/shortsrwnFHKGJOuE?si=GmhrpHD8f0elr8GH

  • @rbntutorial2593
    @rbntutorial2593 5 месяцев назад

    Thanks a lot for providing us practice file...

  • @pranaliruge1193
    @pranaliruge1193 6 месяцев назад +1

    Thanks so much sir

  • @GToonsc
    @GToonsc 24 дня назад +1

    Sir aap kon sa software se video edit karte hai

  • @COD401gaming
    @COD401gaming 6 месяцев назад +1

    Good work sir

  • @rahulfatehpur
    @rahulfatehpur 5 месяцев назад

    Bhai Excellent yr, Keep it up!!, God Bless U dear...Paid courses se badhiya class h aapki....

  • @mohankathe3332
    @mohankathe3332 6 месяцев назад

    Thank you Sir.

  • @khalidkhan-pd4jc
    @khalidkhan-pd4jc 6 месяцев назад +1

    Deepak you are best teacher

  • @hafiztahir9760
    @hafiztahir9760 6 месяцев назад +1

    Thank you sir

  • @fitbuddy_4u
    @fitbuddy_4u Месяц назад +1

    Best part ye h ki apne practice file di ❤

  • @kantipoddar
    @kantipoddar Месяц назад +1

    super video

  • @RajuvardhanMogadali
    @RajuvardhanMogadali Месяц назад +1

    Hello Sir,
    I have a Doubt.
    If any new function either we can learn from in your videos other wise how to know a new function can use properly step by step.

  • @VivekSavla-p5m
    @VivekSavla-p5m 6 месяцев назад +1

    Deepak sir too good

  • @SUSHMAKUMARI-q9l
    @SUSHMAKUMARI-q9l 5 месяцев назад

    Excellent

  • @anumayank6544
    @anumayank6544 6 месяцев назад +2

    sir ek video banaye & se koi bhee convatinat banate hai uska formating kaise karenge

    • @hareshdarji2252
      @hareshdarji2252 6 месяцев назад

      ruclips.net/user/shortsYCQoYqEBfPM?si=ZN-4w5DVr-_8VtK3

  • @MISBRCCTARANA
    @MISBRCCTARANA 6 месяцев назад +1

    super sir

  • @divyavernekar8798
    @divyavernekar8798 6 месяцев назад

    Best and useful video🙏. Sir Can you please give us some more practice data files...

  • @monikapandey2917
    @monikapandey2917 23 дня назад +1

    How to find max value in a given data using index match function

  • @shivanichandak8812
    @shivanichandak8812 Месяц назад +1

    thankyou

  • @rajendas577
    @rajendas577 5 месяцев назад

    nice understanding tutorial

  • @shoaibakhtar3240
    @shoaibakhtar3240 6 месяцев назад +1

    Bahut khub

  • @satishudc2253
    @satishudc2253 5 месяцев назад

    VERY NICE

  • @vineet4221
    @vineet4221 Месяц назад +1

    I like it

  • @bkdeshmukh12
    @bkdeshmukh12 6 месяцев назад +1

    Sir mai aapke video dekhe bina hi phle like kar deta hu kyuki har bar aapse kuchh nya aur achchhi chij sikhne ko milta hai

  • @RajeshTiwari-z7l
    @RajeshTiwari-z7l 5 месяцев назад +1

    Sir accounting ki bhi video banana start kriye na Tally prime ka please sir ham aap se hi study krte hai

  • @ajinkyaranaware5289
    @ajinkyaranaware5289 2 месяца назад +1

    Which excel u r using.. I have getting some error in some formula like ifs. This is not avilable in my excel

  • @hafizshoaib8603
    @hafizshoaib8603 4 месяца назад

    Download link pls.
    Very useful video thanks a lot ❤

  • @AmitPal-ek9mw
    @AmitPal-ek9mw 6 месяцев назад +1

    Nice video

  • @sudhakarpandey3371
    @sudhakarpandey3371 5 месяцев назад

    Thank you saab

  • @WajahatAli12145
    @WajahatAli12145 6 месяцев назад +1

    brilliant

  • @satishkushwaha1871
    @satishkushwaha1871 5 месяцев назад

    Super teaching

  • @radhekrsna007
    @radhekrsna007 6 месяцев назад +1

    You are master

  • @mrantic1629
    @mrantic1629 6 месяцев назад +2

    Vote for pivot table tutorial

  • @MPSinghKushwaha
    @MPSinghKushwaha 2 месяца назад +1

    Hamen Sumifs aisa lagana hai jismen ek Creteria Range Column se select karni hai evam ek creteria raw range se select karna hai yadi koi help vedio ho to please batayen

  • @deepkaurdeepkaur3495
    @deepkaurdeepkaur3495 5 месяцев назад

    Bhut mihnat lgde hai yr

  • @mithun1171
    @mithun1171 5 месяцев назад

    Superb

  • @akhilpatil8059
    @akhilpatil8059 5 месяцев назад

    Thanks

  • @rakeshmeghwal1756
    @rakeshmeghwal1756 5 месяцев назад

    Inventory management system in Excel pr Full video banao 🙏 for industrial use

  • @hritikagupta7126
    @hritikagupta7126 5 месяцев назад

    In which excel have you made this vedio sir, 2016or else?

  • @GYANSOUVIK
    @GYANSOUVIK 4 месяца назад +1

    Sir ji mera 2010 ka exel hay xlookup isme nahi hay to use karne ke liye kaunsa wala year ka exel download karna parega

  • @aanchaltomar3659
    @aanchaltomar3659 5 месяцев назад +1

    good

  • @PritamDas264
    @PritamDas264 6 месяцев назад +3

    Agar ek employee ko a saare formula aate hai ta job ke liye enought hai😊

  • @excelkaarigar
    @excelkaarigar 6 месяцев назад

    Awesome sirjee.....
    but here i want to ask you dateif formula is not appear in my excel version 2021 how can i appear it?

  • @harishn5873
    @harishn5873 4 месяца назад +1

    Sir, pls let us know how can we compare portfolio performance with the benchmark(nifty50).