Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Absolute or Relative References in Excel

Loading...

Sign in or sign up now!
10,166
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Feb 24, 2008

A light-hearted clip explaining the use of absolute and relative references in spreadsheets. Developed in the Department of Management, University of Canterbury, NZ.

  • likes, 4 dislikes

Link to this comment:

Share to:

Uploader Comments (UCMSCI)

  • Thank you so much for this. At 29, I've started my first business and have never had to create spreadsheets before, so this is very much appreciated and useful. Very well done and interesting to watch! :)

  • Thanks for that. Good luck in the business.

  • Your video about cell references is awesome! I am going to tell all my students to watch this in addition to the videos that I make!

    I have made hundreds of videos for my classes over the past 2 years (I have only been on YouTube for 2 weeks), but your video tops them all! It is so funny and to the point!

    Thanks, UCMSCI !

    --Mike Gel Girvin

  • Thanks for that Mike. I have put a link on Blackboard for my students (all 380 of them!) to use your vids as well. I have only watched a few, but they look well done to me. We are hoping to do some more but I'm a bit short of time at present. My son does the entertaining bits.

  • Hahaha, Im currently attending your lectures so I thought why not check this out! Its funny, but Im going to have to watch it a few times to get it right @_@ thank you for the clip though! Sure it'll help many others out there!!

  • Thanks for that. We hope to make some more.

see all

All Comments (11)

Sign In or Sign Up now to post a comment!
  • this was great!!!! if only i did this last semester when i was doing info123 i could have saved sooo much time and gotten a better grade

  • A very clear and helpful video. My MIC101 teacher has linked this to us as additional instruction, because it is that useful. It would be good, though, to explain how the F4 button is useful in changing between absolute and relative references.

  • Helen is actually a man from a cartoon called Death Note.

    Great video though :D thanks!

  • Thanks for this, it's really helpful! Now I can ace my excel exam!

  • very clear and fun way to learn...it's very easy to understand

    i'm one of ur student so well done

  • Very cool and helpfull :)

Loading...
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more