Difference between revisions of "Documentation/Tutorials"
From Apache OpenOffice Wiki
(Reported dead links (but didn't delete them - yet.) |
|||
(14 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | {{ | + | {{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 | ||
Line 11: | Line 94: | ||
|-valign=top | |-valign=top | ||
|style="border: 1px solid #CDDBF6;"| | |style="border: 1px solid #CDDBF6;"| | ||
− | * [http:// | + | * [http://www.openoffice.org/documentation/tutorials/dennisdaniels/OpenOfficeUpdatingTemplatesRightClickToEdit.swf OpenOffice.org Opening and Editing Templates (SWF)] |
− | * [http://documentation | + | * [http://documentation/tutorials/dennisdaniels/OpenOfficeViewingAndInsertingHeaders.swf OpenOffice.org Inserting Headers and Footers (SWF)] |
− | * [http://documentation | + | * [http://documentation/tutorials/dennisdaniels/OpenOfficeWordCount.swf OpenOffice.org Word Count (SWF)] |
− | * [http://documentation | + | * [http://documentation/tutorials/dennisdaniels/OpenOfficeImportCSVFiles.swf OpenOffice.org Base How to CSV Imports (SWF)] |
− | * [http://documentation | + | * [http://documentation/tutorials/dennisdaniels/3_times_X_exp_3.swf Graphing Non-Linear Equations with OpenOffice.org (SWF)] |
− | * [http://documentation | + | * [http://documentation/tutorials/dennisdaniels/COS_from_neg_10_to_pos_10.swf OpenOffice.org COSing from neg 10 to pos 10 (SWF)] |
| | | | ||
Line 34: | Line 117: | ||
|-valign=top | |-valign=top | ||
|style="border: 1px solid #CDDBF6"| | |style="border: 1px solid #CDDBF6"| | ||
− | + | ||
− | * [http:// | + | * [http://showmedo.com/videotutorials/series?name=AXggL6j0a All Tutorials (HTML/SWF)] |
− | * [http:// | + | * [http://showmedo.com/videotutorials/video?name=1120050&fromSeriesID=112 Adding a List Box (SWF)] |
− | * [http:// | + | * [http://showmedo.com/videotutorials/video?name=1120070&fromSeriesID=112 Changing Tab Order (SWF)] |
− | * [http:// | + | * [http://showmedo.com/videotutorials/video?name=1120000&fromSeriesID=112 Creating a Database (SWF)] |
− | * [http:// | + | * [http://showmedo.com/videotutorials/video?name=1120010&fromSeriesID=112 Creating Tables (SWF)] |
− | * [http:// | + | * [http://showmedo.com/videotutorials/video?name=1120040&fromSeriesID=112 Making Data Entry Easy (SWF)] |
− | * [http:// | + | * [http://showmedo.com/videotutorials/video?name=1120060&fromSeriesID=112 Adding a Combo Box (SWF)] |
− | * [http:// | + | * [http://showmedo.com/videotutorials/video?name=1120090&fromSeriesID=112 Changing The Sort Order (SWF)] |
− | * [http:// | + | * [http://showmedo.com/videotutorials/video?name=1120030&fromSeriesID=112 Creating a Form (SWF)] |
− | * [http:// | + | * [http://showmedo.com/videotutorials/video?name=1120100&fromSeriesID=112 Creating a Query (SWF)] |
− | * [http:// | + | * [http://showmedo.com/videotutorials/video?name=1120110&fromSeriesID=112 Changing the Join Type (SWF)] |
− | * [http:// | + | * [http://showmedo.com/videotutorials/video?name=1120020&fromSeriesID=112 Creating Relations (SWF)] |
− | * [http:// | + | * [http://showmedo.com/videotutorials/video?name=1120120&fromSeriesID=112 Creating a Report (SWF)] |
− | * [http:// | + | * [http://showmedo.com/videotutorials/video?name=1120080&fromSeriesID=112 Viewing Data (SWF)] |
+ | * [http://showmedo.com/videotutorials/video?name=1120130&fromSeriesID=112 Tab Order and Focus (SWF)] | ||
+ | * [http://showmedo.com/videotutorials/video?name=1120140&fromSeriesID=112 Form Desgin (SWF)] | ||
* [http://dai-videotutes.blogspot.com/2008/10/creating-labels-from-database.html Creating Labels From a Database (FLV)] | * [http://dai-videotutes.blogspot.com/2008/10/creating-labels-from-database.html Creating Labels From a Database (FLV)] | ||
* [http://dai-videotutes.blogspot.com/2008/10/using-filters-with-mailmerge.html Using filters with mailmerge (FLV)] | * [http://dai-videotutes.blogspot.com/2008/10/using-filters-with-mailmerge.html Using filters with mailmerge (FLV)] | ||
* [http://dai-videotutes.blogspot.com/2008/10/click-to-play.html Creating a Form Letter Using a Datasource (FLV)] | * [http://dai-videotutes.blogspot.com/2008/10/click-to-play.html Creating a Form Letter Using a Datasource (FLV)] | ||
− | * [http://dai-videotutes.blogspot. | + | * [http://dai-videotutes.blogspot.nl/2008/10/registering-database-in-openoffice_3025.html Registering a database in OpenOffice Writer (FLV)] |
| | | | ||
|style="border: 1px solid #CDDBF6"| | |style="border: 1px solid #CDDBF6"| | ||
Line 58: | Line 143: | ||
* [http://www.showmedo.com/videos/video?name=1260040&fromSeriesID=126 OpenOffice Writer: making a shopping list with tabs (external)] | * [http://www.showmedo.com/videos/video?name=1260040&fromSeriesID=126 OpenOffice Writer: making a shopping list with tabs (external)] | ||
* [http://www.showmedo.com/videos/video?name=1260030&fromSeriesID=126 OpenOffice Calc: making a nice-looking diagram (external)] | * [http://www.showmedo.com/videos/video?name=1260030&fromSeriesID=126 OpenOffice Calc: making a nice-looking diagram (external)] | ||
− | * [http://www.showmedo.com/videos/video?name=1260000&fromSeriesID=126 OpenOffice Writer: Inhaltsverzeichnis (external, German)] | + | * [http://www.showmedo.com/videos/video?name=1260000&fromSeriesID=126 OpenOffice Writer: Inhaltsverzeichnis (external, German)] |
+ | * [http://www.showmedo.com/videos/video?name=1260010&fromSeriesID=126 OpenOffice Writer: Inhaltsverzeichnis (external, Chinese)] | ||
* [http://www.showmedo.com/videos/video?name=1260020&fromSeriesID=126 OpenOffice Calc: Der SVerweis (external, German)] | * [http://www.showmedo.com/videos/video?name=1260020&fromSeriesID=126 OpenOffice Calc: Der SVerweis (external, German)] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
{{Spacer|50}} | {{Spacer|50}} | ||
[[Category: Documentation/Tutorials|Tutorials]] | [[Category: Documentation/Tutorials|Tutorials]] |
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 |