skip to content
Excel Formulas and Functions for Dummies. Preview this item
ClosePreview this item
Checking...

Excel Formulas and Functions for Dummies.

Author: Ken Bluttman
Publisher: Newark : John Wiley & Sons, Incorporated, 2018.
Series: --For dummies.
Edition/Format:   eBook : Document : English : 5th edView all editions and formats
Rating:

(not yet rated) 0 with reviews - Be the first.

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Bluttman, Ken.
Excel Formulas and Functions for Dummies.
Newark : John Wiley & Sons, Incorporated, ©2018
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Ken Bluttman
ISBN: 9781119518273 111951827X
OCLC Number: 1064935469
Notes: Looking for a Sign.
Description: 1 online resource (403 pages)
Contents: Intro; Title Page; Copyright Page; Table of Contents; Introduction; About This Book; Foolish Assumptions; How to Use This Book; Icons Used in This Book; Where to Go from Here; Part 1 Getting Started with Formulas and Functions; Chapter 1 Tapping Into Formula and Function Fundamentals; Working with Excel Fundamentals; Understanding workbooks and worksheets; Introducing the Formulas Tab; Working with rows, column, cells, ranges, and tables; Formatting your data; Getting help; Gaining the Upper Hand on Formulas; Entering your first formula; Understanding references. Copying formulas with the fill handleAssembling formulas the right way; Using Functions in Formulas; Looking at what goes into a function; Arguing with a function; Nesting functions; Chapter 2 Saving Time with Function Tools; Getting Familiar with the Insert Function Dialog Box; Finding the Correct Function; Entering Functions Using the Insert Function Dialog Box; Selecting a function that takes no arguments; Selecting a function that uses arguments; Entering cells, ranges, named areas, and tables as function arguments; Getting help in the Insert Function dialog box. Using the Function Arguments dialog box to edit functionsDirectly Entering Formulas and Functions; Entering formulas and functions in the Formula Bar; Entering formulas and functions directly in worksheet cells; Chapter 3 Saying "Array!" for Formulas and Functions; Discovering Arrays; Using Arrays in Formulas; Working with Functions That Return Arrays; Chapter 4 Fixing Formula Boo-Boos; Catching Errors As You Enter Them; Getting parentheses to match; Avoiding circular references; Mending broken links; Using the Formula Error Checker; Auditing Formulas; Watching the Watch Window. Evaluating and Checking ErrorsMaking an Error Behave the Way You Want; Part 2 Doing the Math; Chapter 5 Calculating Loan Payments and Interest Rates; Understanding How Excel Handles Money; Going with the cash flow; Formatting for currency; Choosing separators; Figuring Loan Calculations; Calculating the payment amount; Calculating interest payments; Calculating payments toward principal; Calculating the number of payments; Calculating the number of payments with PDURATION; Calculating the interest rate; Calculating the principal. Chapter 6 Appreciating What You'll Get, Depreciating What You've GotLooking into the Future; Depreciating the Finer Things in Life; Calculating straight-line depreciation; Creating an accelerated depreciation schedule; Creating an even faster accelerated depreciation schedule; Calculating a midyear depreciation schedule; Measuring Your Internals; Chapter 7 Using Basic Math Functions; Adding It All Together with the SUM Function; Rounding Out Your Knowledge; Just plain old rounding; Rounding in one direction; Leaving All Decimals Behind with INT; Leaving Some Decimals Behind with TRUNC.
Series Title: --For dummies.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/1064935469> # Excel Formulas and Functions for Dummies.
    a schema:CreativeWork, schema:Book, schema:MediaObject ;
    library:oclcnum "1064935469" ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/2735778#Place/newark> ; # Newark
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/nju> ;
    schema:about <http://dewey.info/class/005.54/> ;
    schema:bookEdition "5th ed." ;
    schema:bookFormat schema:EBook ;
    schema:creator <http://experiment.worldcat.org/entity/work/data/2735778#Person/bluttman_ken> ; # Ken Bluttman
    schema:datePublished "2018" ;
    schema:description "Intro; Title Page; Copyright Page; Table of Contents; Introduction; About This Book; Foolish Assumptions; How to Use This Book; Icons Used in This Book; Where to Go from Here; Part 1 Getting Started with Formulas and Functions; Chapter 1 Tapping Into Formula and Function Fundamentals; Working with Excel Fundamentals; Understanding workbooks and worksheets; Introducing the Formulas Tab; Working with rows, column, cells, ranges, and tables; Formatting your data; Getting help; Gaining the Upper Hand on Formulas; Entering your first formula; Understanding references."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/2735778> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isPartOf <http://experiment.worldcat.org/entity/work/data/2735778#Series/for_dummies> ; # --For dummies.
    schema:isSimilarTo <http://worldcat.org/entity/work/data/2735778#CreativeWork/excel_formulas_and_functions_for_dummies> ;
    schema:name "Excel Formulas and Functions for Dummies."@en ;
    schema:productID "1064935469" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/1064935469#PublicationEvent/newark_john_wiley_&_sons_incorporated_2018> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/2735778#Agent/john_wiley_&_sons_incorporated> ; # John Wiley & Sons, Incorporated
    schema:url <https://public.ebookcentral.proquest.com/choice/publicfullrecord.aspx?p=5572463> ;
    schema:workExample <http://worldcat.org/isbn/9781119518273> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/1064935469> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/2735778#Agent/john_wiley_&_sons_incorporated> # John Wiley & Sons, Incorporated
    a bgn:Agent ;
    schema:name "John Wiley & Sons, Incorporated" ;
    .

<http://experiment.worldcat.org/entity/work/data/2735778#Person/bluttman_ken> # Ken Bluttman
    a schema:Person ;
    schema:familyName "Bluttman" ;
    schema:givenName "Ken" ;
    schema:name "Ken Bluttman" ;
    .

<http://experiment.worldcat.org/entity/work/data/2735778#Series/for_dummies> # --For dummies.
    a bgn:PublicationSeries ;
    schema:hasPart <http://www.worldcat.org/oclc/1064935469> ; # Excel Formulas and Functions for Dummies.
    schema:name "--For dummies." ;
    schema:name "--For dummies" ;
    .

<http://worldcat.org/entity/work/data/2735778#CreativeWork/excel_formulas_and_functions_for_dummies>
    a schema:CreativeWork ;
    rdfs:label "Excel Formulas and Functions for Dummies." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/1064935469> ; # Excel Formulas and Functions for Dummies.
    .

<http://worldcat.org/isbn/9781119518273>
    a schema:ProductModel ;
    schema:isbn "111951827X" ;
    schema:isbn "9781119518273" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.