Excel Cell Reference :RELATIVE REFERENCE | Ms - Excel Cell Reference

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024
  • When writing Excel formulas always reference cells correctly .When you copy the formula and its not working correctly, you've probably made a mistake with your cell referencing.
    Understanding this concept really simplifies your Excel work.In this video, you’ll learn the basics of using relative and Creating and copying formulas using relative references.
    Basic Excel Playlist Link - • Basic Excel-The Learni...
    Download the Assignment Master Practice Folder here (All Playlist Example at one place)
    drive.google.c...
    ===========VIDEO COURSE============================
    ✅ Mastering Excel Video Course
    www.innozant.c...
    ✅ Mastering Power BI Video Course
    www.innozant.c...
    ✅ Mastering VBA Video Course
    www.innozant.c...
    ✅ Mastering SQL Video Course
    www.innozant.c...
    Visit - innozant.com
    =====================================================
    ===========HYBRID CLASSES============================
    ✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
    ✅ Database Training(SQL , PL\SQL , Oracle Developer)
    ✅ Mastering Data Science
    Visit - innozant.com
    ====================================================
    Videos in a Sequence -Basic to Advanced EXCEL
    Basic Excel- • Basic Excel-The Learni...
    Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
    Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
    Excel What if Analysis- • Excel What if Analysis
    Excel Array and Sumproduct- • Excel Array & Sumprodu...
    Excel Lookup Functions- • Excel Lookup Functions...
    Excel Pivot Tables- • Excel Pivot Tables
    Excel Power Pivot- • Excel Power Pivot
    Excel Power Query- • Excel Power Query
    Excel Chart and Infographics- • Excel Chart and Infogr...
    Excel Dashboard & Reports- • Excel Dashboard & Reports
    Value add-ons Playlist
    ProQuest-Check Point- • Excel ProQuest-Check P...
    Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
    StudsTalk -The Journey begins- • StudsTalk-The Journey ...
    QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
    Excel Tips and Tricks- • Excel Tips & Tricks
    MIS Interview Cracker- • MIS Interview Cracker
    MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
    Excel Maharaj- • EXCEL MAHARAJ - For Ex...
    Microsoft Powerpoint- • Microsoft Powerpoint
    Microsoft Word- • Microsoft Word
    Office 365- • Office 365
    Google Sheets- • Google Sheets
    Microsoft Outlook- • Microsoft Outlook
    Power BI- • Power BI
    Excel VBA- • Excel VBA Macro
    TezXL Jata Shorts- • #shorts | जो TRIM के ब...
    Announcements- • Announcements
    Website - "www.innozant.com"
    Let's Connect:
    Instagram ► / innozantinfotech
    Facebook ► / innozantinfotech
    Telegram►t.me/innozanti...
    #formulareference #cellreference #relativereference #innozant

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

  • @jigarsheth6359
    @jigarsheth6359 3 года назад +1

    Sir, i have done tonnes of video classes but no one has taught me the way you do i thank you from the bottom of my heart you taught me everything in just one video and cleared my doubts i am grateful for you aloot can't thank you enough. Thank you, Sir

    • @Innozant
      @Innozant  3 года назад +1

      Thanks dear.. Happy Learning.God bless You

    • @UtkarshAnand-kh8vi
      @UtkarshAnand-kh8vi 4 месяца назад

      ​@@InnozantSir power bi ka aur videos banao and focus on main areas like Data cleaning, power query, m functions, data modelling,dax ,etc.

  • @adarshak4767
    @adarshak4767 2 года назад +2

    Bhai bahot deep study hai apka.
    Itna deep kisi ne bhi nahi sikhaya.
    Itne salo se formula use kar raha hu lekin background ye sab hota hai aaj pata chala.
    धन्यवाद।

    • @Innozant
      @Innozant  2 года назад

      Thanks dear..God bless You

  • @viratkohali-xc7cp
    @viratkohali-xc7cp Год назад

    Sir Ur Not Underated Ur That Gem 💎 who only found by Few lucky one's

    • @Innozant
      @Innozant  Год назад +1

      Thanks.. Really means a lot to me dear

  • @Surendrayadav-wd9ud
    @Surendrayadav-wd9ud 2 года назад +1

    मुझे आपका पढ़ाने का तरीका इतना अच्छा लगा कि मैं पूरी video देखने से पहले ही playlist मे जाकर सभी वीडियो को like कर दिया
    Best teacher 🙏🙏🙏🙏

    • @Innozant
      @Innozant  2 года назад +1

      Thanks Surender Ji..ab aap sequence me video Dekhnege aur practice karenge.. practice file download krke ..have a great career ahead

  • @aatifrashid5413
    @aatifrashid5413 2 года назад

    Awesome Lecture!

  • @DurgeshKumar-on4ct
    @DurgeshKumar-on4ct 2 года назад

    Sir, I like your way to teach

  • @AjayKumar-vq1mt
    @AjayKumar-vq1mt 3 года назад

    Jabardast, bahetreen uumda way of teaching Sir...

    • @Innozant
      @Innozant  3 года назад

      Thanks Ajay Ji..Really means a lot to me.

  • @nikhilsinger6306
    @nikhilsinger6306 2 года назад

    guru ji kamaal kita tusi

  • @artiverma5122
    @artiverma5122 3 года назад

    Bhut badiya sir

  • @yurialexkov2797
    @yurialexkov2797 2 года назад

    Shaandar video

  • @deepshivhare
    @deepshivhare Год назад

    Thank you sir 😊

  • @sushilchoudhary1328
    @sushilchoudhary1328 3 года назад

    Great! Chapter Done.

  • @gauravbhatia7987
    @gauravbhatia7987 3 года назад +1

    Good sir

  • @hackergaming7243
    @hackergaming7243 2 года назад +1

    Nyc teaching

  • @jasminakther8258
    @jasminakther8258 Год назад

    Good presentation

  • @govindsharma19
    @govindsharma19 2 года назад

    Nice sirji

  • @sawaimalhi8439
    @sawaimalhi8439 3 года назад

    so nice sir

  • @tripathiashish06
    @tripathiashish06 3 года назад

    Arigatou gozaimasu sensei

  • @dicaprioleo8261
    @dicaprioleo8261 3 года назад

    Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen

  • @sawaimalhi8439
    @sawaimalhi8439 3 года назад

    Sir sales dashboard ya hr dashboard banana sikhayin ...Power query ki concept share krin aaap please apna thora experience share krin kis trah aaap nay excel m starting le thi phir kis trah zayda sekhte gye

    • @Innozant
      @Innozant  3 года назад +1

      Jaroor..aur dashboard ke videos leke aayenge .Power pivot ke baad power query ka hi playlist aayega

  • @ratanpal1948
    @ratanpal1948 Год назад

    sir practice data kaise milega

  • @Altaf_Alam
    @Altaf_Alam Год назад

    ❤️

  • @Surajk927
    @Surajk927 2 года назад

    Bulk file name rename with excel cmd use or with any other rename without software pls make a video

  • @paras5861
    @paras5861 3 года назад

    Sir Aapki Videos Bohat Achi hai, Kuch VBA or Power Bi Par Banaye.

    • @Innozant
      @Innozant  3 года назад +1

      haan banayenge videos..pehle power series finish kar lete h

    • @paras5861
      @paras5861 3 года назад

      Sir Job ka kuch karwa do! Plz🙏

    • @Innozant
      @Innozant  3 года назад

      interview dene ki koshish kriye

  • @RahulKumar-xi7jq
    @RahulKumar-xi7jq 2 года назад

    sir I want to join offline classes

    • @Innozant
      @Innozant  2 года назад

      Good Morning Rahul,Aap institute visit kar sakte hain ya call/whatsapp karke course ka detail leke upcoming batch join kar sakte hain,For more information kindly visit Innozant website.

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

    ये तो गूगल शीट में भी पढ़े थे

  • @AnuragKumar-mb9br
    @AnuragKumar-mb9br 2 года назад

    Create an excel sheet enter some value and represent Relative reference and Absolute reference
    Sir eska bna ke aap muje pdf de sakte hai?
    Pls sir 🙏🙏🙏🙏🙏🙏🙏🙏

    • @Innozant
      @Innozant  2 года назад

      Complete excel sheet are there in video des

  • @sheetalpanchal3038
    @sheetalpanchal3038 Год назад

    Answer kya h assignment ka

    • @sheetalpanchal3038
      @sheetalpanchal3038 Год назад

      Mere m # value! Show kr rha h

    • @Innozant
      @Innozant  Год назад

      Solution sheet hoga dear .Proquest playlist me

    • @sheetalpanchal3038
      @sheetalpanchal3038 Год назад

      @@Innozant sir $sign se freeze hota h usey remove krne par right answer aega =B2+B3......