1
00:00:04,500 --> 00:00:09,600
In this section you're going to learn all about worksheet navigation. For example, you're going to learn

2
00:00:09,600 --> 00:00:14,340
some useful shortcuts that will help you navigate large data faster.

3
00:00:14,400 --> 00:00:20,430
You're also going to learn how to copy an entire sheet or move it someplace else and also how you can

4
00:00:20,430 --> 00:00:22,140
hide it from view.

5
00:00:22,140 --> 00:00:27,590
We'll also go over efficient methods of scrolling and reviewing large datasets.

6
00:00:28,020 --> 00:00:30,120
When we cover copying and pasting data.

7
00:00:30,570 --> 00:00:33,810
I'm gonna take you through some hidden paste features.

8
00:00:33,870 --> 00:00:37,760
It's actually surprising what paste is capable of doing.

9
00:00:38,550 --> 00:00:45,660
We will then finalize the section by taking a look at how you can protect your worksheets and your formulas.

10
00:00:45,660 --> 00:00:50,040
If you're designing workbooks or reports for others to use

11
00:00:50,400 --> 00:00:57,600
You probably want to take some steps to make sure that the report isn't unintentionally or intentionally

12
00:00:57,600 --> 00:00:58,740
changed.

13
00:00:58,740 --> 00:01:03,630
We're going to take a look at what's possible in Excel and how you can add some level of protection

14
00:01:03,840 --> 00:01:05,069
to your work.

15
00:01:05,069 --> 00:01:07,380
Let's start off with some useful shortcuts.