Page 1 of 1

26 Free Open Office 4 Calculator Tutorials - Youtube

Posted: Mon Sep 05, 2022 11:43 am
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!

:-)

Re: 26 Free Open Office 4 Calculator Tutorials - Youtube

Posted: Mon Sep 05, 2022 3:20 pm
by DiGro
Thank you very much for that :bravo: :bravo: :bravo: