Relative vs Absolute Cell Reference in Microsoft Excel - What's the difference?

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

КОМЕНТАРІ • 57

  • @wigglebolt4079
    @wigglebolt4079 Рік тому +21

    Let me tell you something, that click thing you did 2:35 saved my life, sanity, and health. I have a finance project due and could not get the formula to move down. You are a damn hero sir

    • @nsw_27
      @nsw_27 6 місяців тому +1

      Agreed! I never knew that was an option.

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

    Thanks Jamie! I’m a retired CAD teacher and still enjoy learning things new!

  • @RLWMJW07
    @RLWMJW07 10 місяців тому +2

    My online class text is so dry. This helped me tremendously!

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

    Thank you I took an excel course and the explanation aboute and relative reference was unclear for me. Now I get it. Cheers from México.

  • @albertoalamamoran6082
    @albertoalamamoran6082 2 роки тому +8

    That´s what I will always say...thanks a lot Jamie keet...as clear as water instructions...GOD BLESS your work. Regards from Trujillo- Perú.

  • @TiffHE
    @TiffHE 17 днів тому +1

    amazing video! short and sweet and super helpful. thank you so much!

    • @TeachersTech
      @TeachersTech  17 днів тому

      You're welcome! Thanks for the feedback.

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

    Perfect, my Teachers explanation was at best.... rubbish. Thankyou for this, Its all clear now. Plus the F4, sensational.

  • @muaaza1432
    @muaaza1432 3 місяці тому

    Hi teacher, thank you for this, I was finding it hard to fully grasp the absolute reference concept!

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

    Your explanation is very brilliant.

  • @bandaralqahtani4356
    @bandaralqahtani4356 3 місяці тому

    I really appreciate you attaching the worksheet in this video.
    Thanks buddy

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

    Very helpful! I am in a CIS 105 course and the examples given were confusing. I needed a real world example to help me understand why I would need to use absolute/relative cell referencing.

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

    You helped me with my problem on excel, thanks!!

  • @cliffordoscar9043
    @cliffordoscar9043 2 роки тому +63

    Despite the economic downturn,I'm so happy☺️. I have been earning $ 60,000 returns from my $7,000 investment every 13days.

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

      The crypto market is highly profitable with an expert broker just like Mr Ray Dalio I got recommended to him and since then my financial life has been a success.

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

      I'm a long term investor. I Withdraw my profits of over £56,000 during the covid-19 pandemic

  • @inhaiy
    @inhaiy 2 місяці тому

    Bro thankyou so much it was really easy to understand I couldn't understand my tchr but I understood you

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

    Thank you ! Very helpful and informative. Have a blessed life

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

    This absolutely gave me an answer to my assignment, Would you kindly do a brief video explaining the function of xlookup?
    Thank You Jamie.

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

      I don't yet, but can make it one of my next videos.

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

    Thank you Jamie for your beneficial videos, I appreciate it if you could always put a link to the worksheets for our own practicing.
    Many thanks again and have a great day

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

      You're welcome, there should be a link in the description.

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

      @@TeachersTech Hi Jamie,
      I agree for this video and others, there are a links but for some videos there are no links but regardless your help is eternally appreciated.

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

    Thank you sir Jamie,
    from Phil.

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

    Thanks Mr for ur good work may God make u to leave longer

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

    Thank you for ease explanation

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

    thank you mr for this! ^^

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

    Thanks! Appreciate it

  • @s.haythamalsaid1245
    @s.haythamalsaid1245 2 роки тому +1

    Thank you so much sir

  • @jensuru
    @jensuru 7 місяців тому

    Great, thank you!

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

    this was so helpful.

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

    Easy! Thank you!

  • @felixappiah7547
    @felixappiah7547 11 місяців тому

    Wow. I now understand

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

    Thank you :)

  • @Danny-bbsrSingh
    @Danny-bbsrSingh 2 роки тому +1

    Nice!

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

    Thank you so much

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

    WHAT IF I WANT THIS FORMULAS FOR A ROW RATHER THAN COLUMN, HOW CAN I DO THAT BECAUSE WHEN I DO IT AS A ROW THE FORMULA DOESN'T CHANGE AT ALL

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

    Hi, Jamie fantastic video as always! What does the $ sign do in front of the E in $E2

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

    what are auditing features and functional condition features

  • @MrTaggu
    @MrTaggu Місяць тому

    Very heloful

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

    Hello Jamie, thanks for the video. I have been watching your videos for a long time. Thanks for all the videos you put out on varying topics. Some of them have been very beneficial to me. Please, I have an issue with an MS document. The Document is not opening when I click on it. It shows an error message of corrupt file. Can you help me with repair or recovery? It is just one MS word document. It about 608kb, a second version is 900+kb. Thanks.

  • @luthwill7563
    @luthwill7563 12 днів тому

    Tnaks sir

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

    mr. jamie please verify yourself for braves basic attention token, so that i as a viewer can contribute for your content, thanks!

  • @brong2x
    @brong2x 2 місяці тому

    Niceeeee

  • @aidanrgis7129
    @aidanrgis7129 9 місяців тому +1

    anyone else noticed that the names he used are characters form stranger things?😂

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

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

    Someone else is a Stranger things fan here I see😂

  • @Waqasakhunzada
    @Waqasakhunzada 11 місяців тому

    Kia ye Kisi ny azmaya hy agr yes to pls comment n share your experience

  • @safeerahmad3777
    @safeerahmad3777 5 місяців тому

    Wow very dangerous

  • @user-yp9nz6bs9q
    @user-yp9nz6bs9q 8 місяців тому

    enter not return

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

    i love you. be my husband.

  • @gon-rm2lx
    @gon-rm2lx 6 місяців тому

    Thanks Jamie! I’m a retired CAD teacher and still enjoy learning things new!