| Excel Training |
| Microsoft Word Training |
| Excel Formulas Book |
| About |
| Questions & Answers |
| Guestbook |
| A Full Excel Course |
|
|
| Place Value |
| Math Games |
| Rounding Games |
|
|
Excel Formulas - Tutorial Videos with Examples |
||
|
 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) |
|
|
Using cells from other worksheets inside a formula
|
||
|
You are welcome to have a look at my Free Math Games. |
||
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. The data used in the formulas does not have to appear only in the same worksheet. You can use values from cells from other worksheets inside a formula. Actually every formula can use data from multiple worksheets. |
|
|
|
