It's my first time posting here. My name is Tiago and I would like to introduce you to my free Open Office Calculator 4 tutorials playlist on Youtube. It's taken me quite a while to build it up and it consists of 26 videos and 97.78 minutes of playback time.
You can find the link to my free course here: https://youtube.com/playlist?list=PLFM0 ... 683hJ6mauj
The contents are 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
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
I hope that this is of great use to members of this forum. If you have any questions or would like to say 'hi', just leave your comment below the relevant video on Youtube. I hope to see you there!