Difference between revisions of "Documentation/Tutorials"
From Apache OpenOffice Wiki
Line 2: | Line 2: | ||
__NOTOC__ | __NOTOC__ | ||
+ | {|width=90% cellpadding=5 border=0 align=center cellspacing=0 | ||
+ | |||
+ | |-style="font-size:120%; font-weight:bold; background-color: #CDDBF6;" | ||
+ | |width=95% style="text-align:center;"|Tiago's Tutorials | ||
+ | |style="background-color: #FFF"| | ||
+ | |||
+ | |-valign=top | ||
+ | |style="border: 1px solid #CDDBF6;"| | ||
+ | |||
+ | You can find the link to my free course here: https://youtube.com/playlist?list=PLFM0 ... 683hJ6mauj | ||
+ | |||
+ | The contents is 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 | ||
+ | |||
+ | 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)<br /> | ||
+ | ::SPECIAL SUMIF: =SUMIF($C$8:$C$12; "Bob"; $D$8:$D$12)<br /> | ||
+ | ::SUPER SPECIAL SUMIF: =SUMIF($C$8:$C$12; $A1; $D$8:$D$12)<br /> | ||
+ | ::SUPER SPECIAL SUMIF, DIFFERENT SHEETS: =SUMIF(Sheet.$A$1:$A$5; $C1; Sheet.$B$1:$B$5)<br /> | ||
+ | ::MATCH FUNCTION: =MATCH(B2;$A$1:$A$2739;0)<br /> | ||
+ | ::ISNUMBER MATCH, TRUE OR FALSE:=ISNUMBER(MATCH(E22;$C$8:$C$12;0))<br /> | ||
+ | ::SELECTION LIST: Right Click > Selection List<br /> | ||
+ | |||
+ | ::::TAB: Move between boxes.<br /> | ||
+ | ::::HIT ENTER: To select pre-determined outputs.<br /> | ||
+ | ::::FIND AND REPLACE: Find and replace letters.<br /> | ||
+ | ::::FILTER: Data > Filter<br /> | ||
+ | ::::SORT (Sort Lists): Data > SORT<br /> | ||
+ | ---- | ||
+ | <hr> | ||
{|width=90% cellpadding=5 border=0 align=center cellspacing=0 | {|width=90% cellpadding=5 border=0 align=center cellspacing=0 | ||
Revision as of 12:54, 5 September 2022
Tiago's Tutorials | |
You can find the link to my free course here: https://youtube.com/playlist?list=PLFM0 ... 683hJ6mauj The contents is as follows:
Here is some code you might need to create some of the tables seen in the videos:
|