OpenOffice Calc

Book Public Course Now!Get closed/on-site Course Quote!Get distance Course Quote!
ID:
613
Duration: 
16 hours
Tags: OpenOffice

Overview

This course has been create for people with little or no knowledge of OpenOffice Calc. The courses introduces its participants to robust features of Calc.

Requirements

Basic computer skills (Windows, Linux or MacOS)

Public: 
760 GBP per delegate


Closed, on-site or individual: get quote >>
Too expensive? Tell us your price!
All prices exclude VAT!

Following Courses

No following Courses Found.

Training Course Outline

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

Training Course Dates



No public course dates have been created for this course. Please contact us and we will arrange one for you.