Training4Linux

Overview: The following list of subjects relate to the office skillset. These subjects are useful for people involved in secretarial work, document management, invoicing/billing systems and accounting.

OFF101 Migrating to OpenOffice.org
OFF105 Working with PDF

OFF102 Core OpenOffice.org Writer
OFF103 Core OpenOffice.org Calc
OFF104 Core OpenOffice.org Impress and Draw
OFF105 Core OpenOffice.org Base

OFF201 Mail Merging in OpenOffice.org
OFF202 Advanced OpenOffice.org Writer
OFF203 Advanced OpenOffice.orf Calc
OFF204 Advanced OpenOffice.org Impress and Draw

Creating a Presentation
Presentation Wizard
Presentation Templates
Screen
Impress Screen Layout
Standard and Formatting Toolbars
Files
Saving, Opening and Closing
Presentations
File Properties
Slides
Insert a Slide
Slide Layouts
Organise and Rename Slides
Slide (Sorter) View
Page Background
Text
Bulleted Lists
Outline View
Text in Objects
Using the Text Function
Selecting and Editing Text
Formatting Text
Master View
Notes and Handouts

Introduction
The Spreadsheet Concept
Help Agent and Tips
Calc Screen Layout
Standard and Formatting Toolbars
Cell Ranges
Moving the Cursor
Selecting a Range of Cells
Naming a Range of Cells
Entering Data
Constants - Text and Values
Clearing Cells
Basic Formulae
Sum icon
Files
Saving, Opening and Closing Files
File Properties
Starting a New Spreadsheet
Editing
Copying/Filling and Moving Data
Automatic Fill Handle
System Clipboard

Costs: $500 + GST
Venue: Sydney, NSW

Course Overview
Database Terminology

• Data Storage
• Database Objects
• Relational and Flat-File Databases
• Base Databases

The Base Environment

• Database Window
• Help System
• Menus and Toolbars

Tables

• Creating a Table
• Modifying a Table
• Copying a Table
• Field Names
• Data Types
• Field Properties

Entering And Editing Data

We have a number of new courses for the Base module in OpenOffice.org. Base is best described as the MS-Access of the OpenOffice.org world. The new courses cover a number of different areas starting with an overall start with Base to create your own database applications. There are a couple of more advanced modules which will be useful for those once they have got into Base and these modules are how to do more advanced reporting, and more advanced form design. Each of these new modules are based on a one day duration and offers not only theory, but a lot of practical, hands-on lab excercises.

Training4Linux uses a range of courseware for running their courses. This courseware comes from a variety of sources, including our own in-house developed courseware. All our courseware is available for purchase for training centres and business to run their own course if they wish. Options are available to either purchase the courseware as a product, or license the use of the courseware for internal use. Below is the list of all the courseware that we have available and gives and outline of each of the courses.