Synopses & Reviews
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, tutorial by tutorial, from theinterface and handling Calc files to working with data sources small and large.Artymiak then extendsthe reader's skillset to data visualization, writingcomplex formulas and performing statistical analysis. Beginning OpenOffice Calc allows you to gain confidence in the considered use of statisticalformulas, but does notassume familiarity with another spreadsheet application. -->--> Artymiak takes special care to introduce you to the presentation, formatting, and visualization of data. Even interacting with other applicationsfor instance Google apps and Excelis covered in detail. Richly illustrated, Beginning OpenOffice Calc is the one-stop shop for OpenOffice Calc. Tutorial-based introduction to Calc from spreadsheet setup to statistical formulas Teaches the complete spreadsheet skill set, including data visualization and presentation -->What you'll learn-->Work with large sets of data Process and format data Imitate Excel's pivot tables Write complex formulas using array functions Use charts to visualize data 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.
Synopsis
Introduction
- Essentials
- Formulas
- Functions
- Formatting
- Simple Mathematical Functions
- Utility Mathematical Functions
- Useful Statistical Functions
- Calculations with Money
- Formatting Functions
- Conversion Functions
- Utility Functions
- Time & Date Functions
- Conditional Functions
Synopsis
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 Essentials Formulas Functions Formatting Simple Mathematical Functions Utility Mathematical Functions Useful Statistical Functions Calculations with Money Formatting Functions Conversion Functions Utility Functions Time & Date Functions Conditional Functions