OpenOffice Calc 4 Spreadsheet Tutorials


OpenOffice Calc is a spreadsheet tutorial similar to Microsoft Excel. OpenOffice is a free download and works on Windows, Mac and Linux. OpenOffice is a free download at openoffice.apache.org

Tutorial 1 - Getting Started User Interface
OpenOffice Calc is similar to Microsoft Excel. OpenOffice is a free download and works on Windows, Mac and Linux. This tutorial shows the user interface of Calc 4.

Tutorial 2 - AutoFill
The AutoFill is a quick way of auto-completing math trends, calculations, functions, dates, days, and other trends.

Tutorial 3 - Times Table - AutoFill
This tutorial uses the AutoFill to make a times table sheet.

Tutorial 4 - Formulas and Calculation
Simple calculations and the Fibonacci sequence are shown within this tutorial.

Tutorial 5 - Introduction to Functions
The Sum (AutoSum) is shown. The AutoFill is used with filling the function throughout the worksheet.

Tutorial 6 - Average, Median & Mode Functions
The functions shown, in this tutorial, are the Average (Mean), Median, Mode, Large, Small, Min, and Max. The AutoFill is used with filling the functions throughout the worksheet.

Tutorial 7 - Rounding and Truncating Functions
Several rounding and truncating functions are shown. The functions include: Round, Round Up, Round Down, Truncate, Integer, Even and Odd.

Tutorial 8 - Worksheet Example
This tutorial makes a complete worksheet with formatting and calculations.

Tutorial 9 - Multiple Worksheets
This tutorial takes the worksheet, from Tutorial 8, adds worksheets, copies the formatting, and calculates totals from the different worksheets into one worksheet.

Tutorial 10 - Multiple Worksheet Formatting & Editing
The workbook from Tutorial 9 needs to be modified. This tutorial shows how to change formatting of multiple worksheets at one time.

Tutorial 11 - Line Chart Wizard
A line chart is made using the Chart Wizard.

Tutorial 12 - Adding Data to a Line Chart
Adding data to a chart is as easy as selecting cells.

Tutorial 13 - Formatting a Line Chart
The chart, from Tutorial 12, has its forming changed. Multiple formatting dialog boxes and settings are shown.

Tutorial 14 - Inserting a Pie Chart
A pie chart is made using the Chart Wizard.

Tutorial 15 - Formatting a Pie Chart
The chart, made in Tutorial 14, is formatted. Several formatting dialog boxes and setting are shown.