Sirwin
Sirwin
FREE Open Office Spreadsheet Course

FREE Open Office Spreadsheet Course, The Essentials + Cheat Sheet

By Mathematics | Mathematics Proofs | 28 Sep 2020


FREE Open Office Spreadsheet Course :: The Essentials + CHEAT SHEET

Below is a FREE Open Office Spreadsheet Course with all the essentials you need to know to start benefiting from spreadsheets. Whether you're a bookkeeper, accountant, engineer, mathematician, statistician, physicist or trader, these tips could benefit you enormously. It's taken me months or even years to figure out these tricks and at times I was frustrated, however, today I'm giving you these tips free of charge. The only thing that I ask in return is that you share and like if you've found the course useful. That would help me spread the word about my channel https://www.youtube.com/c/mathsvideosforweb/videos.

So here is the outline of the course. Just click on the video that is revelant to you, or start from the beginning. I've included a CHEAT SHEET at the bottom of this page too. If you need to download Open Office, go to http://www.openoffice.org/download/.

  • 1st Video: How to get numbers going down a column in multiples (Open Office 4)

  • 2nd Video: How to sum up columns of numbers (with a currency) using Open Office 4

  • 3rd Video: How to get the percentages of values in a column, relative to one specific value (Open Office 4)

  • 4th Video: How to save and password protect your spreadsheet file (Open Office 4)

  • 5th Video: How to increase the size of many cells with overlapping text - all at once (Open Office 4)

  • 6th Video: How to sum up values associated with multiple names - all at once (SUMIF) (Open Office 4)

  • 7th Video: How to sum up all the values associated with a specific name in a list (Open Office 4)

  • 8th Video: How to compare two lists on a spreadsheet (ISNUMBER, MATCH, TRUE OR FALSE) :: Open Office 4

  • 9th Video: How to Create a Line Chart using Open Office 4 (Applied Statistics)

  • 10th Video: How to Create a Pie Chart using Open Office 4 (Applied Statistics)

  • 11th Video: How to Sum up Cells from Different Sheets, Open Office (Spreadsheet Tricks)

  • 12th Video: How to Make Grid Lines Invisible on Open Office [Free Spreadsheet Tutorial]

  • 13th Video: How to make Days and Dates go down a Column in Corresponding Order [Open Office Spreadsheets]

  • To find the playlist on Youtube, go to: https://www.youtube.com/playlist?list=PLFM03zQeSz2Nt0Tg8HtCjdY683hJ6mauj

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


You can support my work at:

Tiago Hands: https://www.instagram.com/tiago_hands

Mathematics Proofs: https://www.instagram.com/mathematics.proofs

How do you rate this article?

1


Mathematics
Mathematics

This is a page related to all things mathematics and also random stuff.


Mathematics Proofs
Mathematics Proofs

A blog related to mathematics proofs, mathematics knowledge and also other useful things.

Send a $0.01 microtip in crypto to the author, and earn yourself as you read!

20% to author / 80% to me.
We pay the tips from our rewards pool.