Excel 2013: Simple Formulas GCFLearnFree.org English (auto-generated) English

Excel 2013: Simple FormulasYouTube↗ IA↗(long shot)
Education 187.9K views 467 likes 74 dislikes 10 Jun 2013 Show Contributors 1

LearnFree 1.2M subscribers N/A YouTube↗

Contributed subtitles

Spanish manuelalvarez62

Click to Play Video

Goodwill Community Foundation creating opportunities for a better life

remember using formulas to calculate math problems in school like two plus

Remember using formulas to calculate math problems in school, like 2 plus 2 equals 4,

two equals four or two pizzas times ten dollars equals twenty dollars Excel can

or 2 pizzas times $10 equals $20?

use these same formulas to work with numerical data in your spreadsheets just

Excel can use these same formulas to work with numerical data in your spreadsheets,

like a calculator Excel uses standard

just like a calculator.

operators for its math equations like a plus sign for addition a minus sign for

Excel uses standard operators for its math equations, like a plus sign for addition,

subtraction an asterisk for multiplication a forward slash for

a minus sign for subtraction, an asterisk for multiplication, a forward slash for division,

division and a carrot for exponents

and a caret for exponents.

you're probably used to seeing equations like five plus five equals but in excel the equal sign comes first this is

You're probably used to seeing equations like 5+5=, but in Excel, the equal sign comes first.

because the cell itself contains or is equal to the formula and its value let's

This is because the cell itself contains, or is equal to, the formula and its value.

create a simple formula to add up the budgets for June and July I've already

Let's create a simple formula to add up the budgets for June and July.

typed in those values and the total is going to be $1200 plus $1500 but instead

I've already typed in those values, and the total is going to be $1200 plus $1500.

of typing in those numbers we're going to use cell references start by clicking

But instead of typing those numbers, we're going to use cell references.

on the cell where you want the total to appear and then type an equal sign which

Start by clicking on the cell where you want the total to appear, and then type an equal

is how you'll always start a formula

sign, which is how you'll always start a formula.

then type the address of the first cell you want to add which is b2 plus the

Then, type the address of the first cell you want to add, which is B2, plus the second

second cell b3 when you're done press

ENTER on your keyboard and Excel displays the value in the cell now you

When you're done, press Enter on your keyboard, and Excel displays the value in the cell.

may be wondering why we used cell references instead of numbers the main

Now you may be wondering why we used cell references instead of numbers.

reason is that if you ever change the values in these cells you won't have to

The main reason is that if you ever change the values in these cells, you won't have

retype the formula Excel will automatically recalculate the answer so it stays up to date you should generally

to re-type the formula; Excel will automatically recalculate the answer so it stays up-to-date.

use cell references and your formulas whenever you can to edit your formula

You should generally use cell references in your formulas whenever you can.

you can double click the cell

To edit your formula, you can double-click the cell.

if you make a mistake or change your mind you can press escape on your

If you make a mistake or change your mind, you can press Escape on your keyboard, and

keyboard and it will go back to the way it was let's try another example this

it will go back to the way it was.

time with multiplication I want to

Let's try another example, this time with multiplication.

calculate the total price for the plastic silverware so I'll need to

I want to calculate the total price for the plastic silverware, so I'll need to multiply

multiply cell e4 by f4 the formula is

going in cell g4 so I'll click there and type an equal sign this time instead of

The formula is going in cell G4, so I'll click there and type an equal sign.

typing the cell references I'm going to

This time, instead of typing the cell references, I'm going to use something called the point

use something called the point and click

and click method.

method you may find that this is easier than typing them press the Enter key and

You may find that this is easier than typing them.

it calculates the answer finally I want

Press the Enter key, and it calculates the answer.

to show you a quick way to add a formula to several cells at once instead of

Finally, I want to show you a quick way to add a formula to several cells at once.

typing formulas for each of these three cells you can select the first one and

Instead of typing formulas for each of these three cells, you can select the first one,

then locate the fill handle in the lower right corner of the cell

and then locate the fill handle in the lower-right corner of the cell.

click and drag the fill handle down and when you release the mouse it will

Click and drag the fill handle down, and when you release the mouse it will automatically

automatically enter the formula into

enter the formula into these cells.

these cells now we can see the total cost for each item this is a great

Now, we can see the total cost of each item.

shortcut to use when you want to have similar formulas on each row once you're

This is a great shortcut to use when you want to have similar formulas on each row.

comfortable creating formulas you'll use them all the time because they really

Once you're comfortable creating formulas, you'll use them all the time because they

are one of the most powerful and convenient features of Excel

really are one of the most powerful and convenient features of Excel.

Similar videos:

Excel: Intro to Formulas
LearnFree
569.9K views 832 likes 50 dislikes 08 Feb 201669% match

Excel 2013: Complex Formulas
LearnFree
126.7K views 299 likes 41 dislikes 10 Jun 201360% match

Excel 2010: Simple Formulas
LearnFree
467.3K views 1.6K likes 75 dislikes 18 Nov 201060% match

Excel 2013: Cell References
LearnFree
173.9K views 433 likes 34 dislikes 10 Jun 201348% match

Excel 2013: Getting Started
LearnFree
273.3K views 809 likes 140 dislikes 19 Apr 201338% match

Excel 2013: Functions
LearnFree
130.4K views 256 likes 33 dislikes 10 Jun 201337% match

Excel 2013: Formatting Cells
LearnFree
152.5K views 236 likes 56 dislikes 19 Apr 201336% match

Excel 2013: Groups and Subtotals
LearnFree
326.7K views 494 likes 28 dislikes 26 Nov 201331% match

Excel 2013: Page Layout
LearnFree
313.6K views 525 likes 63 dislikes 19 Apr 201330% match

Excel: Creating More Complex Formulas
LearnFree
421.2K views 689 likes 75 dislikes 08 Feb 201629% match

New Features in Office 2013
LearnFree
240.4K views 331 likes 26 dislikes 05 Feb 201327% match

Excel 2013: Conditional Formatting
LearnFree
348.8K views 690 likes 47 dislikes 16 Dec 201325% match

Excel 2010: What-If Analysis
LearnFree
236.5K views 691 likes 31 dislikes 28 Feb 201125% match

Excel 2010: Conditional Formatting
LearnFree
452.8K views 1.2K likes 49 dislikes 28 Feb 201124% match

Excel 2010: PivotTables Part 1
LearnFree
241.2K views 1.6K likes 32 dislikes 16 Dec 201024% match

Excel: Cell Basics
LearnFree
533K views 599 likes 60 dislikes 08 Feb 201623% match

Word 2013: Getting Started
LearnFree
225.8K views 525 likes 110 dislikes 11 Mar 201323% match

Excel 2016: Saving and Sharing
LearnFree
468.6K views 875 likes 120 dislikes 08 Feb 201623% match

Excel: Functions
LearnFree
462.6K views 917 likes 57 dislikes 08 Feb 201622% match

Excel: Getting Started
LearnFree
1M views 1.2K likes 98 dislikes 08 Feb 201622% match

Excel: Charts
LearnFree
368.6K views 606 likes 58 dislikes 08 Feb 201622% match

Excel: Page Layout and Printing
LearnFree
825.9K views 2.1K likes 166 dislikes 08 Feb 201621% match

Excel 2010: Freezing Panes
LearnFree
230.5K views 762 likes 29 dislikes 04 Jan 201121% match

Excel: Sorting Data
LearnFree
582K views 1.5K likes 81 dislikes 08 Feb 201621% match

Excel: Relative and Absolute Cell References
LearnFree
923.8K views 4.1K likes 161 dislikes 08 Feb 201621% match

Excel: Working with Multiple Worksheets
LearnFree
341.9K views 517 likes 53 dislikes 08 Feb 201621% match

Excel: Creating and Opening Workbooks
LearnFree
426.5K views 396 likes 41 dislikes 08 Feb 201620% match

Excel: Understanding Number Formats
LearnFree
344.7K views 416 likes 47 dislikes 08 Feb 201620% match

Settings Privacy About Contact Donate