If you find these tutorials useful, Please consider making a donation.

TheFrugalComputerGuy.png
TheFrugalComputerLogo.png

Libre Office Calc
Overview Page




LibreOffice Calc is a free spreadsheet program that will have the computer create the equivalent of a paper accounting worksheet on the screen of your computer in a grid with rows (numbered) and columns (Alphabetic) that can quickly and accurately calculate and summarize totals for you.




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.


OfcSpreadsheet.png

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.


OfcSpreadsheet1.png

In this video tutorial series, you will learn how to do all kinds of formatting like using different fonts and rotating text.


ods03-formatting.png

At times you may want special and formatting for Phone Numbers:


ods10-PhoneNumberFormatting.png

Adding a Dropdown Box in your spreadsheet can help minimize errors by giving the user a choice of values to enter:


ods14-DropdownBox.png

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:


ods10-CalcForms.png

You will see how to validate the input and create a custom error message:


ods15-ErrorMessage.png

Or just show a message when the arrow is hovering over a cell:


ods15-InputHelp.png

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:


ods23-ConditionalFormatting.png

You will learn how to do V-Lookup, a very useful tool when creating spreadsheets:


ods25-VLookup.png







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:


ods29-ProtectSomeCells.png

You will also learn how to easily create a "Summary page" that references and summarizes data of similar information from different worksheets.


ods31-ColorTabs.png

When working with multiple tabs, you can change the tab color to help you find a specific sheet faster.


ods32-WorkingWithMultipleSheets.png

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.


ods-33-Hyperlinks.png







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.


ods34-PieChart.png

Pivot Tables, are called Pilot Data are also explained in this video tutorial series:


ods38-DataPilot.png

A full set of video tutorials showing how to use Libre Office Calc can be found at:

TheFrugalComputerGuy/vtOfcSpreadsheet.php