Beginning OpenOffice Calc and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
Trade in Yours
For a £5.99 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Beginning OpenOffice Calc on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Beginning Openoffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting [Paperback]

Jacek Artymiak

RRP: £35.43
Price: £31.49 & FREE Delivery in the UK. Details
You Save: £3.94 (11%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want it Saturday, 25 Oct.? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition £22.33  
Paperback £31.49  
Trade In this Item for up to £5.99
Trade in Beginning Openoffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting for an Amazon Gift Card of up to £5.99, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

31 Aug 2011 1430231599 978-1430231592 1
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 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 ContentsIntroduction 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

Special Offers and Product Promotions

  • Between 20-26 October 2014, spend £10 in a single order on item(s) dispatched from and sold by and receive a £2 promotional code to spend in the Amazon Appstore. Here's how (terms and conditions apply)

Product details

Product Description

About the Author

A bio is not available for this author.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on (beta) 2.7 out of 5 stars  3 reviews
10 of 10 people found the following review helpful
3.0 out of 5 stars Concise introduction to productive Calc usage using built in Functions 11 Dec 2011
By Neil G. Matthews - Published on
At a brief 112 pages plus an 8 page index, you'll need to be sure that this book meets your particular needs. Its particular strengths are that it DOES quickly and concisely cover the basics of how to create and develop spreadsheets starting with Calc Essentials (chapter 1), Formulas, Functions and Formatting (chapters 2 to 4) and then covers in detail a selected subset of the standard OpenOffice Calc in-built functions in the remaining 9 chapters. I liked the way the author concisely adds in useful references to extensions of the subject being discussed without distracting from the main point.

While this book is written for OpenOffice Calc it equally applies to LibreOffice Calc [..]. Briefly, when Oracle bought out Sun Microsystems in April 2009, they inherited the OpenOffice suite and in the eyes of the Open Source movement, badly managed support and development of that suite. The result was LibreOffice, a new community-driven fork of the code by the not-for-profit organization, The Document Foundation. Eventually, not sure how they could profit from it, Oracle donated to the Apache Software Foundation in June 2011.

Both free office suites remain actively supported (when this review was written in December 2011, LibreOffice was at V3.4.4 vs OpenOffice at 3.3.0), but while recent updates to OpenOffice appear to mainly have reflected changes in ownership of the suite (e.g. splash screen changes), LibreOffice have incorporated long outstanding enhancements and some bug fixes in their releases, plus extended support for many more languages. At the level covered in this book, you can use either OpenOffice or LibreOffice and not notice any difference.

Both LibreOffice and OpenOffice work on Windows, Mac and Linux, enabling you to readily exchange documents between the different platforms. Both LibreOffice and OpenOffice support open standards for the file structure of your office documents, so using either gives you the huge advantage of not having access to your documents dictated by proprietary changes in a closed binary format office suite.

While the book doesn't specify which version of OpenOffice it is written for, any V3 version is fine.

How to know if this book is for you
While it could be argued that much of the book content can be found in the Help section of OpenOffice, the book's value is in the way it has selected and categorised a subset of useful functions and included worked examples for each covered function, quite often with useful references to related functions. Hence I recommend you check whether the content of chapters 5 to 13 match your anticipated usage of Calc. Simple and utility mathematical functions are over-viewed in chapters 5 and 6 respectively, useful statistical functions in chapter 7 and a pretty solid coverage (14 pages) of financial calculations is given in chapter 8. This chapter is where you'll quickly recoup the financial outlay on this book by learning how to use Calc to make better financial decisions! Chapter 9 covers text formatting functions, including coverage of functions like Clean and Trim that are useful to clean up imported data. Also covered are the TEXT and CONCATENATE/& functions that can prove useful if you want to format part of a text string in a cell. Chapter 10 covers conversion functions, utility functions (code to/from ASCII and string functions) are covered in chapter 11 and Chapter 12 is a very useful chapter on time and date functions (but no mention of how the display of time/date data changes with different country settings). The book finishes with how to use IF statements with relational operators and logical functions, showing how you can set up simple rules with these to give your spreadsheets some smarts.

What I expected to find and didn't
Given the book's claims that it covers working with large sets of data, I would have expected mention of how to import data from text or CSV files and the very useful navigation tips to move around large data files, Ctrl-direction-arrows, Ctr-Home, Ctrl-End and the Ctrl-Shift equivalents for selecting data.
Collaboration also gets a mention on the back cover, but I could only see a section on how to reference external Calc files in other sheets, worksheets or other computers.
There is virtually no mention of inter-operability with other office suites, nor coverage of charts.

LibreOffice and OpenOffice References:
1) LibreOffice vs OpenOffice status at October 2011

2) Excellent overview of the differences in V3.3.0 of the two suites:
2.0 out of 5 stars Not useful. Returned it. 19 Feb 2013
By Vicky Edwards - Published on
Format:Paperback|Verified Purchase
This book does not meet the needs of the begining user. Less than half was basic instruction. The rest consisted of explanations of functions, many of which a basic user would not need. In addition, the first half was in light ink and the small illustrations of toolbar buttons were impossible to distinguish one from the other. The type was small, not easy to read for an older user. I returned the book.
3.0 out of 5 stars Pretty good but small 18 Sep 2012
By Amazon Customer - Published on
Format:Kindle Edition|Verified Purchase
This is a pretty good book though I am not sure it would help someone who did not know anything about spreadsheets. It is good at explaining how ti use a spreadsheet but the most important part of using a spreadsheet is the formulas and this book is bad at explaining them. it is fast reading but had I not already known what the formulas were for I would have finished this book without knowing. For me this book was good but for a new person to spreadsheets I would suggest reading through the documentation and going on line to get documentation it is lot better than this book.
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category