Powerpoint

1. When designing the master slide. If one uses the master slide's text boxes, it will only remember font, colour and other formats. But if one wants there to be content exactly the same on every slide, he must manually add a text box and place content in there, including a continous title, page number, ...etc.

Spreadsheets (Excel)

1.  import: csv (comma separated value file) (known as standardised format for all computers, can be read by all computers) (when opening in an exam, save as excel workbook)
2. Absolute and relative references (Absolute means it will absolutely always refer to that cell) (relative means it change if a formula is copied and pasted dependant on where it has been pasted) (use '$' sign to make a reference absolute)
3. Named cells, named ranges (A named cell is an automatic absolute reference) (Named ranges is naming a cell) (This makes reading formulae easier)
4. sum, average, maximum, minimum, integer, rounding, counting, if, lookup
5. perform searches using AND, OR, NOT, LIKE (cuts down searches like search engine "Google")
6. perform search using wildcard (wildcard is a *) (It broadens searches)