26 Free Open Office 4 Calculator Tutorials - Youtube

Home made tutorials, by users, for users
Forum rules
No question in this section please
For any question related to a topic, create a new thread in the relevant section.
Post Reply
spreadsheet_maestro
Posts: 1
Joined: Mon Sep 05, 2022 11:06 am

26 Free Open Office 4 Calculator Tutorials - Youtube

Post by spreadsheet_maestro »

Dear all,

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:
  • 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
  • 06/10/2020 - How to Calculate Percentage Changes using Open Office and Format in Colour (Conditional Formatting) - https://youtu.be/Gsln3Cp21h0
  • 27/08/2022 - Open Office 4 Calculator: How to Create Vertical and Horizontal Pivot Tables Instantly * Save Time - https://youtu.be/TANbYgdHFDU
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

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!

:-)
Free Open Office 4 Calculator Tutorials on Youtube: https://youtube.com/playlist?list=PLFM0 ... 683hJ6mauj
User avatar
DiGro
Posts: 173
Joined: Mon Oct 08, 2007 1:31 am
Location: Hoorn NH, The Netherlands

Re: 26 Free Open Office 4 Calculator Tutorials - Youtube

Post by DiGro »

Thank you very much for that :bravo: :bravo: :bravo:
____________
DiGro

AOO 4.1.15 (Dutch) on Windows 11. Scanned with Ziggo Safe Online (F-Secure)
Post Reply