Beginning OpenOffice Calc: From Setting Up Simple by Jacek Artymiak

By Jacek Artymiak

OpenOffice Calc is the main robust and frequent open resource spreadsheet program in lifestyles. it's the simply actual replacement to Excel. Jacek Artymiak is largely considered as the authority on OpenOffice Calc. He takes you, step-by-step, from the interface and dealing with Calc documents to operating with facts assets small and large. Artymiak then extends the reader's skillset to information visualization, writing complex formulation and acting statistical research. starting OpenOffice Calc permits you to achieve self assurance 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 approach and structure facts Write complicated formulation utilizing array services Collaborate on Calc records with the clients of Calc, Excel and different spreadsheet software program  Who this e-book is for it is a booklet for spreadsheet newcomers up to for somebody who would favor commence utilizing open resource purposes in an place of work setting. no matter if an individual has used Excel some time past and needs to transform to Calc, or simply desires to begin utilizing spreadsheets, this can be the publication for you. desk of ContentsIntroduction     Essentials       Formulas       Functions       Formatting       easy Mathematical Functions       software Mathematical Functions       necessary Statistical Functions       Calculations with Money       Formatting Functions       Conversion Functions       application Functions       Time & Date Functions      Conditional services 

Show description

Read or Download Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting PDF

Similar business technology books

Confessions of an IT Manager

Phil issue is a legend in his personal runtime. Scurrilous, absurd, confessional and scathing by means of turns, Confessions of an IT supervisor goals the idiocy, incompetence and overreach of the IT administration from vantage aspect all of the means up and down the greasy pole. Phil issue (real identify witheld to protest the to blame) has over twenty years adventure within the IT undefined, focusing on database-intensive functions.

Eurosource: The Euro Theatre Sourcebook for Cyberpunk

Information the recent Europe, together with the ecu group, lifestyles and Roles in Euro; and basic enjoying the Eurostyle means.

THE SEARCH - How Google and Its Rivals Rewrote the Rules of Business and Transfo

What does the realm wish? in keeping with John Battelle, a firm that solutions that query -- in all its colours of which means -- can liberate the main intractable riddles of either company and tradition. And for the previous few years, that is precisely what Google has been doing. leaping into the sport lengthy after Yahoo, Alta Vista, Excite, Lycos, and different pioneers, Google provided a thorough new method of seek, redefined the belief of viral advertising and marketing, survived the dotcom crash, and pulled off the biggest and such a lot mentioned preliminary public supplying within the historical past of Silicon Valley.

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

Sample text

You can also change width and height by placing the mouse pointer between the buttons with column (or row) numbers and dragging the boundary lines until they look the way you want them to. org Calc can automatically adjust column width and row height. Just place the mouse pointer between the separator buttons and double-click. Formatting Worksheets Formatting a worksheet is the top-most level of document design. Here you create the final layout of your work on paper and can specify the size of paper used for printing, headers, footers, page numbers, and so on.

9 (log 8). 10 Figure 5-6. Sample result of the LOG10 function See also the sections on the EXP, LN, LOG, and POWER functions. Power (POWER) Syntax: POWER(Number; Power) The POWER function returns number raised to the given power. For example: =POWER(10; 2) returns 100, or 102. It is equivalent to the following notation: =10^2 38 CHAPTER 5 ■ SIMPLE MATHEMATICAL FUNCTIONS Figure 5-7. Sample result of the POWER function See also the sections on the EXP, FACT, LN, LOG, LOG10, and SQRT functions. Product of Many Arguments (PRODUCT) Syntax: PRODUCT(ARG1; ARG2; … ARG30) The PRODUCT function multiplies up to 30 arguments (x1, x2, … x30).

31 CHAPTER 4 ■ FORMATTING Choose Format ➤ Page to display the Page Style dialog box. There are seven tabs in this dialog box: • Organizer—Enables you to choose one of the page styles available for this sheet. • Page—You can set Margins (useful when your printer seems to chop off parts of the printout), Paper Format (paper size, page orientation, and paper source), which you need to specify to make your printer use the right paper, if you have more than one source; otherwise use Printer settings, and Orientation, which should really be called Alignment of cells on paper—click the options and see the preview box to check the results.

Download PDF sample

Rated 4.83 of 5 – based on 47 votes