OpenOffice.org Calc

Level 4

A spreadsheet programme which allows you to store lists of text and numerical information, and make calculations and projections

1 Day Intensive

Customisable

Private Course

Training Rooms

Onsite

Post-Course Support

Consultancy Available

Printable Version

Suggested Uses

·          Financial management

·          Store, sort, filter and manipulate information on spreadsheets

·          Create financial templates such as invoices or expenses sheets

·          Display your data on a chart

·          Summarise large volumes of information in pivot tables

·          Create sophisticated formulas to calculate information

·          Link to external databases

Course Outline

Left, Mid & Find

Date-Based Functions

More Functions

Conditional Formatting

Print Options

Customise Toolbars & Menus

Templates

Custom Views

Validation

Macros

VLookup & HLookup

Scenarios

Consolidate Data

Name a Cell or Range

Array Formulas

How to Use what You’ve Learnt

After the Course

You will be able to record macros, create templates to be used for future calculations, summarise information with DataPilot tables. You will also be able to combine powerful mathematical functions to automate tasks and use array formulas.

If you would like to have a course customised for your organisation, please contact us.

Back to Software Training Course List