Open Office Org Calc (Spreadsheet) Basics

Description:

OpenOffice.org: Calc is a spreadsheet software that is a free alternative to Microsoft Excel. It allows you to store, organize, and analyze numerical information. This topic covers version 1.1.

Topics Include:

  • Install and Launch OpenOffice.org
  • Identify Basic Parts of the OpenOffice.org Calc Window
  • Create, Open and Save Workbooks
  • Enter, Edit and Delete Data
  • Moving, Copying and Deleting Cell Contents
  • Creating Simple Formulas
  • Creating Complex Formulas

Worksheet Layout and Management

  • Using Functions
  • Working with Multiple Worksheets
  • Inserting and Deleting Rows and Columns
  • Changing Column Width and Row Height
  • Inserting and Deleting Cells
  • Text and Cell Alignments
  • Formatting Numbers
  • Applying Font Color and Borders to Cells

Charting, Printing, File Formats, and Document Sharing

  • Creating a Chart
  • Moving, Resizing, and Deleting Charts
  • Editing Charts
  • Formatting a Chart
  • Defining Page Setup Options
  • Print Management
  • File Formats and Sharing Documents