From Apache OpenOffice Wiki
Tiago's Tutorials
|
|
You can find the link to my free course here: https://youtube.com/playlist?list=PLFM0 ... 683hJ6mauj
The contents is as follows:
Here is some code you might need to create some of the tables seen in the videos:
- SUMIF FUNCTION: =SUMIF(A7:A41; "Broadband"; E7:E41)
- SPECIAL SUMIF: =SUMIF($C$8:$C$12; "Bob"; $D$8:$D$12)
- SUPER SPECIAL SUMIF: =SUMIF($C$8:$C$12; $A1; $D$8:$D$12)
- SUPER SPECIAL SUMIF, DIFFERENT SHEETS: =SUMIF(Sheet.$A$1:$A$5; $C1; Sheet.$B$1:$B$5)
- MATCH FUNCTION: =MATCH(B2;$A$1:$A$2739;0)
- ISNUMBER MATCH, TRUE OR FALSE:=ISNUMBER(MATCH(E22;$C$8:$C$12;0))
- SELECTION LIST: Right Click > Selection List
- TAB: Move between boxes.
- HIT ENTER: To select pre-determined outputs.
- FIND AND REPLACE: Find and replace letters.
- FILTER: Data > Filter
- SORT (Sort Lists): Data > SORT
Dennis Daniels' Tutorials
|
|
Carlo Daffara's Tutorials
|
|
|
|
|
|
|
Dai's Tutorials
|
|
Horst Jens' Tutorials
|
|
|
|
|