WEBVTT

00:02.420 --> 00:04.100
OK guys welcome back.

00:04.100 --> 00:10.490
Now in the next four lectures we're going to have a look at all the variations of absolute and relative

00:10.580 --> 00:11.990
cell reference.

00:12.170 --> 00:16.670
No unno at the moment that probably doesn't mean much to you but it will become clear as you work through

00:16.670 --> 00:18.820
these four short lectures.

00:18.830 --> 00:24.390
So I've created this Excel file which you can download and you can see that we have four tabs.

00:24.530 --> 00:30.140
We have a one which in technical terms is relative a relative one.

00:30.410 --> 00:32.980
We have dollar sign a dollar sign.

00:32.990 --> 00:37.360
One which would be read as an absolute absolute one.

00:37.610 --> 00:41.550
We have a dollar sign I want which is absolute.

00:41.600 --> 00:49.400
A relative one and a dollar sign one which is a relative and an absolute one.

00:49.580 --> 00:52.390
No dont worry if you don't understand what that means just at the moment.

00:52.400 --> 00:55.210
The easiest way to understand this is watch it in action.

00:55.220 --> 00:57.630
And then it will become really clear.

00:57.830 --> 01:05.000
Okay so lets begin with relative a relative one or otherwise just referred to as a one so on and do

01:05.000 --> 01:12.450
is write a simple formula to Multiply this figure by this figure and you can see when we hit EF 2 that

01:12.480 --> 01:19.330
the blue cell a 3 is multiplied by the Red Cell B three and hit enter.

01:19.340 --> 01:24.590
Now if I copy that formula down by using that short code just double click on the drag handle and we

01:24.590 --> 01:27.170
come down to here and hit left.

01:27.420 --> 01:35.660
Now you can see that the cell references the A's and the bees have moved relative to the formula that

01:35.660 --> 01:42.830
we've just copied down so we copied it down one cell and the cell references have both moved relatively

01:43.070 --> 01:44.810
down one cell to.

01:45.110 --> 01:51.020
So before we had a three B3 and then we hit enter.

01:51.110 --> 01:55.340
And now they have moved down relatively So we have a four by four.

01:55.460 --> 02:00.830
And then as we moved down we can see that as we've drank the formula each of the cell references has

02:00.920 --> 02:04.970
moved down relative to where the formula lies.

02:05.030 --> 02:11.000
So that's a relative relative cell reference in the next you are going to have a look at an absolute

02:11.090 --> 02:12.080
cell reference.

02:12.130 --> 02:14.540
Okay I'll see you in the next lecture.
