This is a complete tutorial for using the worlds leading office productivity suite alternative to Microsoft Office: the free, open source OpenOffice.org 1.1. In 29 carefully-organized lessons, this book helps students master the key tasks associated with every OpenOffice.org module: Writer, Calc, Impress, Draw, and Math. The books in-depth, step-by-step coverage of Writer word processing includes: creating, managing, and formatting documents; styles, tables, images, tables of contents, indexes, headers/footers, spellchecking, form letters, Web publishing, and more. The book contains extensive coverage of building spreadsheets with Calc, including: values, formulas, references, formatting, database ranges, importing and manipulating external data with DataPilot, and more. Kenyon Brown walks students step-by-step through developing Impress presentations, creating and editing drawings with Draw, and building formulas with Math. The accompanying CD-ROM contains complete versions of OpenOffice.org 1.1 for Windows, Macintosh, and Linux.

• Task-focused, step-by-step coverage of all five OpenOffice.org modules—Practical, one-step-at-a-time coverage of the most important features in OpenOffice.org Writer, Calc, Impress, Draw, and Math.

  • Covers everything students need to know to become productive with OpenOffice.org as rapidly as possible.

• Exercises and review questions in every chapter—Includes exercises and review questions that can easily be tailored to the needs of specific courses and instructors.

  • Provides constant feedback and reinforcement to ensure that students understand the material they are learning.

• Extensive collection of tips and ideas—Offers practical tips on using every OpenOffice.org module more efficiently.

  • Gives students productivity tips they would normally have to discover through trial and error.

• OpenOffice.org 1.1 distributions on CD-ROM—Includes full OpenOffice.org 1.1 distributions for Windows, Linux, and Macintosh.

  • Allows students to install OpenOffice.org 1.1 software immediately, on any leading platform, without a large and possibly time-consuming download.

I. WRITING WORDS WITH WRITER.

1. Start Here.

2. Learning Writer’s Basics .

   Set Writer Options.

   Create a New Document.

   Open an Existing Document.

   Type Text into a Document.

   Edit Text.

   Move Around a Document.

   Find and Replace Text.

   Check a Document’s Spelling.

   Print a Document.

3. Making Your Words Look Good.

   About the Rulers.

   About Paragraph Breaks and Tabs.

   Apply Character Formatting.

   Apply Paragraph Formatting.

   Set Up Page Formatting.

   Create a Multicolumn Newsletter.

   About Styles and Templates.

   Use a Style.

   Use a Template.

4. Adding Lists, Tables, and Graphics.

   Add a Bulleted List.

   Add a Numbered List.

   Create a Table of Contents.

   Create an Index.

   About Writer Tables.

   Create a Table.

   Format a Table.

   Manage a Table.

   Insert Graphics in a Document.

   Draw with Writer.

   Add a Chart or Spreadsheet to a Document.

5. Using Writer’s Advanced Features.

   Use Mathematical Formulas in Documents.

   About Writer’s Automatic Correction Tools.

   Use AutoCorrect to Improve Your Typing.

   About Headers and Footers.

   Add a Header or Footer .

   Add a Footnote or Endnote.

   Save a Document As a PDF File.

II. CRUNCHING NUMBERS WITH CALC.

6. Getting to Know Calc.

   About Sheets and Spreadsheets.

   Set Calc Options.

   Create a New Spreadsheet.

   Open an Existing Spreadsheet.

   Enter Simple Data into a Spreadsheet.

   About Moving Around Calc.

   About Calc Formulas.

   Copy and Move Formulas.

   Edit Cell Data.

   Print a Spreadsheet .

7. Working with Calc Data.

   Find and Replace Data.

   About Calc Ranges.

   Create a Range.

   Fill Cells with Data.

   About Calc Functions.

   Enter Calc Functions.

   Use the Function AutoPilot.

   Reference Data Outside This Sheet.

   Work with Dates and Times.

   About Names As Addresses.

8. Formatting Spreadsheets with Calc.

   Freeze Row and Column Headers.

   AutoFormat a Spreadsheet.

   Format Cells .

   Center a Heading over Multiple Columns.

   Set Up Calc Page Formatting.

   Attach a Note to a Cell.

   Conditionally Format Data .

   About Calc Styles and Templates.

   Create a Calc Style.

   Create a Calc Template.

9. Creating Advanced Spreadsheets.

   Add a Chart to a Spreadsheet.

   Insert Graphics into a Spreadsheet.

   Protect Spreadsheet Data.

   Combine Multiple Cells into One.

   Ensure Valid Data Entry.

   Import and Export Sheet Data.

   About Advanced Spreadsheet Printing.

10. Using Calc As a Simple Database.

   About Calc Databases.

   Create a Calc Database.

   Import Data into a Calc Database.

   Sort Calc Database Data.

   Filter Data That You Want to See.

   Compute Table Totals and Subtotals.

III. IMPRESSING AUDIENCES WITH IMPRESS.

11. Learning About Impress.

   Set Impress Options.

   Create a New Presentation.

   Open an Existing Presentation.

   Run a Presentation.

   Print a Presentation.

12. Adding Flair to Your Presentations.

   Use an Impress Template.

   About Impress Views.

   Enter Text Into a Presentation.

   Find and Replace Text.

   Format Presentation Text.

   Animate Text.

   About Impress Styles.

   Use a Style.

   Change a Presentation’s Background.

13. Making More Impressive Presentations.

   Insert a Chart into a Presentation.

   Insert Graphics into a Presentation.

   Add a Presentation Header and Footer.

   Add Sound to a Presentation.

   Impress with Special Effects.

   Add a Slide Transition.

   Make an Automatic Presentation.

   Add Notes to a Presentation.

   Create Presentation Handouts.

   Turn a Presentation into Online Web Pages.

   About Giving Presentations.

IV. DRAWING ON YOUR INNER ARTIST WITH DRAW.

14. Getting Used to Draw.

   Set Draw Options.

   Create a New Drawing.

   Open an Existing Drawing.

   About Drawing with Draw.

   Print a Drawing.

15. Improving Your Drawings.

   Draw from Scratch.

   Place Shapes on the Drawing Area.

   Draw Lines.

   About Perfecting Shapes.

   Create a New Shape.

   Fill an Object.

   About Manipulating Objects.

   About Grouping Objects.

   Align Objects.

   Add Text to a Drawing.

16. Putting on Finishing Touches with Draw.

   About the Gallery.

   Insert Gallery Objects.

   Add New Items to Gallery.

   Add 3D Text.

   Convert 2D to 3D.

   Import a Graphic Image into Draw .

   Scan a Picture into Draw.

V. ENHANCING YOUR WORK WITH OPENOFFICE.ORG’S OTHER FEATURES.

17. Enhancing Your Work with More.

   OpenOffice.org Features.

   About OpenOffice.org Macros.

   Create and Use a Macro.

   About Master Documents.

   Create a Master Document.

   About Sharing OpenOffice.org Files with Other Applications.

   Associating OpenOffice.org and Microsoft Office Files.

   Upgrade OpenOffice.org to a New Version.

Office Applications  [KEY TRADE TITLES]   (CIS: Office Applications)

Greg Perry is a speaker and a writer on both the programming and application sides of computing. He is known for his skills at bringing advanced computer topics to the novice's level. Perry has been a programmer and a trainer since the early 1980s. He received his first degree in computer science and a master's degree in corporate finance. Perry has sold more than 2 million computer books worldwide, including such titles as Digital Video with Windows XP in a Snap, Sams Teach Yourself Windows XP in 24 Hours, Sams Teach Yourself Visual Basic 6 in 21 Days, as well as the phenomenal bestseller Sams Teach Yourself Office 2003 in 24 Hours. He also writes about rental property management, social and political issues, creates and manages websites, loves to travel and enjoys home life with his lovely wife Jayne and their two fluffy dogs Casper and Zucchi.

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!

For the CIS: Office Applications Discipline

PHIT TIPS Microsoft Access 2007
PrenticeHall
©2008   |   Sams Publishing   |   Study Card; 4 pp   |   Instock
ISBN-10: 0131588346   |   ISBN-13: 9780131588349
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

PHIT Tips: File Management
PrenticeHall
©2008   |   Sams Publishing   |   Study Card; 2 pp   |   Instock
ISBN-10: 0131588354   |   ISBN-13: 9780131588356
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

Phit TIPS: Microsoft Excel 2007
PrenticeHall
©2008   |   Sams Publishing   |   Study Card; 4 pp   |   Instock
ISBN-10: 0136128017   |   ISBN-13: 9780136128014
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

PHIT Tips: Microsoft Office 2007
PrenticeHall
©2008   |   Sams Publishing   |   Study Card; 4 pp   |   Instock
ISBN-10: 0132332221   |   ISBN-13: 9780132332224
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

PHIT Tips: Microsoft Outlook 2007
PrenticeHall
©2008   |   Sams Publishing   |   Study Card; 4 pp   |   Instock
ISBN-10: 0132050625   |   ISBN-13: 9780132050623
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

PHIT Tips: Microsoft PowerPoint 2007
PrenticeHall
©2008   |   Sams Publishing   |   Study Card; 4 pp   |   Instock
ISBN-10: 0132332558   |   ISBN-13: 9780132332552
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

PHIT Tips: Microsoft Word 2007
PrenticeHall
©2008   |   Sams Publishing   |   Study Card; 4 pp   |   Instock
ISBN-10: 0132050617   |   ISBN-13: 9780132050616
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

PHIT Tips: WinZip for Microsoft Office 2007
PrenticeHall
©2008   |   Sams Publishing   |   Study Card   |   Instock
ISBN-10: 0131588311   |   ISBN-13: 9780131588318
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

Shortcut Key Card: Microsoft Office 2007
PrenticeHall
©2008   |   Sams Publishing   |   Study Card; 2 pp   |   Instock
ISBN-10: 0131588400   |   ISBN-13: 9780131588400
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

Windows Vista PHIT Tip
Prentice Hall
©2008   |   Sams Publishing   |   Study Card; 4 pp   |   Instock
ISBN-10: 0136128025   |   ISBN-13: 9780136128021
Suggested retail price: $8.67  Buy from myPearsonStoreNet price: $6.50  (What's this?)

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.