OpenOffice Calc Training Course

Calc Overview

Similarities and differences between OpenOffice Calc and Microsoft Excel

Calc navigation and useful shortcuts

Working with workbooks

Freezing and splitting panes

Working with Worksheets

Inserting and removing data from a cell
Comments

Copying Data, Formats and Formulas

Paste special

Keyboard shortcuts

AutoFill

Filling cells with data series

Creating sort list (e.g. Jan,Feb,March, etc.)

Formulas, Address and Names

Formulas

Basic logic expressions

Lookup functions

Absolute and relative addresses

Cross-workbook and cross-worksheet references

Naming cells and ranges

Formatting

Formatting worksheets
Using Styles
Formatting Cells

Format Paintbrush

Functions

Basic functions (sum, average, round, count, etc.)

Date and time functions

Conditional functions
Function Wizard

Charts

Chart types
Embedding charts
Chart elements
Multi-series charts

Formatting legend, axis and other charts elements

Document Protection

Workbook protection

Worksheet protection

Hiding cells

Protecting cells

Printing