WEBVTT
Kind: captions
Language: en

00:00:07.000 --> 00:00:11.790
Let's jump right in and start creating our
first Excel spreadsheet.

00:00:11.790 --> 00:00:17.590
When you first open Excel, the software opens
to a new, blank workbook.

00:00:17.590 --> 00:00:23.380
If you already have a spreadsheet open and
want to create a new one, just click the Microsoft

00:00:23.380 --> 00:00:29.330
Office Button and select New.
The New Workbook dialog box opens.

00:00:29.330 --> 00:00:34.340
Blank document is highlighted by default,
so go ahead and click Create.

00:00:34.340 --> 00:00:40.450
Now your new, blank workbook appears in the
window.The next you thing you need to know

00:00:40.450 --> 00:00:45.110
is how to insert text.
All the little rectangles you see are called

00:00:45.110 --> 00:00:49.910
cells.
These cells will be where your text appears.

00:00:49.910 --> 00:00:55.039
Each cell has a name, or a reference based
on the column and row it is in.

00:00:55.039 --> 00:01:01.680
For example, this cell is C3 since it is in
column C and row 3.

00:01:01.680 --> 00:01:08.360
This cell is where that column and row intersect.
Looks like we're ready to add some text.

00:01:08.360 --> 00:01:13.360
I want to work on creating a spreadsheet that
will help me keep track of my monthly expenses,

00:01:13.360 --> 00:01:18.640
so let's select cell A1.
As you select the cell, you will see the name

00:01:18.640 --> 00:01:29.150
of that cell appear in the name box.
Let's type Monthly Budget.You can see as you

00:01:29.150 --> 00:01:35.820
type that the text appears in cell A1 and
in this box which is called the formula box.

00:01:35.820 --> 00:01:40.890
This is where any formulas or text you write
in the cells will appear.

00:01:40.890 --> 00:01:45.700
As I click off of the cell, you'll notice
the text extends past the column line.

00:01:45.700 --> 00:01:50.159
That's OK.
You can change this later.

00:01:50.159 --> 00:01:54.700
Since I want to keep my budget for the entire
year, I should probably make columns for each

00:01:54.700 --> 00:02:01.700
month I receive bills.
Let's go down to 7C and type January, use

00:02:05.210 --> 00:02:15.560
the Tab key to tab over to 7D and type February.
Next we'll go to 7E and type March,

00:02:15.560 --> 00:02:19.500
and so forth.
Keep in mind that you can move from cell to

00:02:19.500 --> 00:02:25.300
cell using the Tab key, the arrows on your
computer or by simply using your mouse to

00:02:25.300 --> 00:02:30.640
select a specific cell.
The Page Up and Down buttons on your keyboard

00:02:30.640 --> 00:02:33.709
will help you navigate the spreadsheet, as
well.

00:02:33.709 --> 00:02:43.890
Now, in 7A, let's type Bills.
In this column, we'll type out all the categories

00:02:43.890 --> 00:02:50.540
of bills we need to pay each month.
I'll start in 8A with some of my expenses

00:02:50.540 --> 00:02:54.170
like my rent.
If I owned my house, I could put my mortgage

00:02:54.170 --> 00:02:59.879
payment here.
I'll press the arrow key down and in 9A enter

00:02:59.879 --> 00:03:13.760
Car Payment, then in 10A put Life Insurance.
If I make a mistake, I can simply use the

00:03:13.760 --> 00:03:19.909
Backspace key to make the correction or if
I've already moved on and then decide I want

00:03:19.909 --> 00:03:24.390
to delete all the text in the cell, I can
simply select the cell and then press the

00:03:24.390 --> 00:03:34.120
Delete key on the keyboard.You also have the
option to make changes to the text from the

00:03:34.120 --> 00:03:38.330
formula box.
See, if I want to change Life Insurance to

00:03:38.330 --> 00:03:45.330
Health Insurance, I can select the cell and
make the changes directly in the formula box.

00:03:46.069 --> 00:03:59.140
Some people find this easier but you decide
what works for you! In cell 7B, let's type Date.

00:03:59.140 --> 00:04:06.140
Now in this column, I can type 
the date my bills are due.

00:04:07.790 --> 00:04:11.879
When you're ready to save the workbook,
click the Microsoft Office button. If this is the first 
time you are saving the

00:04:11.879 --> 00:04:18.620
file you'll want to select Save As.
Save as allows you to name the file whatever

00:04:18.620 --> 00:04:24.550
you would like and also choose the location
where you'd like to save the file.

00:04:24.550 --> 00:04:30.780
Next I'm going to click on Excel Workbook.
This is because I want to save my file as

00:04:30.780 --> 00:04:37.780
an Excel workbook.
Next I'm going to save my file to the desktop

00:04:37.990 --> 00:04:48.820
and name my file Household Budget.
Then click Save.

00:04:48.820 --> 00:04:54.759
If I'm sending my file to someone who does
not have Excel 2007, I can save my file as

00:04:54.759 --> 00:05:01.250
an Excel 97-2003 workbook.
This way the other person does not have to

00:05:01.250 --> 00:05:06.750
have Excel 2007 to share and edit the workbook
I created.

00:05:06.750 --> 00:05:11.710
I successfully saved my file and I'm ready
to move forward with my budget!