From Apache OpenOffice Wiki
| Tiago's Tutorials
|
|
|
You can find the link to his free course here: https://yewtu.be/playlist?list=PLFM03zQeSz2Nt0Tg8HtCjdY683hJ6mauj
The contents is as follows:
- 13/06/2020 - How to get numbers going down a column in multiples (OpenOffice 4)
- - https://youtu.be/yhJ7f85oios
- 22/06/2020 - How to sum up columns of numbers (with a currency) using OpenOffice 4
- - https://youtu.be/OpWzMoqSJkY
- 22/06/2020 - How to get the percentages of values in a column, relative to one specific value (OpenOffice 4)
- - https://youtu.be/dMwh4DQ5wQ8
- 22/06/2020 - How to save and password protect your spreadsheet file (OpenOffice 4)
- - https://youtu.be/VbtzTR8RgJY
- 24/06/2020 - How to increase the size of many cells with overlapping text - all at once (OpenOffice 4)
- - https://youtu.be/rIUhDqPduHI
- 24/06/2020 - How to sum up values associated with multiple names - all at once [SUMIF] (OpenOffice 4)
- - https://youtu.be/WFst-T997K4
- 25/06/2020 - How to sum up all the values associated with a specific name in a list (OpenOffice 4)
- - https://youtu.be/M2BQSWICh8k
- 09/09/2020 - How to Create a Line Chart using OpenOffice 4 [Applied Statistics]
- - https://youtu.be/b0NKo1VUmoY
- 09/09/2020 - How to Create a Pie Chart using OpenOffice 4 [Applied Statistics]
- - https://youtu.be/CgLcZjkG1eY
- 11/09/2020 - How to Sum up Cells from Different Sheets, OpenOffice [Spreadsheet Tricks]
- - https://youtu.be/IzXObOPh0Lg
- 15/09/2020 - How to Make Grid Lines Invisible on OpenOffice [Free Spreadsheet Tutorial]
- - https://youtu.be/K8Tt6VJPhgg
- 17/09/2020 - How to make Days and Dates go down a Column in Corresponding Order [OpenOffice Spreadsheets]
- - https://youtu.be/GX1uMpHDFR8
- 06/10/2020 - How to Calculate Percentage Changes using Open Office and Format in Colour (Conditional Formatting)
- - https://youtu.be/Gsln3Cp21h0
- 15/03/2021 - How to Quickly Create a Table with the Powers of Ten In Digits (OpenOffice Spreadsheets)
- - https://youtu.be/OwIPln1w81M
- 15/03/2021 - How to automatically mimic data from the column on one sheet to another sheet (OpenOffice)
- - https://youtu.be/cITJVqGPMRo
- 18/03/2021 - Find amount of days that have passed between two dates - OpenOffice Calc
- - https://youtu.be/jKQvkxDu2ew
- 20/03/2021 - Conditional formatting: How to highlight specific text in a list (OpenOffice Calc)
- - https://youtu.be/nH0Deh0xxEc
- 20/03/2021 - How to graph in 2 dimensions using OpenOffice Calc [Example: y=x^2]
- - https://youtu.be/RsR-85rNDKc
- 31/03/2021 - How to do basic probabilities using OpenOffice Calc [Example: Dice Roll]
- - https://youtu.be/Q4uVIecc22E
- 23/04/2022 - How to Transform Date Text to Date Formatted Text (OpenOffice Calc)
- - https://youtu.be/DUIbwVTJrJc
- 17/08/2022 - OpenOffice Calc 4 Tricks: How to Create New Lines within 1 Cell [CTRL+Enter]
- - https://youtu.be/W9sN7xQmAwM
- 22/08/2022 - OpenOffice Calc 4, Productivity: How to Apply and Use The Auto-Filter Feature
- - https://youtu.be/wKC1THOaeHE
- 22/08/2022 - OpenOffice 4 Calc: Bold, Italic and Underline Keyboard Tricks to Save Time & Energy
- - https://youtu.be/fO9ccEtxhg4
- 27/08/2022 - OpenOffice 4 Calc: How to Create Vertical and Horizontal Pivot Tables Instantly * Save Time
- - https://youtu.be/TANbYgdHFDU
- 29/08/2022 - OpenOffice 4 Calc: How to Wrap Your Text and Keep it Within Boundaries
- - https://youtu.be/Pzm6aZOh05c
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
Also mentioned on the user Forum here
| Dennis Daniels' Tutorials
|
|
Carlo Daffara's Tutorials
|
|
|
|
|
| |
|
|
| Dai's Tutorials
|
|
Horst Jens' Tutorials
|
|
|
|
|
|
