Open office
You are here: Main Page >> Open office
Welcome to online web tutorials for Open Office
OpenOffice.org is a very poular open Office Software Suite which consists of a word processor, a spreadsheet, a presentation package, a drawing package, a databases package and maths equation editor. It is also known just as Open Office or Oop. It is a versatile package and it can be used for undertaking automation tasks of any typical office environment, where lots of documents are created, records kept, reports/publications generated, presentations made to reach out to clients. This package is particularly user friendly for creating technical reports which may involve mathematics equations graphics, flow charts and tables. It is Compatible with almost all popular operating systems such as Windows, Linux and Mac. It is presently distributed by Oracle who owns Sun Microsystem the initiator of open office suite through world wide community effort. It can be obtained freely from download sites, peer to peer networks, CD's and various linux distributions. To create these tutorials, we shall be using OpenOffice.org 3.2.1 version [[1]].These tutorials can be used by any one including office clerks, office secretaries, teachers, students, housewives, Business men, Lawyers and publishers, or any one interested in acquiring the skill to word process different kinds of documents.It is available in many languages and uses International Open Standard Formats. It is easy to learn and use with great help features. It is known for its consistency and has been in use for the last twenty years.
Spoken Tutorials on Open office are contributed by Prof. P.K. Ahluwalia, Ms. Kanika Dogra, Mr. Shubhendu Bhardwaj, Himachal Pradesh University, Shimla.
Contents
- 1 Basic Level
- 1.1 Open Office Suite
- 1.2 Word Processor: Writer
- 1.2.1 OpenOffice word processor Writer-I: Parts of Writer Window
- 1.2.2 Open office word processor Writer-II: Creating a Document with Writer
- 1.2.3 Open office word processor Writer-III: Formatting a document
- 1.2.4 OpenOffice word processor Writer-IV: Mouse operations, Key Board operations, Combination Keys
- 1.2.5 OpenOffice word processor Writer-V: Tool Bars
- 1.2.6 OpenOffice word processor Writer -VI: Editing a text document
- 1.2.7 OpenOffice word processor Writer-VII: Creating Tables
- 1.2.8 OpenOffice word processor Writer-VIII: Creating Drawings with Drawing Tools
- 1.2.9 OpenOffice word processor Writer-IX: Inserting objects (images, files, spreadsheets)
- 1.2.10 OpenOffice word processor Writer -X: Document Wizards
- 1.2.11 OpenOffice word processor Writer-XI: Printing Documents
- 1.3 Spreadsheets: Calc
- 1.3.1 Spreadsheets: An Introduction
- 1.3.2 OpenOffice Spreadsheet Calc: Parts of Calc Window
- 1.3.3 OpenOffice Spreadsheet Calc: Creating and working with a Spreadsheet
- 1.3.4 OpenOffice Spreadsheet Calc: Keyboard Shortcuts
- 1.3.5 OpenOffice Spreadsheet Calc: Entering Editing and Formatting Data
- 1.3.6 OpenOffice Spreadsheet Calc: Creating charts and graphs
- 1.3.7 OpenOffice Spreadsheet Calc: Using images and drawings in Spreadsheets
- 1.3.8 OpenOffice Spreadsheet Calc: Printing Exporting and e-mailing
- 1.4 Maths Equation Editor: Math
- 1.5 Presentations: Impress
- 1.6 Drawings: Draw
- 1.7 Databases: Base
- 2 Intermediate Level
- 2.1 Word Processor: Writer
- 2.2 Spreadsheets: Calc
- 2.2.1 OpenOffice Spreadsheet Calc: Protecting Spreadsheets
- 2.2.2 OpenOffice Spreadsheet Calc: Referencing in a spreadsheet
- 2.2.3 OpenOffice Spreadsheet Calc: Using Formulas and built functions I
- 2.2.4 OpenOffice Spreadsheet Calc: Using Formulas and built in functions II
- 2.2.5 OpenOffice Spreadsheet Calc: Using pivot tables (Datapilot)
- 2.2.6 OpenOffice Spreadsheet Calc: Analysing Data
- 2.2.7 OpenOffice Spreadsheet Calc: Multiple Sheets
- 2.3 Maths Equation Editor: Math
- 2.4 Presentations: Impress
- 2.5 Drawings: Draw
- 2.6 Databases: Base
- 3 Advanced Level
- 3.1 Word Processor: Writer
- 3.1.1 OpenOffice word processor Writer Tools-II: Mail Merge part-I
- 3.1.2 OpenOffice word processor Writer Tools-III: Mail Merge part-II
- 3.1.3 OpenOffice word processor Writer Tools-IV: Tracking Editing sessions
- 3.1.4 OpenOffice Word processor Writer Tools-V: Footnotes and Endnotes
- 3.1.5 OpenOffice Word Processor Writer: Exporting Documents
- 3.1.6 OpenOffice Word Processor: Creating bibliographies, reference tables and indexes
- 3.1.7 OpenOffice Word Processor: Styles Formatting
- 3.2 Spreadsheets: Calc
- 3.3 Maths Equation Editor: Math
- 3.4 Presentations: Impress
- 3.5 Drawings: Draw
- 3.6 Databases: Base
- 3.1 Word Processor: Writer
Basic Level
Open Office Suite
This Part of the tutorials will help you get a familiarity with Open Office Suite and its basic components, downloading and installation of OpenOffice.org latest version and the filetypes with which you are going to deal with while working in open office environment.
Open Office Suite: Introduction
- What is an Office Suite?
- Free and Open Source Softwares
- Various Office Suites Available in the market
- Why Open Office?
- Elements of a Typical Office Suite
- About OpenOffice.org Suite: A Brief History
- Elements of OpenOffice
- About Writer: Word Processor
- About Calc: Spreadsheet
- About Impress: Presentation
- About Draw: Drawing and Graphics
- About Base: Database
- About Math: Working with Formulae
- How to get OpenOffice
