LibreOffice Calc - A Free Accounting spreadsheet program:
Spreadsheets, can be used to line up groups and lists and sort them, but the real power of a spreadsheet comes
from the way it can recalculate a sum or formula instantly after a single value changes.
In the picture below, we can see that the value in cell D3 is the sum of cells B3 + C3. Cell D3 is selected (with the dark border)
showing the sum of 5 + 9 is 14. The actual formula for the selected cell is shown in formula bar above the actual spreadsheet - the formula bar
shows the formula for cell D3 is '=B3+C3'. If we were to change one of the values in cells B3 or C3, the value in cell D3 would be recalculated to show this result.
In this video tutorial series, you will learn how to do all kinds of formatting like using different fonts and rotating text.
At times you may want special and formatting for Phone Numbers:
Adding a Dropdown Box in your spreadsheet can help minimize errors by giving the user a choice of values to enter:
When you have a database or table of information, as we do here, a form could be used to help you view or edit data into a calc spread-sheet:
You will see how to validate the input and create a custom error message:
Or just show a message when the arrow is hovering over a cell:
To highlight or draw attention to fields that meet a certain criteria, you may want us use
Conditional formatting, you will learn how to do that as well in this tutorial series:
You will learn how to do V-Lookup, a very useful tool when creating spreadsheets:
You will learn how to Protect Cells, in the picture below we allow the user to
update the temperature in the outlined white cell and see the result in the yellow cell,
but only the outlined cell can be updated (so no-one can accidently change the formula for the yellow cell:
You will also learn how to easily create a "Summary page" that references and summarizes data of similar
information from different worksheets.
When working with multiple tabs, you can change the tab color to help you find a specific sheet faster.
To quickly open Web-pages or information in other LibreOffice documents, you can create a Hyperlink
to get you there at the press of a button.
This video will show how to create pie charts, and customize your pie chart. You will be able to
changing the color of a section of the pie chart, or change the chart to a bar chart or scatter graph.
Pivot Tables, are called Pilot Data are also explained in this video tutorial series:
A full set of video tutorials showing how to use Libre Office Calc can be found at: