OpenOffice.org Calc

Level 2

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

·          Create budgets

·          Store, sort and filter lists such as names and addresses

·          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

Course Outline

The Mouse

Views

Keyboard Commands

Customise Toolbars

Absolute Cell References

Worksheets

Linking Worksheet and Workbooks

Name Box

Format your Workbook

Print

Sort

Filter

Subtotals

Goal Seek

Protect Your Work

Templates

Charts

Format Your Chart

The Euro

How to Use what You've Learnt

After the Course

You will be able to create formulas to model financial data, quickly enter large amounts of data, process information in lists, format your work neatly and create spreadsheets to be used for future calculations.

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

Back to Software Training Course List