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)
- Double-Declining Balance Method (DDB)
- Straight Line Depreciation (SLN)
- Sum-of-Years 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 – Case-Sensitive)
- Replacing Strings (REPLACE)
- Searching for Strings (SEARCH – Case-Insensitive)
- 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
Practical Free Alternatives to Commercial Software
Get all the things done you're used to doing with pricey software at a fraction of …
audiobook
Transformed
Help transform your business and innovate like the world's top tech companies! Transformed: Moving to the …
book
Harvard Business Review Leader's Handbook
The one primer you need to develop your leadership skills. Put aside all the overhyped new …
book
HBR Guide to Project Management
You've been asked to lead a project. You appreciate the vote of confidence, but are you …