Excel 2010 Tutorial HD - Simple Formulas

http://www.GCFLearnFree.org

Excel can be used to calculate numerical information. In this lesson you will learn how to create simple formulas in Excel to add, subtract, multiply, and divide values in a workbook. Also, you will learn the various ways you can use cell references to make working with formulas easier and more efficient.

A formula is an equation that performs a calculation. Like a calculator, Excel can execute formulas that add, subtract, multiply, and divide.

One of the most useful features of Excel is its ability to calculate using a cell address to represent the value in a cell. This is called using a cell reference.

In order to maximize the capabilities of Excel, it is important to understand how to create simple formulas and use cell references.

Watch the video to learn about simple formulas in Excel 2010.

Category:

Education

Tags:

• Microsoft Excel
• MS Excel
• tutorials
• spreadsheet
• workbooks
• Excel
• formulas
• how to
• Excel 2010
• computer help
• video tutorials
• Excel tutorials

[Sebhelyes22]

A real professional standard tutorial whcih is free, you have earned another subscriber.

[gcflearnfree]

@Sebhelyes22 Thanks! Feel free to spread the word! ^Jess

[theClickchick]

Thanks, this was a great tutorial. It's been a number of years since I've used Excel and I've never been very proficient with it. Your tutorials will make learning much easier. Thanks again!

[gcflearnfree]

@theClickchick Thanks! Glad we could help! ^Jess

[ashe140140]

What about adding the column with more then two cells?

[gcflearnfree]

@ashe140140 You can add as many numbers or cells as you want. All you have to do is keep listing them in the formula, separated by a plus sign. For example:

=5+5+5+5 or

=C7+C8+C9+C10

To learn more, try our video on complex formulas ("Excel 2010: Complex Formulas"), found in our Excel playlist.

[CharanSinghMaratha]

very nice coaching from u dear but add more useful functions in your tutorial .... thank you very much for your clip

[MrWerdna92]

Thanks, really helpful :)

[014jawad]

thanks



[MatTAFacT]

Thanks so much!!