WEBVTT
Kind: captions
Language: en

00:00:11.839 --> 00:00:13.909
We're going to talk about some of the things
you

00:00:13.909 --> 00:00:15.909
can do to finalize a workbook.

00:00:15.909 --> 00:00:22.610
It's a good idea to do these things if you're
going to be sending it out or publishing it.

00:00:22.610 --> 00:00:26.449
Just like with any document, you should spellcheck
your workbooks.

00:00:26.449 --> 00:00:28.310
Even if you mostly just have numbers,

00:00:28.310 --> 00:00:33.480
you probably have headers or other text
that could have spelling errors.

00:00:33.480 --> 00:00:41.219
Just go to the Review tab, and then click
Spelling.

00:00:41.219 --> 00:00:45.370
If you've used Microsoft Word, the spellcheck
works the same way,

00:00:45.370 --> 00:00:49.710
and it gives you several
different options for each misspelled word.

00:00:49.710 --> 00:00:54.440
In this case, the spellcheck caught the word
"Geb", which is the name of this company.

00:00:54.440 --> 00:00:57.520
So that's not actually a misspelling, and
I'm

00:00:57.520 --> 00:00:59.110
going to add it to the dictionary,

00:00:59.110 --> 00:01:02.550
so it won't
come up as an error again.

00:01:02.550 --> 00:01:05.830
Now this is a misspelled word, so I'll select
the

00:01:05.830 --> 00:01:06.830
word I want

00:01:06.830 --> 00:01:13.270
from the list of suggestions, and then
click Change.

00:01:13.270 --> 00:01:15.009
If it asks you if you want to continue checking
at

00:01:15.009 --> 00:01:16.499
the beginning of the sheet,

00:01:16.499 --> 00:01:20.460
click Yes so it will
check the whole sheet.

00:01:20.460 --> 00:01:21.630
And here's another misspelling.

00:01:21.630 --> 00:01:28.840
And that's it.

00:01:28.840 --> 00:01:31.240
The next thing I'm going to do is inspect
this

00:01:31.240 --> 00:01:32.909
workbook.

00:01:32.909 --> 00:01:37.729
This will tell me whether there is hidden
information that I need to remove.

00:01:37.729 --> 00:01:40.959
Click the File tab.

00:01:40.959 --> 00:01:48.509
And then go to Check for Issues, and Inspect
Document.

00:01:48.509 --> 00:01:52.850
If you have unsaved changes in your workbook,
you'll see this message,

00:01:52.850 --> 00:01:58.920
and you can just click
Yes to save it.

00:01:58.920 --> 00:02:01.789
You can just leave all of these boxes checked,
and

00:02:01.789 --> 00:02:09.800
then click Inspect.

00:02:09.800 --> 00:02:11.840
It looks like the Document Inspector did find
some

00:02:11.840 --> 00:02:12.840
information

00:02:12.840 --> 00:02:16.150
because there is an exclamation point
here.

00:02:16.150 --> 00:02:18.900
Now you don't have to remove this information;

00:02:18.900 --> 00:02:22.750
you can just use the
Document Inspector to see what it finds.

00:02:22.750 --> 00:02:24.520
But generally it's just going to be things
like

00:02:24.520 --> 00:02:28.290
the Author's name, or the printer properties.

00:02:28.290 --> 00:02:30.180
I'm going to remove it because the people
that I'm

00:02:30.180 --> 00:02:31.430
sending this file to

00:02:31.430 --> 00:02:34.920
don't really need to have
this information.

00:02:34.920 --> 00:02:42.680
Then, you can close this window.

00:02:42.680 --> 00:02:45.069
The last thing I'm going to do is protect
this

00:02:45.069 --> 00:02:46.530
workbook.

00:02:46.530 --> 00:02:50.340
Go to Protect Workbook.

00:02:50.340 --> 00:02:52.610
And you have several different options.

00:02:52.610 --> 00:02:54.939
Some of them offer stronger protection, such
as

00:02:54.939 --> 00:02:56.730
Encrypt with Password,

00:02:56.730 --> 00:03:00.510
which is good for really
important or sensitive workbooks.

00:03:00.510 --> 00:03:02.980
But I don't need that much security for this
one,

00:03:02.980 --> 00:03:05.849
so I'm going to select Mark as Final,

00:03:05.849 --> 00:03:07.909
which will
discourage people from editing it

00:03:07.909 --> 00:03:13.040
and also let them
know that it's the final version.

00:03:13.040 --> 00:03:17.200
Then click OK.

00:03:17.200 --> 00:03:20.519
And click OK again.

00:03:20.519 --> 00:03:24.870
Now, when somebody opens the file, they'll
see

00:03:24.870 --> 00:03:27.909
this bar at the top of the window,

00:03:27.909 --> 00:03:30.480
and they won't
be able to type or delete anything.

00:03:30.480 --> 00:03:36.049
However, if somebody needs to edit the workbook,
they can just click Edit Anyway.

00:03:36.049 --> 00:03:39.270
That means this isn't providing actual security,

00:03:39.270 --> 00:03:41.640
but it does keep people from accidentally
changing

00:03:41.640 --> 00:03:43.560
or deleting something.

00:03:43.560 --> 00:03:45.209
And if you need stronger security, you'll
need to

00:03:45.209 --> 00:03:49.030
choose one of the other options.

00:03:49.030 --> 00:03:52.150
So this workbook is finalized now, and I'm
ready

00:03:52.150 --> 00:04:17.380
to send it out.