Documentation/Tutorials

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 OpenOffice.org Opening and Editing Templates (SWF) OpenOffice.org Inserting Headers and Footers (SWF) OpenOffice.org Word Count (SWF) OpenOffice.org Base How to CSV Imports (SWF) Graphing Non-Linear Equations with OpenOffice.org (SWF) OpenOffice.org COSing from neg 10 to pos 10 (SWF) OpenOffice.org Calc tutorial (PDF) OpenOffice.org Impress tutorial (PDF) OpenOffice.org Writer tutorial (PDF) Dai's Tutorials Horst Jens' Tutorials All Tutorials (HTML/SWF) Adding a List Box (SWF) Changing Tab Order (SWF) Creating a Database (SWF) Creating Tables (SWF) Making Data Entry Easy (SWF) Adding a Combo Box (SWF) Changing The Sort Order (SWF) Creating a Form (SWF) Creating a Query (SWF) Changing the Join Type (SWF) Creating Relations (SWF) Creating a Report (SWF) Viewing Data (SWF) Tab Order and Focus (SWF) Form Desgin (SWF) Creating Labels From a Database (FLV) Using filters with mailmerge (FLV) Creating a Form Letter Using a Datasource (FLV) Registering a database in OpenOffice Writer (FLV) All tutorials (external) OpenOffice Writer: making a shopping list with tabs (external) OpenOffice Calc: making a nice-looking diagram (external) OpenOffice Writer: Inhaltsverzeichnis (external, German) OpenOffice Writer: Inhaltsverzeichnis (external, Chinese) OpenOffice Calc: Der SVerweis (external, German)