Cybersource OpenOffice.org 3 Training

							   Cybersource OpenOffice.org 3 Training

Introduction
          ◦   About the Courseware
          ◦   Overview
          ◦   OpenOffice.org In Just 2 Minutes
          ◦   When to use OpenOffice.org?
          ◦   Migrating Microsoft Office to OpenOffice.org
          ◦   Integrating OpenOffice.org into our Environment
          ◦   OpenOffice.org & StarOffice – A Comparison
          ◦   XML – What is it?
          ◦   Why open data formats are important
          ◦   Open Source Impact
          ◦   What's new in OpenOffice.org version 3
          ◦   Integrating with Microsoft Office
          ◦   Differences between OpenOffice.org and Microsoft
               Office
          ◦   Interoperating with Microsoft Office
          ◦   Macros in Microsoft Office and OpenOffice.org
          ◦   Configuring VBA Properties
          ◦   Exchanging files with Microsoft Office

OpenOffice.org Common Components
          ◦   The Interface
          ◦   Toolbars
          ◦   Menus




Cybersouce Pty. Ltd. Level 1, 130­132 Stawell Street. Richmond, 3121, Australia
Phone: +61 3 9428 6922  |  Fax: +61 3 9428 6944  |  info@cybersource.com.au  |  Web: http://www.cybersource.com.au/
          ◦   Styles and Formatting Dialog
          ◦   Keyboard Shortcuts
          ◦   Navigator
          ◦   Cut, Copy, Paste and Undo
          ◦   Creating New Documents
          ◦   Embedding Documents within Other Documents
          ◦   Find & Replace
          ◦   Opening And Saving Documents
          ◦   Version Control of your Documents
          ◦   Spellchecking and Language Tools
          ◦   Printer Page Formatting
          ◦   Printing and Print Previewing
          ◦   Creating PDF Files from your Documents
          ◦   Help and the Help Agent

Writer Basics
          ◦   Opening or Creating a Document
          ◦   Setting Fonts and Styles
          ◦   Automatic Word Completion
          ◦   Inserting Symbols and Fields
          ◦   Page Breaks
          ◦   Page Layout
          ◦   Styles and Formatting dialog in Writer
          ◦   Styles in Detail
          ◦   Headers and Footers

Writer Advanced
          ◦   Frames
          ◦   Columns
          ◦   Sections
          ◦   Inserting Images
          ◦   Tables
          ◦   Drawing Graphics
          ◦   Inserting an Index or Table of Contents
          ◦   Adding Footnotes



Cybersouce Pty. Ltd. Level 1, 130­132 Stawell Street. Richmond, 3121, Australia
Phone: +61 3 9428 6922  |  Fax: +61 3 9428 6944  |  info@cybersource.com.au  |  Web: http://www.cybersource.com.au/
          ◦   Printing and Page Previewing
          ◦   Managing Databases in Writer
          ◦   Mail Merge and Envelopes

Calc Basics – Working with Spreadsheets
          ◦   Introduction
          ◦   Pre-Requisites
          ◦   Starting Calc
          ◦   Essential Formatting
          ◦   Automatically Adding Data and Dates
          ◦   Selecting Cells
          ◦   Mathematical Functions and Formulas
          ◦   The Sum Function
          ◦   Working with Multiple Worksheets
          ◦   Formatting Cells
          ◦   Copying and Pasting Data and Cells
          ◦   Addresses and References, Absolute and Relative
          ◦   Printing Spreadsheets

Calc Advanced
          ◦   Importing Text files
          ◦   Importing Database Files
          ◦   Non Scrolling Regions
          ◦   Splitting Windows
          ◦   Sorting Data
          ◦   Filtering Data
          ◦   Adding Charts to Spreadsheets
          ◦   Pivot Tables – DataPilot Tables
          ◦   Spreadsheet Detective

Impress Basics – Presentations Made Easy
          ◦   When to Use Impress
          ◦   Running the Slideshow
          ◦   Outline, Notes and Handout Modes
          ◦   Going from a Writer Outline to an Impress Presentation



Cybersouce Pty. Ltd. Level 1, 130­132 Stawell Street. Richmond, 3121, Australia
Phone: +61 3 9428 6922  |  Fax: +61 3 9428 6944  |  info@cybersource.com.au  |  Web: http://www.cybersource.com.au/
          ◦   Printing Slides

Impress Advanced
          ◦   Adding Graphics and Clipart
          ◦   Adding Draw Elements
          ◦   Adding Transitions
          ◦   Slide Effects
          ◦   Publish to the Web

Instant Artist – Just Add Draw
          ◦   Drawing Objects
          ◦   Creations in 3D
          ◦   Creating Simple Flowcharts with Draw
          ◦   Exporting our Drawing to PDF
          ◦   Publishing our Drawing to the Web
          ◦   Exporting our Drawing as an Image or Flash File
          ◦   Creating Web Pages with OpenOffice.org
          ◦   Creating a new Web Page from the Wizard
          ◦   Editing HTML Source
          ◦   Inserting Links

OpenOffice.org Base – Managing Data
          ◦   Using a Database in OpenOffice.org
          ◦   Working with Tables
          ◦   Working with Queries
          ◦   Working with Forms
          ◦   Creating Reports
          ◦   Executing SQL Commands
          ◦   Introduction to SQL

Overview of Math
          ◦   Creating a Formula




Cybersouce Pty. Ltd. Level 1, 130­132 Stawell Street. Richmond, 3121, Australia
Phone: +61 3 9428 6922  |  Fax: +61 3 9428 6944  |  info@cybersource.com.au  |  Web: http://www.cybersource.com.au/