Absolute and Relative Cell Referencing
This video tutorial focuses on Absolute vs. Relative cell referencing within Excel. You likely know it as the dollar sign ($) used in functions/formulas (for example, C5 vs $C$5).
There is also a quick demonstration of the video using a VLOOKUP formula. The VLOOKUP formula is explained in more detail in these two lessons here and here, but the example in this video gives a basic understanding of how it works in Excel.
Update 5-22: I’ve noticed some users (especially those with Macs) have had difficulty viewing this video. Since it is one of the older videos, I will be re-recording it and adding information so that it is comparable to more recent videos.
If you’re following the Lesson Guide, next up is Math & Statistical Functions (e.g. SUM, AVERAGE)
I love this website! But I didn’t fully understand this lesson. I did a VLOOKUP course on Microsoft’s support website, I thought I got it. But in this lesson, I don’t understand what you are trying to do with the second table. I have looked at the formula in the downloadable table so I see the arguments but the goal of the second table is still not clear to me.
I still have problems… it crashes.
Same here. So disappointed. I am really hoping I can watch this video!
I don’t have any problems playing it. It seems the people who I’ve heard have a problem are using Mac’s.
I’ll try to re-upload and/or re-render the video and see if that fixes it.
In the meantime, you can try going to the Vimeo page and downloading the video file. It can be found here: http://vimeo.com/30347348
There is a download link underneath the description.
Hope that helps!
Ben
kudos! good job
great training well done
Pingback: A Complete Introduction to Excel | MBAx.me
Great videos, they’re very much appreciated!
Pingback: A Complete Introduction to Excel | MBAx.me
Dood…Awesome!
Great video…. thanks a lot
Happy to have found your series, Ben! Great stuff! I’m not having problems viewing the videos, except this one keeps crashing my firefox browser a second after hitting play.
Hey Mark!
The video seems to play fine for me, hope it’s still not giving you issue! Could be a problem with vimeo…
Cheers,
Ben
I am having trouble viewing this video, also. It either crashes, or when it finally did play (the next day), it is blurry and looks like it is reversed from a normal view.
It crashes my Firefox browser as well Running firefox 12.0 on a Macbook 10.5.8
It works fine on me. I don’t have a Mac to try it on so I’m not sure what the issue is unfortunately.
You can try going to vimeo.com/excelexposure and see if it works on their site.
Had the same problem… says adobe flush p[lug in crashed…. same with vimeo…
I tried a different browser like google chrome.. IT WORKED… thanks BEN…
quick question, are the worksheets you use on the videos available in the master book? if not, not big deal, i just wanted to see if i could use them to test out the new stuff i learn
Hi Adriana,
Yes, the Excel workbook that is reviewed in the video can be found in the Master Workbook. Here’s a screenshot where you can see that it is the spreadsheet entitled “9 – Referencing”:
http://i.imgur.com/cp2Up.png
Let me know if you still have problems.
Ben
Thank you! Toggling between this video and the naming video until I really get it all into my head, and move it to my bag of Excel tools!