The Basics Calculations Special Features
Format Cells Statistical Functions The Fill Handle
Worksheets Quick Functions Charts (Graphs)
Edit Cells The IF Function Sort Data
Rows and Columns VLOOKUP Function Filter Data
Find and Replace Formulas First Aid
Home
Word Training
Updates
About
Guestbook
Links

Working with Formulas

The very basics of formulas
Two simple examples
Using the fill handle with formulas
Understanding absolute and relative referencing
Simple examples with absolute referencing
       (calculating tax, and bank deposit interest)

A formula is a way for you to make calculations based upon data written in the spreadsheet.

What’s best about formulas is that they are linked to the data in such a way that if the data changes, the formula gives an updated result, reflecting the change.

The fill handle is especially useful, as often you need to repeat the same formula many times. In such cases using the handle can be a great time saver.