By Jacek Artymiak

OpenOffice Calc is the main strong and frequent open resource spreadsheet software in life. it's the basically genuine replacement to Excel. Jacek Artymiak is greatly considered as the authority on OpenOffice Calc. he's taking you, step-by-step, from the interface and dealing with Calc records to operating with information assets small and big. Artymiak then extends the reader's skillset to facts visualization, writing complicated formulation and acting statistical research. starting OpenOffice Calc permits you to achieve self belief within the thought of use of statistical formulation, yet doesn't suppose familiarity with one other spreadsheet program.

Show description

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

Best business technology books

Excel Formulas and Functions For Dummies

Placed the facility of Excel formulation and capabilities to be just right for you! Excel is a posh application. getting to know using formulation and features permits you to use Excel to compute beneficial day by day info, resembling calculating the real fee of bank card purchases or evaluating 15-year and 30-year loan expenditures.

Excel Simulations

Overlaying numerous Excel simulations, from playing to genetics, this advent is for individuals drawn to modeling destiny occasions, with out the price of a pricey textbook. The simulations coated supply a enjoyable substitute to the standard Excel subject matters and comprise occasions resembling roulette, password cracking, intercourse selection, inhabitants development, and site visitors styles, between many others.

Excel Pivot Tables & Introduction To Dashboards. The Step-By-Step Guide

This publication can be utilized as an educational or fast reference consultant. it's meant for clients who're happy with the fundamentals of Microsoft Excel and at the moment are able to construct upon this ability by means of studying Pivot Tables and Dashboards. This publication assumes how one can create, open, store, and adjust an Excel® workbook and feature a basic familiarity with the Excel toolbar (Ribbon).

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

Sample text

Here’s how you use CEILING: =CEILING(125,000; 18) The result you will get is 125,010. This tells you how many USB sticks you would need to fill all boxes with exactly 18 USB drives, but you only have 125,000 USB drives. That’s OK. One of the boxes will have less than 18 USB drives. You will give a special discount on those or just give them away. But you still need to know how many boxes you need. info CHAPTER 6 ■ UTILITY MATHEMATICAL FUNCTIONS And the answer is 6945. What if those boxes are sold one dozen per package?

Enter data into a sheet in some roughly organized manner. 2. Select the formatted area. 3. Choose Format ➤ AutoFormat. 4. Click the Add… button in the Auto-format dialog box. 5. Type in the name of your new format. 6. Click on the OK button. That’s it! org Calc. org Calc mathematical functions. org Calc works. Absolute Values of Numbers (ABS) Syntax: ABS(n) The ABS function removes the minus sign (–) from a negative number, making it positive. It does nothing to 0 (zero) or positive numbers. Figure 5-1.

Because the cheapest boxes you could find will hold a maximum of 18 drives and you want to sound original. Here’s how you use CEILING: =CEILING(125,000; 18) The result you will get is 125,010. This tells you how many USB sticks you would need to fill all boxes with exactly 18 USB drives, but you only have 125,000 USB drives. That’s OK. One of the boxes will have less than 18 USB drives. You will give a special discount on those or just give them away. But you still need to know how many boxes you need.

Download PDF sample

Rated 4.05 of 5 – based on 12 votes