Training
Topics

Training Overview: Open Office Calc Intermediate

Duration: 1 Day

This course is for people who already use Calc and wish to explore the application further.

Course Content

Review

• Basic formulae: +, -, *, /
• Sum
• Autofill
• Charts
• Exporting into Writer

Functions

• Min
• Max
• Average
• Basic If

Other Formulae

• % calculations
• Absolute cell referencing

Working with Worksheets

• Renaming, inserting, deleting, moving and copying worksheets
• Grouping worksheets
• Creating links between worksheets and performing calculations

DataPilot Tables

• Creating a table
• manipulating the table

Data Lists

• Sorting
• Filtering
• Sub-totals

Other

• Freeze panes
• Word wrap
• Diagonal text
• Using autosum for sub totals and grand totals
• Comments

Format

This course is instructor led in a classroom environment. We recommend a maximum of 8 delegates per course to ensure that all delegates gain the maximum benefit from the course.

Duration

This is a one day course. Standard hours are 9:30 to 16:30, with a one hour lunch break, and short breaks mid morning and mid afternoon. It may be possible to change this arrangement by request.