WEBVTT
Kind: captions
Language: en

00:00:09.520 --> 00:00:16.050
Remember using formulas to calculate math
problems in school, like 2+2=4, or 2 pizzas

00:00:16.050 --> 00:00:19.360
x $10 dollars = $20?

00:00:19.360 --> 00:00:23.840
Excel can use these same formulas to work
with numerical data in your spreadsheets,

00:00:23.840 --> 00:00:26.750
just like a calculator.

00:00:26.750 --> 00:00:32.210
Excel uses standard operators for its math
equations, like a plus sign for addition,

00:00:32.210 --> 00:00:38.480
and a minus sign for subtraction; an asterisk
for multiplication, and a forward slash for

00:00:38.480 --> 00:00:43.000
division; and a carat for exponents.

00:00:43.000 --> 00:00:49.100
You're probably used to seeing equations like
5+5=_, but in Excel, the equal sign comes

00:00:49.100 --> 00:00:50.120
first.

00:00:50.120 --> 00:00:57.110
This is because the cell itself contains,
or is equal to, the formula and its value.

00:00:57.110 --> 00:01:01.110
We'll start things off slow with a simple
multiplication formula, to figure out the

00:01:01.110 --> 00:01:04.739
total cost of paint for a list of remodeling
projects.

00:01:04.739 --> 00:01:08.790
As you can see, I've done some research on
price and the amount of paint I'm going to

00:01:08.790 --> 00:01:13.220
need - $30x6 gallons of paint.

00:01:13.220 --> 00:01:17.300
To create a formula, just click where you
want the total to appear, and begin with an

00:01:17.300 --> 00:01:18.740
equal sign.

00:01:18.740 --> 00:01:24.910
We're going to do 30x6, using the asterisk
for multiplication.

00:01:24.910 --> 00:01:30.350
Now press Enter on your keyboard, and Excel
displays the value in the cell.

00:01:30.350 --> 00:01:33.860
Another way to create formulas is to use cell
references.

00:01:33.860 --> 00:01:39.610
A cell reference is when your formula contains
cell addresses (like F8 or F9) instead of

00:01:39.610 --> 00:01:41.720
the numbers in those cells.

00:01:41.720 --> 00:01:44.740
Let's give it a try on the total estimated
budget.

00:01:44.740 --> 00:01:52.750
Rather than calculating 700+550 (the values
in cells F8 and F9), we'll write the formula

00:01:52.750 --> 00:01:58.330
this way: F8+F9.

00:01:58.330 --> 00:02:04.690
That totals the numbers in F8 and F9, whether
you leave the budget at 700 and 550, or change

00:02:04.690 --> 00:02:10.310
it to something else, say 800 and 650.

00:02:10.310 --> 00:02:12.750
The total recalculates automatically.

00:02:12.750 --> 00:02:17.400
That's why cell references are so convenient;
they make it possible to update your worksheet

00:02:17.400 --> 00:02:21.860
without ever having to rewrite the values
in your formulas.

00:02:21.860 --> 00:02:26.110
You can also use something called the point
and click method to make cell references.

00:02:26.110 --> 00:02:28.040
This one is a great time-saver.

00:02:28.040 --> 00:02:32.350
Now that I've calculated my estimated budget,
why don't we find out how much is left after

00:02:32.350 --> 00:02:34.780
taking my wish list into account?

00:02:34.780 --> 00:02:39.640
That means I'll need to subtract my wish list
total from my estimated budget, so - I'm going

00:02:39.640 --> 00:02:45.310
to start my equation, then just click this
cell to make reference to it.

00:02:45.310 --> 00:02:50.310
Now type your operator (in my case, a minus
sign) and click the next cell you want in

00:02:50.310 --> 00:02:52.050
your formula.

00:02:52.050 --> 00:02:54.760
Press Enter, and the total appears.

00:02:54.760 --> 00:02:57.900
Editing formulas is also just a click away.

00:02:57.900 --> 00:03:02.100
Click the cell you want to edit, and then
come up here to make your changes in the Formula

00:03:02.100 --> 00:03:03.900
Bar.

00:03:03.900 --> 00:03:08.160
If you make a mistake or change your mind,
just use the Cancel command, and you'll avoid

00:03:08.160 --> 00:03:11.370
making any unwanted changes.

00:03:11.370 --> 00:03:17.090
You can also double-click the cell, and make
your changes right there.

00:03:17.090 --> 00:03:20.090
Simple formulas and cell references are easy
to use.

00:03:20.090 --> 00:03:44.040
Why not give them a try, and let Excel do
the math?