By Tiago Hands: https://www.instagram.com/tiago_hands
Hello read.cash users, because of the positive responses I received for my 13 Essential Open Office Tutorials for LBRY users, I've decided to create a similar post for Youtube users.
If you're not using LBRY and Youtube is your favourite video platform, then this post is for you. Whether you're a bookkeeper, accountant, engineer, mathematician, statistician, investor, physicist or someone that needs to deal with vast quantities of data, you are going to like this free package.
These 13 free Open Office Tutorials are perfect for those that have never used spreadsheets before but have the technical skills to benefit from the use of spreadsheets. Likewise, even if you do have experience with spreadsheets, you may find many videos on this list that will be of benefit to you. Perhaps there is something here that you haven't learnt yet.
Anyway, without further conversation, here are your free 13 Open Office Tutorials, plus an Open Office Cheat Sheet (check bottom of page). It took me a while to make. Enjoy!!
1st Video: How to get numbers going down a column in multiples (Open Office 4)
2nd Video: How to sum up columns of numbers (with a currency) using Open Office 4
3rd Video: How to get the percentages of values in a column, relative to one specific value (Open Office 4)
4th Video: How to save and password protect your spreadsheet file (Open Office 4)
5th Video: How to increase the size of many cells with overlapping text - all at once (Open Office 4)
6th Video: How to sum up values associated with multiple names - all at once (SUMIF) (Open Office 4)
7th Video: How to sum up all the values associated with a specific name in a list (Open Office 4)
8th Video: How to compare two lists on a spreadsheet (ISNUMBER, MATCH, TRUE OR FALSE) :: Open Office 4
9th Video: How to Create a Line Chart using Open Office 4 (Applied Statistics)
10th Video: How to Create a Pie Chart using Open Office 4 (Applied Statistics)
11th Video: How to Sum up Cells from Different Sheets, Open Office (Spreadsheet Tricks)
12th Video: How to Make Grid Lines Invisible on Open Office [Free Spreadsheet Tutorial]
13th Video: How to make Days and Dates go down a Column in Corresponding Order [Open Office Spreadsheets]
FREE OPEN OFFICE CHEAT SHEET (You may have to adjust some parameters):
SUMIF FUNCTION:
=SUMIF(A7:A41; "Broadband"; E7:E41)
SPECIAL SUMIF:
=SUMIF($C$8:$C$12; "Bob"; $D$8:$D$12)
SUPER SPECIAL SUMIF, DRAG DOWN:
=SUMIF($C$8:$C$12; A1; $D$8:$D$12)
SUM UP FROM DIFFERENT SHEETS:
=SUM(Sheet1.F11:Sheet2.F12:Sheet3.F13)
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
*If these videos turn out to be very useful to you, do not forget to tip and subscribe to my Youtube channel.
*You can access this full playlist on Youtube by visiting this link: https://www.youtube.com/playlist?list=PLFM03zQeSz2Nt0Tg8HtCjdY683hJ6mauj
I wish you the best of luck with your learning and endeavours!
Very helpful, Thanks!