How To Use Relative & Absolute Cell References In Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 3 ต.ค. 2024
  • This video explains how to use relative and absolute cell references in excel.
    Excel Tutorial For Beginners: • Excel Tutorial For Beg...
    Top 30 Excel Tips & Shortcuts:
    • Top 30 Excel 2016 Tips...
    _______________________________________
    How To Move Multiple Rows & Columns:
    • How To Move Multiple R...
    How To Split Text Into Multiple Columns:
    • How To Split Text Into...
    How To Use Hyperlinks In Excel:
    • How To Use HyperLinks ...
    How To Sort and Filter Data:
    • Excel Sorting and Filt...
    Excel - Find and Replace Tutorial:
    • Excel 2016 - Find and ...
    Excel Conditional Formatting:
    • Excel Conditional Form...
    ______________________________________
    Relative & Absolute Cell References:
    • How To Use Relative & ...
    Lock Cells and Protect Sheets In Excel:
    • How To Lock Individual...
    Excel Interactive Checklist:
    • Interactive Checklist ...
    Excel Pivot Tables:
    • Intro to Pivot Tables,...
    ______________________________________
    TH-cam Channel Growth Accelerator:
    / youtubechannelgrowthac...
    Algebra For Beginners:
    www.video-tuto...
    Final Exams and Video Playlists:
    www.video-tuto...
    Full-Length Math & Science Videos:
    / collections

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

  • @TheOrganicChemistryTutor
    @TheOrganicChemistryTutor  8 หลายเดือนก่อน +5

    Final Exams and Video Playlists: www.video-tutor.net/

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

    my man helped me out with chemistry in high school, and now he's helping me with computer literacy in college! u are the best

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

      What school

    • @carloscraigito7384
      @carloscraigito7384 3 ปีที่แล้ว +2

      yup lmfao

    • @hoshihiramatsu5627
      @hoshihiramatsu5627 3 ปีที่แล้ว +1

      OMG THIS ME RNNNN
      IM CRYING because I finally figured out my problemmmmmm 😭😭😭😭😭😭

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

      What I’m in 9th, this isn’t fair

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

      Saaaameeeee bruh! absolute best though

  • @darrylgrammer6242
    @darrylgrammer6242 3 ปีที่แล้ว +54

    I think I owe you tuition after all you’ve done for my college education. Absolutely subbed.

    • @samafo2691
      @samafo2691 6 หลายเดือนก่อน

      Amen. I learn more here than in my college class.

  • @ItzDeshawn
    @ItzDeshawn 2 ปีที่แล้ว +18

    Why can’t teachers make explanations this EASY❗️❗️❗️ Preciate you bro 💯❗️😂

  • @cindyly6150
    @cindyly6150 5 ปีที่แล้ว +58

    You saved me after wasting about 2 hours trying to figure this out! Thank you so much!

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

    currently taking the google cert for data analytics, and they tried to explain this section in a couple paragraphs. this is currently my first complaint about this certificate course, so please don't think I'm going hard on it. I'm having a great time and I expected this would happen with some of the concepts considering they wouldn't be able to go too in depth on everything. but they explained this in a couple sentences, and I simply couldn't understand it. Now I understand what they were trying to say, and from this example, I look forward to having to do my own research on certain things and honestly, that's probably what life is going to be like when I start getting paid to do this.
    If anybody read this far, heed my warning. If you take any course online and you're a self learner, be ready to search for amazing content like this gentleman right here. He explained something that I honestly don't know how else I would have been able to find out without external help. Don't be tied down to one way of learning, and Google cert gives out plenty of opportunities and external resource links, so they encourage it to as any short term learning program should.
    on topic, though, I'm VERY thankful this video was here because it explained if VERY well.

  • @medhavi2200
    @medhavi2200 2 ปีที่แล้ว +14

    I have a practical tomorrow and I have been trying to understand this concept for half an hour and I didn't get a thing. You helped me so much thx ❤️

    • @Fotballedz
      @Fotballedz 7 หลายเดือนก่อน

      me toooooooooooooooooooooooo

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

    much simpler than other explanations other people on youtube make this sound much more difficult than it is. thanks

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

    he teaches computer too, i love this man. when i viewed this video i didnt even see the name of it. i just heard the voiced and decided to go check the name, then i saw THE ORGANIC CHEISTRY TUTOR, i was so surprised. honestly... you are my everyday crush.

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

    😂😂😂😂😂😂 I used copy the number down to entire columns until later I came across "absolute referencing" and I asked my self what this is and it was something I was trying to figure out last month . This changes my life tysm great explanation , clear precise absolute

  • @sanojagodellawatta5110
    @sanojagodellawatta5110 2 ปีที่แล้ว +3

    I am a o/l student, I got the meaning of row and column absolute cell reference, thank U very much for your guidelines. 😃😃😃

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

    Thank you so much! I'm taking online computer business classes and honestly my professor hasn't taught me shit! But your video really helped me out so I wanted to say thank you!!

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

    This video really helped. I have an IT exam tomorrow and I finally understand. Thank you so much.

  • @UniverseReniverse
    @UniverseReniverse 11 หลายเดือนก่อน +1

    Thank you!!!!! My professor didn’t really explain it well in the steps 😢 but you really saved me for my assignment! 🎉🎉

  • @jamesedwardtagalan2147
    @jamesedwardtagalan2147 3 ปีที่แล้ว +10

    You absolutely saved me from my entire student endeavor! Thank you so much Sir

  • @Captain_Juice
    @Captain_Juice 2 ปีที่แล้ว +7

    Thank you so much for this video! My study notes for the exams explained it in a very long and complicated way,but you just got straight to the point and the explanation is as brief as possible and as clear as water. Thank you so much,my man! :DD

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

    This bruvver helped me with high-school mathematics and physics and chemistry. Now he's helping me attain a BSc Computer Science, Mathematics and Statistics. Bruv you are amazing .

  • @Dan-1031
    @Dan-1031 2 ปีที่แล้ว +4

    You explained it way better than my teacher AND the ones who made the school book also. You is a trooper

  • @hannahmeng4497
    @hannahmeng4497 3 ปีที่แล้ว +1

    you help me to do the math, now excel...you are the best tutor!

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

    i literally come to u for ALL MY COURSES LOL ur THE BEST !

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

    This tutorial was absolutely SUPERB! I've watched more than several videos about this topic. I totally get it after watching your tutorial. Thank you :)

  • @katruiz9658
    @katruiz9658 5 หลายเดือนก่อน

    This is the video I needed to help me with these references, thank you!! Just kept it simple and it cleared up a semester of block on this subject.

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

    This is so beautifully explained. And your voice is so cool. Thank you!

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

    Bro this helped me out so much, I'm in Cyber Security/Business at college and we are doing intense excel graphs. Thank you!

  • @TCA_
    @TCA_ 3 ปีที่แล้ว +1

    Searched for an hour for this. Thankyou

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

    Thank you for your easy explanation. I have had a hard time listening to people explaining this in another language.

  • @nazmaakter6905
    @nazmaakter6905 3 ปีที่แล้ว +3

    Do you have video on mixed cell reference? Ma Sha Allah, you are a good tutor,, this video helped me a lot, easy to understand, thank you.

  • @nimishgrover7637
    @nimishgrover7637 6 หลายเดือนก่อน

    I was like this voice is a bit familiar one....after video got complete i scrolled down and saw that it was organic chemistry only....man this guy helping out there alot!!

  • @Vastutips__0101
    @Vastutips__0101 2 ปีที่แล้ว +3

    It helped me a lot in my I.T. practical thanks 🙏🏻

  • @ChineduUdeh-le2go
    @ChineduUdeh-le2go ปีที่แล้ว +3

    Short Cut: Once you select the cell you want to reference, just press F4.

  • @aniiraqigawad6693
    @aniiraqigawad6693 3 ปีที่แล้ว +1

    This man is carrying my linear algebra and MIS courses. Without you i would’ve dropped out and became a MLO and daytrader. Hopefully you have calc and stats vids or else that’s probably gonna be the case for my third year. Lol

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

    I've been using Excel ever since computers had a hand crank on the side and I never figured this out. Thanks a million.

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

    Thank you so much! My eBook diagram was fuzzy. I could not see the second dollar sign. Great video!

  • @danielapalomo7164
    @danielapalomo7164 3 ปีที่แล้ว +9

    Loved it! Straight to the point and clear as water. Thank you!!! 🙏🏼🙏🏼

  • @223anonymous
    @223anonymous 11 หลายเดือนก่อน

    i cant help but notice that my sister in 7th is learning about this and i sent her this video to guide her and she got full! thanks for the video

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

    You helped me pass my Hiset and pass well....here I am again. Thank you volumes.

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

    100% helped me put, lots of love

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

    multitalented guy i studied chemistry,physics,mathsand now computer from your channel

  • @aidanmillican694
    @aidanmillican694 3 ปีที่แล้ว +3

    Thank you for making this so much clearer, you helped me through a final project that had me pulling my hair out lol

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

    This is very helpful. You are very good at explaining things. Thank you for sharing.

  • @bridgettepaguinto517
    @bridgettepaguinto517 3 ปีที่แล้ว +1

    Thank you so much it is work for me. god bless

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

    😀i didnt know this man does computer tutorial, prof. youre the best indeed😋

  • @biswajitnandi9548
    @biswajitnandi9548 4 หลายเดือนก่อน +1

    Wanna know why teachers make it so complicated 😂😂😂thnx brother cuz you helped me a lot ❤ i have a practical tomorrow

  • @britneycooper2644
    @britneycooper2644 5 ปีที่แล้ว +3

    Thank you so much did it today in class and still need to practice some more

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

    Thank you so much for your useful video

  • @sreevidhyarathish2140
    @sreevidhyarathish2140 9 หลายเดือนก่อน

    thank u so much man,..... im a student and ur videos helped me alot!

  • @malakel-adany9324
    @malakel-adany9324 2 ปีที่แล้ว +1

    That was really helpful thank you😄

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

    very nicely explained by you sir thanks for helping

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

    this guy does everything

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

    This is very helpful. You are very good at explaining things. Thank you for sharing.

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

    Oh my you just saved me years of my life! thanks, for this.

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

    thank you. I can actually use this for my course work and understand what the f4 key is used for.

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

    This helped a lot thank you.

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

    You are very helpful! Thankyouuu!!

  • @Dr_a_go-z3z
    @Dr_a_go-z3z 5 หลายเดือนก่อน

    This dude knows everything

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

    جزاك الله خير يا اخي

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

    Thanks my guy. Even my teacher couldn't help me so much 😂

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

    my man you teach everything!

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

    That’s why I love you 😘 Thank you

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

    You are wonderful, many thanks for your generous time in creating these videos.

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

    Thank you so much!

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

    u are legend bruh

  • @parkermills3135
    @parkermills3135 27 วันที่ผ่านมา

    So helpful! Thank you

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

    Thank you 🌸

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

    Thank you, I was struggling to memorize it and you simplified it for me cheers

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

    Bro, needed this for my homework!

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

    dude knows everything

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

    Thank you ily mwah mwah u help me alottttt

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

    thank you so much man!

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

    You teach ICT too? Wow. ❤

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

    Man u helped me

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

    Thanks for sharing!!! I watch yours and VANNA EXCEL for my marketing work!

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

    thank you man, you saved me :)

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

    thank you so much and God Bless!

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

    perfect examples and explanation, thank you!

  • @marynabolgaryna-shepherd8938
    @marynabolgaryna-shepherd8938 ปีที่แล้ว

    Thank you so so much!!! You are the best

  • @mr.pyramid5523
    @mr.pyramid5523 ปีที่แล้ว

    You are the best man thanks

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

    what does he not know?

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

    Thank you, sir

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

    Thx bro! It LITERALLY saved my hours of frustration.

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

    Thank you, great explantation

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

    That was lucid, thank you

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

    Dang!!! Thanks so much this was super helpful

  • @avinav7462
    @avinav7462 3 ปีที่แล้ว +2

    Thx man

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

    Dhanyavad, Thanks

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

    Thanks a lot sir it helped a lot 😊😊😊.

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

    Thank you so much🙏 lifesaver 💯

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

    You have everything!!! Thank you ;;

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

    Thanky you. bud!!

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

    Thank you so much!

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

    Bro thank you very much!!!

  • @lou.104
    @lou.104 2 ปีที่แล้ว +1

    Thanks bro

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

    very helpful!

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

    Came here today while writing a test thank you✌

  • @antheagraham962
    @antheagraham962 11 หลายเดือนก่อน

    Thank you 🎉🙏

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

    Good video

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

    tq so much

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

    Thanks a lot man 💙💙

  • @someshsasidharan4983
    @someshsasidharan4983 5 ปีที่แล้ว +1

    Thankyou, this video is very helpful.

  • @readytofitfitnesspointgym8211
    @readytofitfitnesspointgym8211 8 หลายเดือนก่อน

    Thankyou so much sir