Documentation/Tutorials

doc

OOo

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: 13/06/2020 - How to get numbers going down a column in multiples (Open Office 4) - https://youtu.be/yhJ7f85oios 22/06/2020 - How to sum up columns of numbers (with a currency) using Open Office 4 - https://youtu.be/OpWzMoqSJkY 22/06/2020 - How to get the percentages of values in a column, relative to one specific value (Open Office 4) - https://youtu.be/dMwh4DQ5wQ8 22/06/2020 - How to save and password protect your spreadsheet file (Open Office 4) - https://youtu.be/VbtzTR8RgJY 24/06/2020 - How to increase the size of many cells with overlapping text - all at once (Open Office 4) - https://youtu.be/rIUhDqPduHI 24/06/2020 - How to sum up values associated with multiple names - all at once [SUMIF] (Open Office 4) - https://youtu.be/WFst-T997K4 25/06/2020 - How to sum up all the values associated with a specific name in a list (Open Office 4) - https://youtu.be/M2BQSWICh8k 25/06/2020 - How to sum up all the values associated with a specific name in a list (Open Office 4) - https://youtu.be/M2BQSWICh8k 09/09/2020 - How to Create a Line Chart using Open Office 4 [Applied Statistics] - https://youtu.be/b0NKo1VUmoY 09/09/2020 - How to Create a Pie Chart using Open Office 4 [Applied Statistics] - https://youtu.be/CgLcZjkG1eY 11/09/2020 - How to Sum up Cells from Different Sheets, Open Office [Spreadsheet Tricks] - https://youtu.be/IzXObOPh0Lg 15/09/2020 - How to Make Grid Lines Invisible on Open Office [Free Spreadsheet Tutorial] - https://youtu.be/K8Tt6VJPhgg 17/09/2020 - How to make Days and Dates go down a Column in Corresponding Order [Open Office 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 (Open Office Spreadsheets) - https://youtu.be/OwIPln1w81M 15/03/2021 - How to automatically mimic data from the column on one sheet to another sheet (Open Office) - https://youtu.be/cITJVqGPMRo 18/03/2021 - Find amount of days that have passed between two dates - Open Office Calculator - https://youtu.be/jKQvkxDu2ew 20/03/2021 - Conditional formatting: How to highlight specific text in a list (Open Office Calculator) - https://youtu.be/nH0Deh0xxEc 20/03/2021 - How to graph in 2 dimensions using Open Office Calculator [Example: y=x^2] - https://youtu.be/RsR-85rNDKc 31/03/2021 - How to do basic probabilities using Open Office Calculator [Example: Dice Roll] - https://youtu.be/Q4uVIecc22E 23/04/2022 - How to Transform Date Text to Date Formatted Text (Open Office Calculator) - https://youtu.be/DUIbwVTJrJc 17/08/2022 - Open Office Calculator 4 Tricks: How to Create New Lines within 1 Cell [CTRL+Enter] - https://youtu.be/W9sN7xQmAwM 22/08/2022 - Open Office Calculator 4, Productivity: How to Apply and Use The Auto-Filter Feature - https://youtu.be/wKC1THOaeHE 22/08/2022 - Open Office 4 Calculator: Bold, Italic and Underline Keyboard Tricks to Save Time & Energy - https://youtu.be/fO9ccEtxhg4 27/08/2022 - Open Office 4 Calculator: How to Create Vertical and Horizontal Pivot Tables Instantly * Save Time - https://youtu.be/TANbYgdHFDU 29/08/2022 - Open Office 4 Calculator: 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 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)