OpenOffice Books

• ISBN13: 9781440451775
• Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!

• Apress Beginning OpenOffice 3: From Novice to Professional

Downloaded over 90 million times, Open Office is a free open-source alternative to Microsoft Office and iLife that runs natively on Windows, Mac OS X and most Linux distributions. The software includes a word processor, spreadsheet application, database, presentation software, and graphics. While there are similarities to other closed-source office applications, there are always questions that arise from using new software, and this book will contain the solutions for new and current users of Open Office 3.

Microsoft’s forthcoming Office suite release, currently titled MS Office 2008, has been delayed yet again, so there’s a real opportunity to introduce Open Office to an audience that is ready to ditch their alliance to Microsoft.

OpenOffice Calc is the most powerful and widespread open source spreadsheet application in existence. It is the only real alternative to Excel. Jacek Artymiak is widely regarded as the authority on OpenOffice Calc. He takes you, step by step, from the interface and handling Calc files to working with data sources small and large. Artymiak then extends the reader's skillset to data visualization, writing complex formulas and performing statistical analysis. Beginning OpenOffice Calc allows you to gain confidence in the considered use of statistical formulas, but does not assume familiarity with another spreadsheet application.

What you’ll learn

• Work with large sets of data
• Process and format data
• Write complex formulas using array functions
• Collaborate on OpenOffice.org Calc files with the users of Calc, Excel and other spreadsheet software 

Who this book is for

This is a book for spreadsheet beginners as much as for anyone who would like start using open source applications in an office environment. Whether someone has used Excel in the past and wants to convert to Calc, or just wants to start using spreadsheets, this is the book for you.

Table of Contents

Introduction    

1. Essentials      
2. Formulas      
3. Functions      
4. Formatting      
5. Simple Mathematical Functions      
6. Utility Mathematical Functions      
7. Useful Statistical Functions      
8. Calculations with Money      
9. Formatting Functions      
10. Conversion Functions      
11. Utility Functions      
12. Time & Date Functions     
13. Conditional Functions 

• Uses the straightforward For Dummies style to show Linux and Windows users how to use the OpenOffice.org desktop productivity suite
• OpenOffice.org has a user interface and feature set similar to that of other office suites and works transparently with a variety of file formats, including those of Microsoft Office
• Explains how to download, install, and set up both the Linux and Windows versions of OpenOffice.org
• Organized by the four key desktop applications provided in the OpenOffice.org suite: Writer (word processing), Calc (spreadsheets), Impress (presentations), and Draw (graphics)
• Other topics covered include creating and formatting documents with Writer, using templates and styles, creating spreadsheets with Calc, manipulating spreadsheet data, creating a presentation with Impress, and creating and editing images with Draw

An alternative for Microsoft Office and StarOffice users has arrived in the form of OpenOffice.org. If you are part of the growing number of people who are making the switch from Microsoft Office or StarOffice to the free OpenOffice.org 1.1 suite, Sams Teach Yourself OpenOffice.org All In One is a must-have tool. Make a smooth transition from Microsoft Office to OpenOffice.org 1.1 with this task tutorial, starter kit CD-ROM and step-by-step instruction guide. Learn how to productively use the Writer, Calc, Impress and Draw applications in the OpenOffice.org 1.1 suite and how you will be able to easily work with those still using Microsoft Office and StarOffice. Don't lose valuable time trying to learn OpenOffice.org 1.1 on your own — let Sams Teach Yourself help!

OpenOffice.org Common Features; Introduction to Writer: What Will Word Processing Do for Me?; Gaining Proficiency; Introduction to Calc; Introduction to Base; Introduction to Impress

MARKET: This text is part of an academic series written on alternative technology that presents key information on OpenOffice.org and encourages hands-on learning throughout the material.