• 1 year ago
Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.

In this video lesson, we will learn about Navigating in Excel in Microsoft Excel

You can access the entire Microsoft Excel Course in the following playlist:
https://www.dailymotion.com/playlist/xa9hyw

Category

📚
Learning
Transcript
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.

Recommended