Kids Library Home

Welcome to the Kids' Library!

Search for books, movies, music, magazines, and more.

     
Available items only
Record 14 of 135
Previous Record Next Record
E-Books/E-Docs
Author Artymiak, Jacek.

Title Beginning OpenOffice Calc : from setting up simple spreadsheets to business forecasting / Jacek Artymiak.

Imprint [Berkeley, CA] : Apress, 2011.

Copies

Location Call No. OPAC Message Status
 Axe Books 24x7 IT E-Book  Electronic Book    ---  Available
Description 1 online resource.
text txt rdacontent
computer c rdamedia
online resource cr rdacarrier
text file PDF rda
Series The expert's voice in open source
Expert's voice in open source.
Note Online resource; title from PDF title page (EBSCO, viewed November 29, 2017).
Summary 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 theinterface and handling Calc files to working with data sources small and large. Artymiak then extendsthe reader's skillset to data visualization, writingcomplex formulas and performing statistical analysis. Beginning OpenOffice Calc allows you to gain confidence in the considered use of statisticalformulas, but does notassume familiarity with another spreadsheet application.
Contents Machine generated contents note: ch. 1 Essentials -- Creating a New Worksheet -- Entering Data -- How OpenOffice.org Calc Treats Your Input -- Text -- Numbers -- Dates -- Time -- Editing Data -- Adding Comments to Cells -- ch. 2 Formulas -- Great Formulas -- Understanding Formula Syntax -- Referencing Cells -- Relative Addressing -- Absolute Addressing -- Referencing Data Stored on Other Sheets -- Referencing Data Stored in Other Worksheets -- Referencing Data Stored on Other Computers -- Giving Cells Names -- ch. 3 Functions -- Creating Formulas by Hand -- Taming the Function Wizard -- Constructing Complex Formulas -- ch. 4 Formatting -- Formatting Text -- Formatting Toolbar -- Cell Content Alignment -- Text Styling -- Numeric Formats -- Creating Your Own Numeric Formats -- Creating Conditional Formatting -- Formatting Cells -- Formatting Columns and Rows -- Formatting Worksheets -- Auto-formatting Sheets -- Adding New Designs to the Auto-format List -- ch. 5 Simple Mathematical Functions -- Absolute Values of Numbers (ABS) -- Syntax: ABS(n) -- Exponential Function (EXP) -- Syntax: EXP(Number) -- Factorial Function (FACT) -- Syntax: FACT(n) -- Natural Logarithm (LN) -- Syntax: LN(Number) -- Logarithm (LOG) -- Syntax: LOG(Number; Base) -- Logarithm Base 10 (LOG10) -- Syntax: LOGIO(Number) -- Power (POWER) -- Syntax: POWER(Number; Power) -- Product of Many Arguments (PRODUCT) -- Syntax: PRODUCT(ARG1; ARG2; ... ARG30) -- Square Root (SQRT) -- Syntax: SQRT(Number) -- Sum of Many Arguments (SUM) -- Syntax: SUM(x1; x2; ... x30) -- Sum of Squares of Many Arguments (SUMSQ) -- Syntax: SUMSQ(x1; x2; ... x30) -- ch. 6 Utility Mathematical Functions -- Nearest Multiple Larger Than or Equal To X (CEILING) -- Syntax: CEILING(Number; Significance; Mode) -- Nearest Even Integer (EVEN) -- Syntax: EVEN(Number) -- Nearest Multiple Smaller Than or Equal To X (FLOOR) -- Syntax: FLOOR(Number; Significance; Mode) -- Nearest Integer (INT) -- Syntax: INT(Number) -- Nearest Odd Integer (ODD) -- Syntax: ODD(Number) -- Random Number (RAND) -- Syntax: RAND() -- Rounding Numbers (ROUND) -- Syntax: ROUND(x; y) -- Rounding Numbers Down (ROUNDDOWN) -- Syntax: ROUNDDOWN(x; y) -- Rounding Numbers Up (ROUNDUP) -- Syntax: ROUNDUP(x; y) -- Truncate (TRUNC) -- Syntax: TRUNC(x; y) -- ch. 7 Useful Statistical Functions -- Average (AVERAGE) -- Syntax: AVERAGE(x1; x2; ... x30) -- Geometric Mean (GEOMEAN) -- Syntax: GEOMEAN(x1; x2; ... x30) -- Harmonic Mean (HARMEAN) -- Syntax: HARMEAN(x1; x2; ... x30) -- Median (MEDIAN) -- Syntax: MEDIAN(x1; x2; ... x30) -- Counting Cells (COUNT) -- Syntax: COUNT(x1; x2; ... x30) -- Counting Cells (COUNTA) -- Syntax: C0UNTA(x1; x2; ... x30) -- Kth Largest Value (LARGE) -- Syntax: LARGE(x; k) -- Kth Smallest Value (SMALL) -- Syntax: SMALL(x; k) -- Maximum (MAX) -- Syntax: MAX(x1; x2; ... x30) -- Minimum (MIN) -- Syntax: MIN(x1; x2; ... x30) -- Mode Function (MODE) -- Syntax: MODE(x1; x2; ... x30) -- Rank Function (RANK) -- Syntax: RANK(number; set; order) -- ch. 8 Calculations with Money -- Investment Calculations -- Cumulative Compounded Interest (CUMIPMT) -- Syntax: CUMIPMT(Interest; Time; Capital; Start; End; Type) -- Cumulative Principal Capital (CUMPRINC) -- Syntax: CUMPRINC(Interest; Time; Capital; Start; End; Type) -- Time to Maturity (DURATION) -- Syntax: DURATION(Interest; Investment; Future) -- Effective Rate of Interest (EFFECTIVE) -- Syntax: EFFECTIVE(Nominal; Periods) -- Future Value (FV) -- Syntax: FV(Interest; Time; Installment; Deposit; Type) -- Interest (IPMT) -- Syntax: IPMT(Interest; Period; Time; Loan; Future; Type) -- Internal Rate of Return (IRR) -- Syntax: IRR(Cash Flows; Guess) -- Nominal Rate of Interest (NOMINAL) -- Syntax: NOMINAL(Effective; Periods) -- Time to Repay a Loan (NPER) -- Syntax: NPER(Interest; Installment; Loan; Future; Type) -- Net Present Value (NPV) -- Syntax: NPV(Discount; Value1; Value2; ... Value30) -- Payment (PMT) -- Syntax: PMT(Interest; Time; Loan; Future; Type) -- Capital (PPMT) -- Syntax: PPMT(lnterest; Period; Time; Loan; Future; Type) -- Present Value (PV) -- Syntax: PV(lnterest; Time; Installment; Future; Type) -- Annual Rate of Interest for Loans (RATE) -- Syntax: RATE(Time; Installment; Investment; Future; Type) -- Annual Rate of Interest for Savings (RRI) -- Syntax: RRI(Time; Value; Future) -- Asset Depreciation -- Declining Balance Method (DB) -- Syntax: DB(Cost; Salvage; Life; Period; Months) -- Double-Declining Balance Method (DDB) -- Syntax: DDB(Cost; Salvage; Life; Period; Factor) -- Straight Line Depreciation (SLN) -- Syntax: SLN(Cost; Salvage; Life) -- Sum-of-Years Method (SYD) -- Syntax: SYD(Cost; Salvage; Life; Period) -- Double Declining Curve Method (VDB) -- Syntax: VDB(Cost; Salvage; Life; Start_Period; End_Period; Factor; No_Switch) -- ch. 9 Formatting Functions -- ARABIC -- Syntax: ARABIC(text) -- Join Strings of Text (& or CONCATENATE) -- Syntax: & or CONCATENATE(text1; text2; ... text30) -- CLEAN -- Syntax: CLEAN(text) -- LOWER -- Syntax: LOWER(text) -- PROPER -- Syntax: PROPER(text) -- ROMAN -- Syntax: ROMAN(number, mode) -- TEXT -- Syntax: TEXT(number; format) -- TRIM -- Syntax: TRIM(text) -- UPPER -- Syntax: UPPER(text) -- ch. 10 Conversion Functions -- Converting Between Numeric Systems (BASE) -- Syntax: BASE(Number; Base; Min_Length) -- Converting Numbers into Currency Strings (DOLLAR) -- Syntax: DOLLAR(Value; DecimaL_Places) -- Adding Thousand Separators (FIXED) -- Syntax: FIXED(Number; Decimal_Places; No_Commas) -- Searching for Strings (FIND -- Case-Sensitive) -- Syntax: FIND(Find_Text; Source_Text; Start_From) -- Replacing Strings (REPLACE) -- Syntax: REPLACE(Old_Text; Start_Number; Number_of_Chars; New_Text) -- Searching for Strings (SEARCH -- Case-Insensitive) -- Syntax: SEARCH(Find_Text; Source_Text; Start_Number) -- Selectively Replacing Strings (SUBSTITUTE) -- Syntax: SUBSTITUTE(Source_Text; Substring; New_Text; Occurrence) -- Conditional Functions -- Comparing Strings (EXACT) -- Syntax: EXACT(t1; t2) -- ch. 11 Utility Functions -- ASCII Character (CHAR) -- Syntax: CHAR(Number) -- ASCII Code (CODE) -- Syntax: CODE(Text) -- Left-Side Substring (LEFT) -- Syntax: LEFT(Text; n) -- Length of a String (LEN) -- Syntax: LEN(Text) -- Middle (MID) -- Syntax: MID(Text; Start; n) -- Repeat String (REPT) -- Syntax: REPT(Text; Repetitions) -- Right-Side Substring (RIGHT) -- Syntax: RIGHT(Text; n) -- Obfuscate (ROT13) -- Syntax: ROT13(Text) -- Return Text Values Only (T) -- Syntax: T(Value) -- ch. 12 Time & Date Functions -- Functions that Return a Timestamp -- Timestamp (DATE) -- Syntax: DATE(Year; Month; Day) -- Today's Timestamp (TODAY) -- Syntax: TODAY() -- Extracting Date Components -- Extracting Days from a Date (DAY) -- Syntax: WEEKDAY(t; Day) -- Extracting Weekdays from a Date (WEEKDAY) -- Syntax: WEEKDAYS(t; Day) -- Extract Week Number from a Date (WEEKNUM) -- Syntax: WEEKNUM(t; Day) -- Extract Month from a Date (MONTH) -- Syntax: MONTH(t) -- Extract Year from a Date (YEAR) -- Syntax: YEAR(t) -- Syntax: DAYSINMONTH(t) -- Number of Days in a Year (DAYSINYEAR) -- Syntax: DAYSINYEAR(t) -- Number of Weeks in a Year (WEEKSINYEAR) -- Syntax: WEEKSINYEAR(t) -- Functions that Calculate the Difference Between Two Dates -- Difference Between Two Dates in Real Units (DAYS) -- Syntax: DAYS(t1; t2) -- Difference Between Two Dates in Banker's Units (DAYS360) -- Syntax: DAYS360(t1; t2; Year_Type) -- Number of Months Between Two Dates (MONTHS) -- Syntax: M0NTHS(t1; t2) -- Number of Weeks Between Two Dates (WEEKS) -- Syntax: WEEKS(t1; t2; Week_Type) -- Number of Months Between Two Dates (YEARS) -- Syntax: YEARS(t1; t2; Year_Type) -- ch.
13 Conditional Functions -- Making Decisions (IF) -- Syntax: IF(Test; True; False) -- Relational Operators -- Logical Functions -- AND -- Syntax: AND(Cond_1; Cond_2; ... Cond_30) -- FALSE -- Syntax: FALSE() -- NOT -- Syntax: NOT(Logic_Value) -- OR -- Syntax: OR(Cond_1; Cond_2 ... Cond_30) -- TRUE -- Syntax: TRUE().
Subject OpenOffice.org (Electronic resource)
OpenOffice.org (Electronic resource) (OCoLC)fst01398071
Business -- Computer programs -- Handbooks, manuals, etc.
Electronic spreadsheets -- Handbooks, manuals, etc.
Arithmetic -- Data processing.
Business forecasting.
COMPUTERS -- Desktop Applications -- Spreadsheets.
Arithmetic -- Data processing. (OCoLC)fst00814489
Business -- Computer programs. (OCoLC)fst00842283
Business forecasting. (OCoLC)fst00842699
Electronic spreadsheets. (OCoLC)fst00907463
Genre/Form Electronic books.
Handbooks and manuals. (OCoLC)fst01423877
ISBN 9781430231608 (electronic bk.)
1430231602 (electronic bk.)
9781430231592
1430231599
Standard No. 10.1007/978-1-4302-3160-8 doi
AU@ 000048720118
AU@ 000053275699
AU@ 000060583582
DEBSZ 367965003
DEBSZ 397270062
NZ1 14263693

 
    
Available items only