Formulas - Auto Update
Desktop Apps Training - Calc

When you work on your sheet, you will probably like it to show your changes and update automatically. This is easily done by choosing Tools on the Menu bar and Cell Contents and then make sure there is a check mark in front of AutoCalculate.