WEBVTT

00:02.330 --> 00:05.610
Okay guys welcome to part one of the bonus section.

00:05.690 --> 00:10.210
And in this little chap we're going to have a look at how you were around excel like a ninja.

00:11.020 --> 00:15.300
No one of the first things that we looked at was the ribbon which is this area at the top of the screen

00:15.300 --> 00:16.140
just here.

00:16.290 --> 00:21.060
And you'll recall from earlier in the course to navigate between the different sections of the ribbon

00:21.390 --> 00:23.320
we just have it over each of the names.

00:23.340 --> 00:25.510
And we would left click to get to insert.

00:25.590 --> 00:29.950
We'd move over with our mouse with left click to get to page layout the same with formula.

00:29.950 --> 00:32.090
Same with data same with review.

00:32.100 --> 00:34.630
But there's an even faster way of doing this.

00:34.710 --> 00:40.350
If you're lucky enough to have one of those mice with a scroll we'll just have your mouse cursor anywhere

00:40.350 --> 00:46.560
within the ribbon and with your scroll wheel just roll down and you'll find that your move over one

00:46.920 --> 00:48.420
ribbon to the right.

00:48.540 --> 00:53.700
And if you keep rolling you can keep rolling and you'll get all the way over to the right sound just

00:53.700 --> 00:58.800
move in one click with the wheel each time to move over one ribbon to the right.

00:58.800 --> 01:02.750
If you roll up your move over one to the left.

01:02.970 --> 01:08.040
And if you want to move over multiple Just give it a quick roll and you can scroll through all the different

01:08.050 --> 01:12.530
ribbons that's one very quick way of navigating the Rubins if you couldn't be bothered with the pointing

01:12.570 --> 01:13.710
click method.

01:13.960 --> 01:16.110
Okay so there's your first tip.

01:16.110 --> 01:20.790
Use your mouse wheel to scroll through the Rubins super fast.

01:21.260 --> 01:25.900
Okay the next thing we're going to look at is how you navigate your way around this data table.

01:26.050 --> 01:31.240
Now we know that we can instantly click on a cell by just left click in it and get around.

01:31.270 --> 01:34.760
But let's imagine we want to get from here all the way over to here.

01:34.950 --> 01:40.080
What we could do is just left click but you need fairly good message control to instantly do that which

01:40.080 --> 01:40.940
I'm sure you have.

01:40.950 --> 01:47.760
But there are quicker ways you can hit the control button and hit your right arrow to immediately go

01:47.760 --> 01:49.700
to the end of your data set.

01:49.710 --> 01:56.250
You can also control arrow and hit the left to come right the way of it to your left most column.

01:56.300 --> 02:01.980
You can hold down the control and hit the up arrow to go to the top of your data set or you can hit

02:01.980 --> 02:06.640
the control and hit the down arrow to go to the bottom of your data set.

02:06.650 --> 02:12.690
So it's a very quick way to immediately get to the far right the far left the top or the bottom of a

02:12.690 --> 02:14.490
particular data set.

02:14.490 --> 02:16.020
Now there's another way of doing this.

02:16.020 --> 02:22.480
I've only just learnt about if you look closely you'll see that this cell has a green line around it.

02:22.530 --> 02:28.710
Now to move immediately to the top if you just hover on the top section of that bar you can see that

02:28.710 --> 02:34.740
the curse has changed just double click with the left mouse button and you immediately go to the top.

02:34.750 --> 02:40.860
And similarly if you just hover over the bottom line till the cursor changes double click you can see

02:40.860 --> 02:45.450
that your cursor immediately dashes down to the bottom of your data table.

02:45.450 --> 02:50.570
Similarly if you click on the right hand side double click whizzes over to the far right.

02:50.640 --> 02:55.200
And if you have four on the left hand side tell the cursor changes double click and you immediately

02:55.200 --> 02:57.600
zap over to the far left column.

02:57.890 --> 02:58.500
Okay.

02:58.690 --> 03:04.170
If you're anywhere in your data set and you want to get back to your home cell your home cell is the

03:04.170 --> 03:11.190
top left hand corner of your data just hit control and home on your keyboard and that will immediately

03:11.190 --> 03:13.700
wish you back up to your home cell.

03:13.950 --> 03:14.510
Okay.

03:14.550 --> 03:16.500
So that's how you move around the spreadsheet.

03:16.500 --> 03:17.840
Very very quickly.

03:18.110 --> 03:18.390
OK.

03:18.400 --> 03:23.310
If we've got a large data set we may want to move down more than one row at a time which is what we

03:23.310 --> 03:25.620
do when we hit the down arrow button.

03:25.830 --> 03:31.080
But sometimes you may want to move down an entire page at a time and that's really quick to do.

03:31.080 --> 03:37.500
All you do is hit the page down on your keyboard to move down a complete page at a time.

03:37.500 --> 03:45.710
So if I page up I can go back up and see that we have visibility of lines 5 through 20 page down and

03:45.710 --> 03:47.190
then I can see line 20.

03:47.190 --> 03:50.980
So I can still see the bottom line and the data that was previously visible.

03:51.060 --> 03:56.610
But now down to 35 and so on and so forth has a page down page up.

03:56.790 --> 03:59.630
Very useful if you have big data sets.

03:59.950 --> 04:00.250
OK.

04:00.270 --> 04:03.000
So that's how we were around the table within the sheet.

04:03.030 --> 04:07.160
But what if you wanted a quick way to flip between the different sheets that we have.

04:07.300 --> 04:10.090
Now we know that we only have two sheets on this one.

04:10.260 --> 04:15.390
We have sheet one and we have our chart and again look at there's a keyboard shortcut for that.

04:15.510 --> 04:19.950
You just hold down your control button and hit page down.

04:19.980 --> 04:25.420
So for every time you hold control and hit page down you'll move over one sheet to the right.

04:25.590 --> 04:31.310
And similarly to move back to hit control and page up and your turn the page back one.

04:31.350 --> 04:35.390
So Page up moves you to the left page down moves you to the right.

04:35.430 --> 04:37.730
Just remember to hold down your control button.

04:37.860 --> 04:41.600
So they go move to that page and move back to that page.

04:42.150 --> 04:42.850
Okay.

04:42.900 --> 04:50.130
Now if we wanted to highlight our entire range of data which is all of this here now Excel defines a

04:50.130 --> 04:51.080
range of data.

04:51.090 --> 04:56.880
If it's bordered by empty cells and we can see that we have empty cells all the way around this dataset

04:57.180 --> 05:01.300
so we can left click here drag it down to here and that's highlight it.

05:01.350 --> 05:06.070
But there is a keyboard shortcuts to instantly do that and that is control.

05:06.280 --> 05:08.720
So if I hold control in it.

05:09.030 --> 05:10.280
You can see that that in time.

05:10.320 --> 05:12.150
Range has been highlighted.

05:12.150 --> 05:19.430
Now the easy way to remember control and a is that all begins with a so control when a high highlights

05:19.490 --> 05:20.060
all.

05:20.080 --> 05:24.930
Now if you want to highlight the entire sheet you can hold down control and hit again.

05:25.110 --> 05:29.100
And then the selection will expand to cover the whole of the sheet.

05:29.250 --> 05:35.220
Okay so I just choose another cell so control and highlights all of your table control.

05:35.400 --> 05:41.070
Again highlights all of your sheet at just one more thing I want to bring to your attention in this

05:41.070 --> 05:46.830
lecture and you'll remember when use the format paignton that we copy the format in here we hit format

05:46.830 --> 05:49.700
painter and then we copied the format in there.

05:49.860 --> 05:55.920
But if you double click the format painter it retains the formatting that you just copied until you

05:55.920 --> 05:57.350
hit the escape key.

05:57.390 --> 06:01.980
So just to show you that I'm just going to randomly pick one of the cells which you can see formatted

06:01.980 --> 06:03.790
differently to all of these.

06:03.800 --> 06:07.910
I'm going to double click the form painter and then I'm going to click there.

06:08.040 --> 06:13.440
So the formatting has been applied and you can see by the cursor the formatting has still been retained

06:13.440 --> 06:14.500
so wicked click there.

06:14.530 --> 06:16.970
There there there there there.

06:17.010 --> 06:18.050
Anywhere I wanted to.

06:18.070 --> 06:22.950
So if you have a bunch of data that you need to format in the same way but they're all over the place

06:23.160 --> 06:28.480
just double click the format pane sat and they all retain that formatting until you click escape.

06:28.650 --> 06:36.570
Okay let me just undo all of that here to escape an ego that completes the first lecture in the next

06:36.570 --> 06:40.770
lecture we're going to have a look at all the different keyboard shortcuts for quitting copying and

06:40.770 --> 06:41.930
all that kind of stuff.

06:42.000 --> 06:43.810
So I'll see you in the next lecture.
