Post by Tiago on Sept 15, 2020 19:54:58 GMT
11 Essential Open Office Tutorials (AD FREE) - For Beginners & Intermediates, Plus a FREE Open Office Cheat Sheet
Provided by Tiago Hands: www.instagram.com/tiago_hands/
If these videos turn out to be very useful to you, I would appreciate any support that you can give. Also, do not forget to follow my channel for regular videos related to all things mathematics. :-)
1st Video: How to get numbers going down a column in multiples (Open Office 4)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-get-numbers-going-down-a-column:b?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
2nd Video: How to sum up columns of numbers (with a currency) using Open Office 4
-----> open.lbry.com/@mathsvideosforweb:9/how-to-sum-up-columns-of-numbers-with-a:2?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
3rd Video: How to get the percentages of values in a column, relative to one specific value (Open Office 4)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-get-the-percentages-of-values-in:8?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
4th Video: How to save and password protect your spreadsheet file (Open Office 4)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-save-and-password-protect-your:a?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
5th Video: How to increase the size of many cells with overlapping text - all at once (Open Office 4)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-increase-the-size-of-many-cells:5?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
6th Video: How to sum up values associated with multiple names - all at once (SUMIF) (Open Office 4)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-sum-up-values-associated-with:d?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
7th Video: How to sum up all the values associated with a specific name in a list (Open Office 4)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-sum-up-all-the-values-associated:f?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
8th Video: How to compare two lists on a spreadsheet (ISNUMBER, MATCH, TRUE OR FALSE) :: Open Office 4
-----> open.lbry.com/@mathsvideosforweb:9/how-to-compare-two-lists-on-a:f?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
9th Video: How to Create a Line Chart using Open Office 4 (Applied Statistics)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-create-a-line-chart-using-open:b?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
10th Video: How to Create a Pie Chart using Open Office 4 (Applied Statistics)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-create-a-pie-chart-using-open:5?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
11th Video: How to Sum up Cells from Different Sheets, Open Office (Spreadsheet Tricks)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-sum-up-cells-from-different:c?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
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
Provided by Tiago Hands: www.instagram.com/tiago_hands/
If these videos turn out to be very useful to you, I would appreciate any support that you can give. Also, do not forget to follow my channel for regular videos related to all things mathematics. :-)
1st Video: How to get numbers going down a column in multiples (Open Office 4)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-get-numbers-going-down-a-column:b?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
2nd Video: How to sum up columns of numbers (with a currency) using Open Office 4
-----> open.lbry.com/@mathsvideosforweb:9/how-to-sum-up-columns-of-numbers-with-a:2?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
3rd Video: How to get the percentages of values in a column, relative to one specific value (Open Office 4)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-get-the-percentages-of-values-in:8?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
4th Video: How to save and password protect your spreadsheet file (Open Office 4)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-save-and-password-protect-your:a?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
5th Video: How to increase the size of many cells with overlapping text - all at once (Open Office 4)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-increase-the-size-of-many-cells:5?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
6th Video: How to sum up values associated with multiple names - all at once (SUMIF) (Open Office 4)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-sum-up-values-associated-with:d?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
7th Video: How to sum up all the values associated with a specific name in a list (Open Office 4)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-sum-up-all-the-values-associated:f?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
8th Video: How to compare two lists on a spreadsheet (ISNUMBER, MATCH, TRUE OR FALSE) :: Open Office 4
-----> open.lbry.com/@mathsvideosforweb:9/how-to-compare-two-lists-on-a:f?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
9th Video: How to Create a Line Chart using Open Office 4 (Applied Statistics)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-create-a-line-chart-using-open:b?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
10th Video: How to Create a Pie Chart using Open Office 4 (Applied Statistics)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-create-a-pie-chart-using-open:5?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
11th Video: How to Sum up Cells from Different Sheets, Open Office (Spreadsheet Tricks)
-----> open.lbry.com/@mathsvideosforweb:9/how-to-sum-up-cells-from-different:c?r=5dJD4JNpqFiruXhKv7DoBEN5D82EfuCb
FREE OPEN OFFICE CHEAT SHEET, USED BY TIAGO:
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