00:00So over here in Excel, when you want to go ahead and navigate around between
00:10data, you can go ahead and use your mouse cursor to go ahead and click in
00:14different places as you like right here. Apart from that, you can also go ahead
00:19and utilize the arrow keys right here just like this and then navigate to the
00:24data that you want. Apart from that, you can use the scroll mouse button to go
00:29ahead and scroll down or up as you can see right here. On your keyboard, you can
00:35actually also enable scroll lock right here so that whenever you use your arrows
00:40instead of actually going around and then let's say for example changing in
00:47between cells, it actually goes ahead and then changes out the view right here.
00:55Turn the scroll lock off and then when you use the arrow keys, you simply have
01:00the navigation for the cells right here. Apart from that, if you want to go ahead and
01:06let's say for example move a cell data from here to here, you can simply click and drag
01:11around over here so you can see that this is what you have right here. I can go
01:15around and then you move this cell right here by clicking and dragging on the
01:20corner handles right here. If I were to click and drag certain data, you can see
01:25that you can go ahead and duplicate it out right here. But if I were to hold, let's
01:29say for example control right here, then what happens is that it simply adds in the
01:34data right here. Similarly, you may have repetitive data like this and if I were to
01:39actually go ahead and click and drag this, you can see that it averages it out and
01:44tries to continue out with the data right here. For example, there's 55, 500, let's
01:50say for example, and then if you were to click and drag up the data, you can see
01:54that it goes ahead and adds in 500 right here to maintain out consistency right here
02:00just like this. And same goes with the date as well. You can go ahead and click and
02:04drag it out. Then you can see that it tries to maintain consistency. Let's say I type in
02:09something like Sunday and click and drag. And then you can see that it changes out
02:13the dates right here. Let me just type in Jan. Let's say for example, click and drag it.
02:18Then you have that just like this. You need to press control for this. But if I were to
02:23press control, you can see that it simply goes ahead and copies and paste them out.
02:27And that is simply how you can go ahead and use the navigational tools inside of Excel
02:33and even place out the data as you like by utilizing various things as to
02:38continue the data in Excel. And as we move along the course, we're going to go
02:43around and see how we can actually go ahead and utilize these features to keep
02:48our data as needed. So I hope you found this video useful. Be sure to hit the like
02:53button. Don't forget to share this out with your friends and family. And for more
02:58contents like these, do follow simple tutorials.