OpenOffice Calc 4 Tutorials

OpenOffice Calc 4 Tutorials

OpenOffice Calc 4 Spreadsheet Tutorials

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.

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

This tutorial uses the AutoFill to make a times table sheet.

Simple calculations and the Fibonacci sequence are shown within this tutorial.

The Sum (AutoSum) is shown. The AutoFill is used with filling the function throughout the worksheet.

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.

Several rounding and truncating functions are shown. The functions include: Round, Round Up, Round Down, Truncate, Integer, Even and Odd.

This tutorial makes a complete worksheet with formatting and calculations.

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

The workbook from Tutorial 9 needs to be modified. This tutorial shows how to change formatting of multiple worksheets at one time.

A line chart is made using the Chart Wizard.

Adding data to a chart is as easy as selecting cells.

The chart, from Tutorial 12, has its forming changed. Multiple formatting dialog boxes and settings are shown.

A pie chart is made using the Chart Wizard.

The chart, made in Tutorial 14, is formated. Several formatting dialog boxes and setting are shown.

Please Show Your Appreciation For Our Hard Work

Tutorial 1 - Getting Started User Interface

Tutorial 3 - Times Table - AutoFill

Tutorial 4 - Formulas And Calculation

Tutorial 5 - Introduction To Functions

Tutorial 6 - Average, Median, Mode Functions

Tutorial 7 - Rounding And Truncating Functions

Tutorial 8 - Worksheet Example

Tutorial 9 - Multiple Worksheets

Tutorial 10 - Multiple Worksheet Formatting & Editing

Tutorial 11 - Line Chart Wizard

Tutorial 12 - Adding Data To A Line Chart

Tutorial 13 - Formatting A Line Chart

Tutorial 14 - Inserting A Pie Chart