1. Referencing: relative and absolute.
2. Coding date and time In Calc. Date and time calculations.
3. Sheet protection – enabling editing of selected cells only.
4. Validation of cell contents (Data->Validity). The use of „list” option.
5. Hiding/showing formula results based on the IF function.
6. Conditional formatting („Cell value is” and „Formula is” options).
7. Formulating complex logical conditions using logical functions (AND, OR, NOT).
8. Solutions with multiple worksheets (with cross-referencing between sheets).
9. Recursive formulas with conditional function (example: cumulating interest only up to the end of the month).
10. Using form controls – spin button, list box, option buttons.
11. Creating „dynamic” charts – showing different data, dependent on the choice of parameters by the user.
12. General rules – parameterization, layout design (transparency and convenience), efficiency (wherever possible: a single formula and its copying).
13. The use of selected functions:
• IF, AND, OR, NOT
• DAY, MONTH, YEAR, WEEKDAY
• RAND
• COUNTIF, SUMIF
• VLOOKUP, HLOOKUP
• INDEX, MATCH
• LARGE, SMALL
• CORREL, ABS
• PPMT, IPMT
• ISODD, ISEVEN
