Difference between revisions of "Documentation/Tutorials"
From Apache OpenOffice Wiki
m |
|||
Line 15: | Line 15: | ||
The contents is as follows: | The contents is as follows: | ||
− | *13/06/2020 - How to get numbers going down a column in multiples ( | + | *13/06/2020 - How to get numbers going down a column in multiples (OpenOffice 4) |
− | *22/06/2020 - How to sum up columns of numbers (with a currency) using | + | :: - https://youtu.be/yhJ7f85oios |
− | *22/06/2020 - How to get the percentages of values in a column, relative to one specific value ( | + | *22/06/2020 - How to sum up columns of numbers (with a currency) using OpenOffice 4 |
− | *22/06/2020 - How to save and password protect your spreadsheet file ( | + | :: - https://youtu.be/OpWzMoqSJkY |
− | *24/06/2020 - How to increase the size of many cells with overlapping text - all at once ( | + | *22/06/2020 - How to get the percentages of values in a column, relative to one specific value (OpenOffice 4) |
− | *24/06/2020 - How to sum up values associated with multiple names - all at once [SUMIF] ( | + | :: - https://youtu.be/dMwh4DQ5wQ8 |
− | *25/06/2020 - How to sum up all the values associated with a specific name in a list ( | + | *22/06/2020 - How to save and password protect your spreadsheet file (OpenOffice 4) |
− | + | :: - https://youtu.be/VbtzTR8RgJY | |
− | *09/09/2020 - How to Create a Line Chart using | + | *24/06/2020 - How to increase the size of many cells with overlapping text - all at once (OpenOffice 4) |
− | *09/09/2020 - How to Create a Pie Chart using | + | ** - https://youtu.be/rIUhDqPduHI |
− | *11/09/2020 - How to Sum up Cells from Different Sheets, | + | *24/06/2020 - How to sum up values associated with multiple names - all at once [SUMIF] (OpenOffice 4) |
− | *15/09/2020 - How to Make Grid Lines Invisible on | + | :: - https://youtu.be/WFst-T997K4 |
− | *17/09/2020 - How to make Days and Dates go down a Column in Corresponding Order [ | + | *25/06/2020 - How to sum up all the values associated with a specific name in a list (OpenOffice 4) |
− | *06/10/2020 - How to Calculate Percentage Changes using Open Office and Format in Colour (Conditional Formatting) - https://youtu.be/Gsln3Cp21h0 | + | :: - https://youtu.be/M2BQSWICh8k |
− | *15/03/2021 - How to Quickly Create a Table with the Powers of Ten In Digits ( | + | *09/09/2020 - How to Create a Line Chart using OpenOffice 4 [Applied Statistics] |
− | *15/03/2021 - How to automatically mimic data from the column on one sheet to another sheet ( | + | :: - https://youtu.be/b0NKo1VUmoY |
− | *18/03/2021 - Find amount of days that have passed between two dates - | + | *09/09/2020 - How to Create a Pie Chart using OpenOffice 4 [Applied Statistics] |
− | *20/03/2021 - Conditional formatting: How to highlight specific text in a list ( | + | :: - https://youtu.be/CgLcZjkG1eY |
− | *20/03/2021 - How to graph in 2 dimensions using | + | *11/09/2020 - How to Sum up Cells from Different Sheets, OpenOffice [Spreadsheet Tricks] |
− | *31/03/2021 - How to do basic probabilities using | + | :: - https://youtu.be/IzXObOPh0Lg |
− | *23/04/2022 - How to Transform Date Text to Date Formatted Text ( | + | *15/09/2020 - How to Make Grid Lines Invisible on OpenOffice [Free Spreadsheet Tutorial] |
− | *17/08/2022 - | + | :: - https://youtu.be/K8Tt6VJPhgg |
− | *22/08/2022 - | + | *17/09/2020 - How to make Days and Dates go down a Column in Corresponding Order [OpenOffice Spreadsheets] |
− | *22/08/2022 - | + | :: - https://youtu.be/GX1uMpHDFR8 |
− | *27/08/2022 - | + | *06/10/2020 - How to Calculate Percentage Changes using Open Office and Format in Colour (Conditional Formatting) |
− | *29/08/2022 - | + | :: - 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: | Here is some code you might need to create some of the tables seen in the videos: |
Revision as of 13:03, 5 September 2022
Tiago's Tutorials | |
You can find the link to his 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:
|