Excel 2007: Formulas

Excel can be used to calculate and analyze numerical information; however, you will need to know how to write formulas to maximize Excel's capabilities. A formula is an equation that performs a calculation using values in the worksheet. In this lesson you will learn how to create simple formulas using mathematical operators such as the addition, subtraction, multiplication, and division signs.

Formulas allow you to create a household budget or create complex spreadsheets that keep track of company finances or inventory.

In this free Excel tutorial we go over what formulas are and how to create them.

[GCFLearnFree]

@CJMND Thanks! Glad we could help! ^Jess

[GCFLearnFree]

@71579musiclover Thanks! Glad we could help! ^Jess

[Locket]

Thanks for the video, it was really helpful

[SuperMegooooooo]

thank y
and god will be with y
Egyptian student

[GCFLearnFree]

@PistolC In our newer videos, we no longer have the logo that covers part of the screen

[rohitsalvo]

its gud.. many people benefited by this. i guess

[laurieerlemeier]

Towards the end of the video, some of the point and click formula building is done off the work area. You can't see the Answer in the box the formula was created in.

[PistolC]

Its a bit pointless when we cant see what your doing with the cells further down I.E C30

[howdoideletethistoday]

this is possibly the most important tutorial and the screen doesn't show the actions.  "You can see the cursor is in C30..."    Ah, no we cannot. Disappointing!

[axiomk]

no I can't see that you've selected C30 because its not on the screen.If you want to do a better job I suggest a redo.Sorry.