Book description
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
 Title
 Contents at a Glance
 Contents
 About the Author
 Preface
 Chapter 1: Essentials
 Chapter 2: Formulas
 Chapter 3: Functions
 Chapter 4: Formatting
 Chapter 5: Simple Mathematical Functions

Chapter 6: Utility Mathematical Functions
 Nearest Multiple Larger Than or Equal To X (CEILING)
 Nearest Even Integer (EVEN)
 Nearest Multiple Smaller Than or Equal To X (FLOOR)
 Nearest Integer (INT)
 Nearest Odd Integer (ODD)
 Random Number (RAND)
 Rounding Numbers (ROUND)
 Rounding Numbers Down (ROUNDDOWN)
 Rounding Numbers Up (ROUNDUP)
 Truncate (TRUNC)
 Chapter 7: Useful Statistical Functions

Chapter 8: Calculations with Money
 Investment Calculations
 Cumulative Compounded Interest (CUMIPMT)
 Cumulative Principal Capital (CUMPRINC)
 Time to Maturity (DURATION)
 Effective Rate of Interest (EFFECTIVE)
 Future Value (FV)
 Interest (IPMT)
 Internal Rate of Return (IRR)
 Nominal Rate of Interest (NOMINAL)
 Time to Repay a Loan (NPER)
 Net Present Value (NPV)
 Payment (PMT)
 Capital (PPMT)
 Present Value (PV)
 Annual Rate of Interest for Loans (RATE)
 Annual Rate of Interest for Savings (RRI)
 Asset Depreciation
 Declining Balance Method (DB)
 DoubleDeclining Balance Method (DDB)
 Straight Line Depreciation (SLN)
 SumofYears Method (SYD)
 Double Declining Curve Method (VDB)
 Chapter 9: Formatting Functions

Chapter 10: Conversion Functions
 Converting Between Numeric Systems (BASE)
 Converting Numbers into Currency Strings (DOLLAR)
 Adding Thousand Separators (FIXED)
 Searching for Strings (FIND – CaseSensitive)
 Replacing Strings (REPLACE)
 Searching for Strings (SEARCH – CaseInsensitive)
 Selectively Replacing Strings (SUBSTITUTE)
 Conditional Functions
 Comparing Strings (EXACT)
 Chapter 11: Utility Functions

Chapter 12: Time & Date Functions
 Functions that Return a Timestamp
 Timestamp (DATE)
 Today’s Timestamp (TODAY)
 Extracting Date Components
 Extracting Days from a Date (DAY)
 Extracting Weekdays from a Date (WEEKDAY)
 Extract Week Number from a Date (WEEKNUM)
 Extract Month from a Date (MONTH)
 Extract Year from a Date (YEAR)
 Number of Days in a Year (DAYSINYEAR)
 Number of Weeks in a Year (WEEKSINYEAR)
 Functions that Calculate the Difference Between Two Dates
 Difference Between Two Dates in Real Units (DAYS)
 Difference Between Two Dates in Banker’s Units (DAYS360)
 Number of Months Between Two Dates (MONTHS)
 Number of Weeks Between Two Dates (WEEKS)
 Number of Months Between Two Dates (YEARS)
 Chapter 13: Conditional Functions
 Index
Product information
 Title: Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting
 Author(s):
 Release date: September 2011
 Publisher(s): Apress
 ISBN: 9781430231592
You might also like
book
Operating System Concepts, 9th Edition
, now in its ninth edition, continues to provide a solid theoretical foundation for understanding operating …
book
The Linux Programming Interface
The Linux Programming Interface is the definitive guide to the Linux and UNIX programming interface—the interface …
book
40 Algorithms Every Programmer Should Know
Learn algorithms for solving classic computer science problems with this concise guide covering everything from fundamental …
book
Automate the Boring Stuff with Python, 2nd Edition
If you’ve ever spent hours renaming files or updating hundreds of spreadsheet cells, you know how …