WEBVTT
Kind: captions
Language: en

00:00:08.620 --> 00:00:13.590
Most features in Microsoft Office, including
Excel, are geared towards saving and sharing

00:00:13.590 --> 00:00:15.350
files online.

00:00:15.350 --> 00:00:19.880
This is done with OneDrive, which is an online
storage space for your documents and files,

00:00:19.880 --> 00:00:23.320
so you can access them even when you’re
away from your computer.

00:00:23.320 --> 00:00:29.260
If you want to use OneDrive, make sure you’re
logged into Excel with your Microsoft account.

00:00:29.260 --> 00:00:34.420
Whether or not you’re using OneDrive, in
Excel most new projects begin the same way—with

00:00:34.420 --> 00:00:37.170
creating or opening a new, blank workbook.

00:00:37.170 --> 00:00:42.250
All you have to do is go to the backstage
view… and choose New.

00:00:42.250 --> 00:00:48.399
If you prefer to start from scratch, go ahead
and click the thumbnail that says Blank Workbook.

00:00:48.399 --> 00:00:51.350
But you can also start with a template.

00:00:51.350 --> 00:00:54.420
You'll find them in the very same place in
the backstage view.

00:00:54.420 --> 00:00:59.449
A template is a file that comes with its own
design and sometimes even complex formulas

00:00:59.449 --> 00:01:00.879
or formatting.

00:01:00.879 --> 00:01:05.449
They make it easy to create professional-looking
workbooks without a lot of time and effort.

00:01:05.449 --> 00:01:10.790
You can browse the ones you see here, or you
can search for something specific.

00:01:10.790 --> 00:01:15.660
If you see a template you like, just click
to view a preview… then click the Create

00:01:15.660 --> 00:01:18.010
button.

00:01:18.010 --> 00:01:20.590
Opening an existing workbook is also very
easy.

00:01:20.590 --> 00:01:25.590
Again, you'll want to go to the backstage
view… but this time, click Open in the left

00:01:25.590 --> 00:01:27.190
pane.

00:01:27.190 --> 00:01:31.270
If the workbook you're looking for is something
you've worked on recently, it might be listed

00:01:31.270 --> 00:01:33.180
under Recent Workbooks.

00:01:33.180 --> 00:01:38.030
In fact, you can "pin" certain workbooks here,
so you always have access to your most frequently

00:01:38.030 --> 00:01:40.160
used files.

00:01:40.160 --> 00:01:45.750
All you have to do is move your cursor over
the file, then click the pushpin icon.

00:01:45.750 --> 00:01:49.400
To unpin it, click the icon again.

00:01:49.400 --> 00:01:54.490
You can pin as many workbooks as you want.

00:01:54.490 --> 00:01:59.050
If the file you're looking for hasn't been
opened recently, just look to the other options.

00:01:59.050 --> 00:02:04.080
For example, under OneDrive, you can access
files that are saved online to your OneDrive

00:02:04.080 --> 00:02:05.980
account.

00:02:05.980 --> 00:02:10.140
Under This PC, you can access files that are
saved locally.

00:02:10.140 --> 00:02:16.540
Or you can click Browse… then select the
workbook you want.

00:02:16.540 --> 00:02:22.980
When you're ready, click Open… and the workbook
will appear.

00:02:22.980 --> 00:02:25.930
Now you know how to create and open workbooks
in Excel.

