Home > tutorials > Calc Spreadsheet tutorials (HTML format)

Introduction to OpenOffice.org Calc (version 1.1x)

  Tutorial Objectives
Entering data
Selecting items
Adding or deleting rows and columns
Saving your work
Creating a new color
Changing the cell background color
Formatting text
Cell alignment
Rotating text
Optimizing row or column size
Freezing column or row headings
Hiding/showing rows and columns

Intermediate OpenOffice.org Calc (version 1.1x)

  Using worksheets
Using the find features
Using the replace function
Sorting spreadsheet data
Filtering data - autofilter
Filtering data - standard filters
Filtering data - removing filters
Creating charts
Editing charts
Changing the chart data range
Using ranges
Creating calculations
Relative vs. absolute addresses

Advanced analysis using OpenOffice.org Calc (version 2.x)

  Opening/importing files
Creating subtotals
Using outline functionality
Multiple Operations
Using the data pilot
Editing a data pilot table
Filtering a data pilot table
Refreshing a data pilot table
Editing a data pilot table 2
Scenarios
Creating scenarios
Modifying and deleting scenarios
Conclusion