Excel Basics Calculations Special Features
Format Cells Sum, Average, Countif Functions Charts (Graphs)
Worksheets Quick Functions Sort Data
Edit Cells The IF Statement Filter Data
Rows and Columns VLOOKUP Function Conditional Formatting
Find and Replace Excel Formulas Pivot Table
The Fill Handle First Aid
Excel Training
Microsoft Word Training
About
Ask your question here
Guestbook
Excel Course CD

Excel Formulas - Tutorial Videos

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)

What is a formula in Excel?

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.

One of the important parts of learning formulas is understanding the concepts of absolute referencing and relative referencing. Take the time to watch the video dealing with it, and the next one with simple examples demonstrating how it is been implemented in the formulas.



Website Statistics