Documentation/Tutorials

From Apache OpenOffice Wiki
Jump to: navigation, search
doc OOo


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
Personal tools