Free Open Office Tutorials

Here are some free Open Office tutorials that you can watch, if you are interested in organising your personal data and possibly even finances.

If you don't already have Open Office, you can download it here: https://www.openoffice.org

1. How to get numbers going down a column in multiples (Open Office 4)

2. How to sum up columns of numbers (with a currency) using Open Office 4

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

4. How to save and password protect your spreadsheet file (Open Office 4)

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

6. How to sum up values associated with multiple names - all at once [SUMIF] (Open Office 4)

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

8. How to compare two lists on a spreadsheet [ISNUMBER, MATCH, TRUE OR FALSE] :: Open Office 4

9. How to Create a Line Chart using Open Office 4 [Applied Statistics]

10. How to Create a Pie Chart using Open Office 4 [Applied Statistics]

11. How to Sum up Cells from Different Sheets, Open Office [Spreadsheet Tricks]

12. How to Make Grid Lines Invisible on Open Office [Free Spreadsheet Tutorial]

13. How to make Days and Dates go down a Column in Corresponding Order [Open Office Spreadsheets]

14. How to Calculate Percentage Changes using Open Office and Format in Colour (Conditional Formatting)

15. How to Quickly Create a Table with the Powers of Ten In Digits (Open Office Spreadsheets)

16. How to automatically mimic data from the column on one sheet to another sheet (Open Office)

17. Find amount of days that have passed between two dates - Open Office Calculator

18. Conditional formatting: How to highlight specific text in a list (Open Office Calculator)

19. How to graph in 2 dimensions using Open Office Calculator [Example: y=x^2]

20. How to do basic probabilities using Open Office Calculator [Example: Dice Roll]

Popular posts from this blog

Understanding Heuristics: A Practical Guide to Smarter Problem Solving

Image
Understanding Heuristics: A Practical Guide to Smarter Problem Solving Image by:  https://pixabay.com/illustrations/data-robot-brain-humanoid-mind-7473235/ Introduction In our daily lives, we constantly make decisions, big and small. But how do we tackle complex problems without drowning in endless possibilities? Enter heuristics – a powerful set of mental shortcuts or "rules of thumb" designed to simplify decision-making. Heuristics are especially useful when time is limited, full information is unavailable, or a quick solution is needed. In this post, we'll delve into what heuristics are, how they work, and why they’re indispensable for efficient problem-solving. What Are Heuristics? Heuristics are simplified approaches or techniques that help us make quick, practical decisions. They don’t guarantee the optimal solution but offer a reasonable shortcut to finding workable answers. While heuristics are sometimes viewed as a compromise between accuracy and speed, ...
Read more

The Pythagram Defined

Image
The Pythagram Defined Contributors over a 2.5 Year Period: Tiago Hands ( Final Construction ), Carlos Luna-Mota ( Egyptian Triangles ), Andrzej Kukla ( The Rhombus with Area of 3 ) 06 October 2025 Abstract The Pythagram is a planar geometric structure derived from the 3 : 4 : 5 right triangle and the orthographic projection of a cube. Its construction through defined Cartesian coordinates reveals six interrelated Pythagorean sub-figures that encode proportional symmetry across multiple dimensions. This document formalises the coordinates, connections, and geometric properties of the Pythagram as a reproducible mathematical entity. Coordinate Data Group 1 — Central Core A(16, 18), B(14, 18), C(12, 16), D(12, 14), E(14, 12), F(16, 12), G(18, 14), H(18, 16), I(15, 15), W(15, 17.5), X(12.5, 15), Y(15, 12.5), Z(17.5, 15) Group 2 — Inner Square L(15, 20), M(10, 20), N(10, 15), O(10, 10), P(15, 10), Q(20, 10), R(20...
Read more

The Unicursal Pythagram

Image
🜛 The Unicursal Pythagram 08 October 2025 The unicursal pythagram is a geometric figure drawn on a 6×6 grid . It is made from sixteen points connected by thirty-two straight lines , and the whole pattern can be drawn without lifting the pen . That is what makes it unicursal — it is one continuous path that begins and ends at the same point. The figure is related to the 3:4:5 right triangle , just like the standard pythagram. But while the standard version is about static shapes, the unicursal version adds movement. It shows how all the parts of the pattern connect together in a single, flowing line. Points used (A–P) A(2,2), B(3,4), C(4,2), D(2,3), E(4,4), F(3,2), G(2,4), H(4,3), I(0,3), J(1,5), K(5,5), L(6,3), M(3,0), N(1,1), O(3,6), P(5,1) Drawing order (32 lines) A→B, B→C, C→D, D→E, E→F, F→G, G→H, H→A, A→I, I→J, J→B, B→K, K→L, L→C, C→M, M→N, N→D, D→J, J→O, O→E, E→L, L→P, P→F, F→N, N→I, I→G, G→O, O→K, K→H, H→P, P→M, M→A In simple terms The unicursal pythagram shows...
Read more