By Jacek Artymiak
OpenOffice Calc is the main strong and common open resource spreadsheet software in lifestyles. it's the in basic terms genuine replacement to Excel. Jacek Artymiak is generally considered as the authority on OpenOffice Calc. He takes you, step-by-step, from the interface and dealing with Calc records to operating with information resources small and large. Artymiak then extends the reader's skillset to information visualization, writing complex formulation and appearing statistical research. starting OpenOffice Calc permits you to achieve self belief within the thought of use of statistical formulas, yet does not assume familiarity with one other spreadsheet program. What you’ll research paintings with huge units of knowledge method and layout information Write advanced formulation utilizing array services Collaborate on OpenOffice.org Calc documents with the clients of Calc, Excel and different spreadsheet software program Who this booklet is for it is a booklet for spreadsheet newbies up to for someone who would favor begin utilizing open resource functions in an workplace atmosphere. even if somebody has used Excel some time past and desires to transform to Calc, or simply desires to begin utilizing spreadsheets, this is often the ebook for you. desk of ContentsIntroduction Essentials Formulas Functions Formatting uncomplicated Mathematical Functions software Mathematical Functions valuable Statistical Functions Calculations with Money Formatting Functions Conversion Functions software Functions Time & Date Functions Conditional features
Read Online or Download Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting PDF
Best business technology books
During this delicate, conscientiously paced direction, prime Perl running shoes and a home windows NT practitioner educate you to application within the language that can provide to turn out to be the scripting language of selection on NT. Perl for Win32 is a language for simply manipulating textual content, documents, consumer and crew profiles, functionality and occasion logs, and registry entries.
This ebook is designed to hide all the points of InfoPath 2010 inside of a SharePoint 2010 atmosphere with reference to making and constructing enterprise ideas. it really is aimed toward either technical and semi-technical execs and doesn't require a level in desktop programming to make use of. The scenario-based presentation of the fabric offers not just a very good instructional but additionally an in-depth reference for attaining crucial InfoPath 2010 initiatives in the SharePoint platform.
Extra info for Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting
55 CHAPTER 7 ■ USEFUL STATISTICAL FUNCTIONS Minimum (MIN) Syntax: MIN(x1; x2; … x30) The MAX function can take up to 30 arguments, which can be ranges of cells, and returns the maximum value found in the given set. For example: =MIN(B145; C145; D145; B147; C147; D147, B149; C149; D149) returns 2. Figure 7-10. Sample result of the MIN function See also the sections on the LARGE, MAX, and SMALL functions. Mode Function (MODE) Syntax: MODE(x1; x2; … x30) The MODE function returns the most common value in a data set that can consist of up to 30 arguments, which can be single values or ranges of cells.
Don’t use this argument at all unless you want to use the type argument as well, which is equal to 1 when payments are made at the beginning of each accounting period or equal to 0 when payments are made at the end of each accounting period. See also the sections on the IPMT and PPMT functions. Net Present Value (NPV) Syntax: NPV(Discount; Value1; Value2; … Value30) The NPV function returns the Net Present Value of an investment. Consider the coffee shop example, discussed previously, in connection with the IRR function.
After you do that, choose a different style for each condition and click OK. Next, type several numbers that belong to the ranges you just defined into that cell and see them displayed in different styles. Figure 4-7. Setting up conditional formatting The default cell styles are not very useful; therefore you need to create them, one at a time, and import them into the Styles and Formatting manager (press F11). After that, they are available in the Conditional Formatting dialog box. 29 CHAPTER 4 ■ FORMATTING Figure 4-8.