Difference between revisions of "Documentation/Tutorials"
From Apache OpenOffice Wiki
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{DocBanner}} | {{DocBanner}} | ||
__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 his free course here: https://yewtu.be/playlist?list=PLFM03zQeSz2Nt0Tg8HtCjdY683hJ6mauj | ||
| + | |||
| + | The contents is as follows: | ||
| + | |||
| + | *13/06/2020 - How to get numbers going down a column in multiples (OpenOffice 4) | ||
| + | :: - https://youtu.be/yhJ7f85oios | ||
| + | *22/06/2020 - How to sum up columns of numbers (with a currency) using OpenOffice 4 | ||
| + | :: - https://youtu.be/OpWzMoqSJkY | ||
| + | *22/06/2020 - How to get the percentages of values in a column, relative to one specific value (OpenOffice 4) | ||
| + | :: - https://youtu.be/dMwh4DQ5wQ8 | ||
| + | *22/06/2020 - How to save and password protect your spreadsheet file (OpenOffice 4) | ||
| + | :: - https://youtu.be/VbtzTR8RgJY | ||
| + | *24/06/2020 - How to increase the size of many cells with overlapping text - all at once (OpenOffice 4) | ||
| + | :: - https://youtu.be/rIUhDqPduHI | ||
| + | *24/06/2020 - How to sum up values associated with multiple names - all at once [SUMIF] (OpenOffice 4) | ||
| + | :: - https://youtu.be/WFst-T997K4 | ||
| + | *25/06/2020 - How to sum up all the values associated with a specific name in a list (OpenOffice 4) | ||
| + | :: - https://youtu.be/M2BQSWICh8k | ||
| + | *09/09/2020 - How to Create a Line Chart using OpenOffice 4 [Applied Statistics] | ||
| + | :: - https://youtu.be/b0NKo1VUmoY | ||
| + | *09/09/2020 - How to Create a Pie Chart using OpenOffice 4 [Applied Statistics] | ||
| + | :: - https://youtu.be/CgLcZjkG1eY | ||
| + | *11/09/2020 - How to Sum up Cells from Different Sheets, OpenOffice [Spreadsheet Tricks] | ||
| + | :: - https://youtu.be/IzXObOPh0Lg | ||
| + | *15/09/2020 - How to Make Grid Lines Invisible on OpenOffice [Free Spreadsheet Tutorial] | ||
| + | :: - https://youtu.be/K8Tt6VJPhgg | ||
| + | *17/09/2020 - How to make Days and Dates go down a Column in Corresponding Order [OpenOffice 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 (OpenOffice Spreadsheets) | ||
| + | :: - https://youtu.be/OwIPln1w81M | ||
| + | *15/03/2021 - How to automatically mimic data from the column on one sheet to another sheet (OpenOffice) | ||
| + | :: - https://youtu.be/cITJVqGPMRo | ||
| + | *18/03/2021 - Find amount of days that have passed between two dates - OpenOffice Calc | ||
| + | :: - https://youtu.be/jKQvkxDu2ew | ||
| + | *20/03/2021 - Conditional formatting: How to highlight specific text in a list (OpenOffice Calc) | ||
| + | :: - https://youtu.be/nH0Deh0xxEc | ||
| + | *20/03/2021 - How to graph in 2 dimensions using OpenOffice Calc [Example: y=x^2] | ||
| + | :: - https://youtu.be/RsR-85rNDKc | ||
| + | *31/03/2021 - How to do basic probabilities using OpenOffice Calc [Example: Dice Roll] | ||
| + | :: - https://youtu.be/Q4uVIecc22E | ||
| + | *23/04/2022 - How to Transform Date Text to Date Formatted Text (OpenOffice Calc) | ||
| + | :: - https://youtu.be/DUIbwVTJrJc | ||
| + | *17/08/2022 - OpenOffice Calc 4 Tricks: How to Create New Lines within 1 Cell [CTRL+Enter] | ||
| + | :: - https://youtu.be/W9sN7xQmAwM | ||
| + | *22/08/2022 - OpenOffice Calc 4, Productivity: How to Apply and Use The Auto-Filter Feature | ||
| + | :: - https://youtu.be/wKC1THOaeHE | ||
| + | *22/08/2022 - OpenOffice 4 Calc: Bold, Italic and Underline Keyboard Tricks to Save Time & Energy | ||
| + | :: - https://youtu.be/fO9ccEtxhg4 | ||
| + | *27/08/2022 - OpenOffice 4 Calc: How to Create Vertical and Horizontal Pivot Tables Instantly * Save Time | ||
| + | :: - https://youtu.be/TANbYgdHFDU | ||
| + | *29/08/2022 - OpenOffice 4 Calc: 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 /> | ||
| + | |||
| + | Also mentioned on the user Forum [https://forum.openoffice.org/en/forum/viewtopic.php?p=528081#p528081 here] | ||
| + | ---- | ||
{|width=90% cellpadding=5 border=0 align=center cellspacing=0 | {|width=90% cellpadding=5 border=0 align=center cellspacing=0 | ||
Latest revision as of 15:06, 5 September 2022
| Tiago's Tutorials | |
|
You can find the link to his free course here: https://yewtu.be/playlist?list=PLFM03zQeSz2Nt0Tg8HtCjdY683hJ6mauj The contents is as follows:
Here is some code you might need to create some of the tables seen in the videos:
Also mentioned on the user Forum here |
