@mathematics.proofs 18 September 2020 more from that month

For Youtube users: 13 Essential Open Office Tutorials + Cheat Sheet

*By Tiago Hands:* *https://www.instagram.com/tiago_hands* Hello read.cash users, because of the **positive responses** I received for my **13 Essential Open Office Tutorials for LBRY users**, I've decided to create a similar post for **Youtube users**. https://tinyurl.com/y6ogwmhj If you're not using LBRY and **Youtube is your favourite video platform**, then this post is for you. Whether you're a **bookkeeper**, **accountant**, **engineer**, **mathematician**, **statistician**, **investor**, **physicist** or **someone that needs to deal with vast quantities of data**, you are going to like this ****free**** package. These **13 free** **Open Office** **Tutorials** are ****perfect**** for those that have never used spreadsheets before but have the ****technical skills to benefit**** from the use of **spreadsheets**. Likewise, **even if you do have experience** with spreadsheets, you may find many videos on this list that will be of benefit to you. Perhaps there is something here that you haven't learnt yet. https://www.openoffice.org/ Anyway, without further conversation, here are your ****free 13**** ****Open Office**** ****Tutorials****, plus an ****Open Office Cheat Sheet**** (check bottom of page). It took me a while to make. Enjoy!! https://www.openoffice.org/ **1st Video: How to get numbers going down a column in multiples (Open Office 4)** https://youtu.be/yhJ7f85oios **2nd Video: How to sum up columns of numbers (with a currency) using Open Office 4** https://youtu.be/OpWzMoqSJkY **3rd Video: How to get the percentages of values in a column, relative to one specific value (Open Office 4)** https://youtu.be/dMwh4DQ5wQ8 **4th Video: How to save and password protect your spreadsheet file (Open Office 4)** https://youtu.be/VbtzTR8RgJY **5th Video: How to increase the size of many cells with overlapping text - all at once (Open Office 4)** https://youtu.be/rIUhDqPduHI **6th Video: How to sum up values associated with multiple names - all at once (SUMIF) (Open Office 4)** https://youtu.be/WFst-T997K4 **7th Video: How to sum up all the values associated with a specific name in a list (Open Office 4)** https://youtu.be/M2BQSWICh8k **8th Video: How to compare two lists on a spreadsheet (ISNUMBER, MATCH, TRUE OR FALSE) :: Open Office 4** https://youtu.be/4kc4ZzB9EVo **9th Video: How to Create a Line Chart using Open Office 4 (Applied Statistics)** https://youtu.be/b0NKo1VUmoY **10th Video: How to Create a Pie Chart using Open Office 4 (Applied Statistics)** https://youtu.be/CgLcZjkG1eY **11th Video: How to Sum up Cells from Different Sheets, Open Office (Spreadsheet Tricks)** https://youtu.be/IzXObOPh0Lg **12th Video: How to Make Grid Lines Invisible on Open Office [Free Spreadsheet Tutorial]** https://youtu.be/K8Tt6VJPhgg **13th Video: How to make Days and Dates go down a Column in Corresponding Order [Open Office Spreadsheets]** https://youtu.be/GX1uMpHDFR8 **FREE OPEN OFFICE CHEAT SHEET (You may have to adjust some parameters):** **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 *If these videos turn out to be very useful to you, **do not forget to tip** and **subscribe to my Youtube channel**. https://www.youtube.com/mathsvideosforweb *You can access this full playlist on Youtube by visiting this link: https://www.youtube.com/playlist?list=PLFM03zQeSz2Nt0Tg8HtCjdY683hJ6mauj **I wish you the best of luck with your learning and endeavours!**