OpenOffice.org Calc

Level 3

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 DataPilot tables

·          Create sophisticated formulas to calculate information

Course Outline

Link Worksheets and Workbooks

Consolidate Data

VLookup and HLookup

Advanced Filters

DataPilot Tables

Conditional Formatting

Record Macros

Customise Toolbars and Menus

Goal Seek

Scenarios

Custom Views

The Euro

How to Use what You’ve Learnt

After the Course

You will be able to create formulas to model financial data, record macros, quickly enter large amounts of data, format your work neatly, create templates to be used for future calculations and summarise information with DataPilot tables.

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

Back to Software Training Course List