Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting

Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting

by Jacek Artymiak
     
 

View All Available Formats & Editions

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 theinterface and handling Calc files to working with data sources small and large.Artymiak then

…  See more details below

Overview

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 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.

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

Read More

Product Details

ISBN-13:
9781430231592
Publisher:
Apress
Publication date:
09/04/2011
Edition description:
2011
Pages:
136
Product dimensions:
7.30(w) x 9.20(h) x 0.50(d)

Meet the Author

A bio is not available for this author.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >