skip to content
Excel 2010 formulas Preview this item
ClosePreview this item
Checking...

Excel 2010 formulas

Author: John Walkenbach
Publisher: Hoboken, NJ : Wiley Pub., ©2010.
Series: Mr. Spreadsheet's bookshelf.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Database:WorldCat
Summary:
A reference collection of formulas for spreadsheet challenges covers operators, nesting, functions, error values, naming, cell formatting, protection options, array formulas, pivot tables, and auditing.
Rating:

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

Subjects
More like this

 

Find a copy online

Find a copy in the library

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

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Walkenbach, John.
Excel 2010 formulas.
Hoboken, NJ : Wiley Pub., ©2010
(OCoLC)567008116
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: John Walkenbach
ISBN: 9780470625514 0470625511 9780470625538 0470625538 9781118257630 1118257634 9781621984283 1621984281
OCLC Number: 680048766
Description: 1 online resource (xxiii, 788 pages) : illustrations.
Contents: Excel in a nutshell --
Basic facts about formulas --
Working with names --
Introducing worksheet function --
Manipulating text --
Working with dates and times --
Counting and summing techniques --
Using lookup functions --
Tables and worksheet databases --
Miscellaneous calculations --
Borrowing and investing formulas --
Discounting and depreciation formulas --
Financial schedules --
Introducing arrays --
Performing magic with array formulas --
Intentional circular references --
Charting techniques --
Pivot tables --
Conditional formatting and data validation --
Creating megaformulas --
Tools and methods for debugging formulas --
Introducing VBA --
Function procedure basics --
VBA programming concepts --
VBA custom function examples.
Series Title: Mr. Spreadsheet's bookshelf.
Other Titles: Microsoft Excel 2010 formulas
Responsibility: by John Walkenbach.

Abstract:

Take your Excel formulas to the next level with this updatedreference <p>John Walkenbach's name is synonymous with excellence in computerbooks that decipher complex technical topics. Known as "Mr.  Read more...

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/680048766> # Excel 2010 formulas
    a schema:Book, schema:CreativeWork, schema:MediaObject ;
    library:oclcnum "680048766" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/nju> ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/495568278#Place/hoboken_nj> ; # Hoboken, NJ
    rdfs:comment "Warning: This malformed URI has been treated as a string - 'http://images.contentreserve.com/ImageType-100/0128-1/{98595199-1CBB-4B20-8AB7-F2DF77C9C0B5}Img100.jpg'" ;
    schema:about <http://experiment.worldcat.org/entity/work/data/495568278#Topic/computers_desktop_applications_spreadsheets> ; # COMPUTERS--Desktop Applications--Spreadsheets
    schema:about <http://experiment.worldcat.org/entity/work/data/495568278#CreativeWork/microsoft_excel_computer_file> ; # Microsoft Excel (Computer file)
    schema:about <http://experiment.worldcat.org/entity/work/data/495568278#Topic/spreadsheet_software> ; # Spreadsheet software
    schema:about <http://id.worldcat.org/fast/1366659> ; # Microsoft Excel (Computer file)
    schema:about <http://experiment.worldcat.org/entity/work/data/495568278#Topic/business_computer_programs> ; # Business--Computer programs
    schema:about <http://id.loc.gov/authorities/subjects/sh85018263> ; # Business--Computer programs
    schema:about <http://dewey.info/class/005.54/e22/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/495568278#Topic/electronic_spreadsheets> ; # Electronic spreadsheets
    schema:about <http://experiment.worldcat.org/entity/work/data/495568278#CreativeWork/microsoft_excel_computer_software> ; # Microsoft Excel (Computer software)
    schema:about <http://experiment.worldcat.org/entity/work/data/495568278#Topic/excel> ; # Excel
    schema:about <http://experiment.worldcat.org/entity/work/data/495568278#Topic/business_computer_software> ; # Business--Computer software
    schema:alternateName "Microsoft Excel 2010 formulas" ;
    schema:bookFormat schema:EBook ;
    schema:copyrightYear "2010" ;
    schema:creator <http://viaf.org/viaf/66601806> ; # John Walkenbach
    schema:datePublished "2010" ;
    schema:description "Excel in a nutshell -- Basic facts about formulas -- Working with names -- Introducing worksheet function -- Manipulating text -- Working with dates and times -- Counting and summing techniques -- Using lookup functions -- Tables and worksheet databases -- Miscellaneous calculations -- Borrowing and investing formulas -- Discounting and depreciation formulas -- Financial schedules -- Introducing arrays -- Performing magic with array formulas -- Intentional circular references -- Charting techniques -- Pivot tables -- Conditional formatting and data validation -- Creating megaformulas -- Tools and methods for debugging formulas -- Introducing VBA -- Function procedure basics -- VBA programming concepts -- VBA custom function examples."@en ;
    schema:description "A reference collection of formulas for spreadsheet challenges covers operators, nesting, functions, error values, naming, cell formatting, protection options, array formulas, pivot tables, and auditing."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/495568278> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isPartOf <http://experiment.worldcat.org/entity/work/data/495568278#Series/mr_spreadsheet_s_bookshelf> ; # Mr. Spreadsheet's bookshelf.
    schema:isSimilarTo <http://www.worldcat.org/oclc/567008116> ;
    schema:name "Excel 2010 formulas"@en ;
    schema:productID "680048766" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/680048766#PublicationEvent/hoboken_nj_wiley_pub_2010> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/495568278#Agent/wiley_pub> ; # Wiley Pub.
    schema:url <http://dx.doi.org/10.1002/9781118257630> ;
    schema:url <http://swbplus.bsz-bw.de/bsz421861282cov.htm> ;
    schema:url <http://www.books24x7.com/marc.asp?bookid=34796> ;
    schema:url <http://site.ebrary.com/id/10385880> ;
    schema:url <http://www.myilibrary.com?id=268502> ;
    schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=320620> ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=530023> ;
    schema:url <http://onlinelibrary.wiley.com/book/10.1002/9781118257630> ;
    schema:url <http://excerpts.cdn.overdrive.com/FormatType-410/0128-1/985/951/99/Excel2010FormulasMrSpreadsheetsBooksh9780470625538.epub> ;
    schema:url <http://app.knovel.com/web/toc.v/cid:kpEF000015> ;
    schema:url <http://www.myilibrary.com?id=268502&ref=toc> ;
    schema:url <https://samples.overdrive.com/?crid=98595199-1CBB-4B20-8AB7-F2DF77C9C0B5&.epub-sample.overdrive.com> ;
    schema:url <https://www.overdrive.com/search?q=98595199-1CBB-4B20-8AB7-F2DF77C9C0B5> ;
    schema:url "http://images.contentreserve.com/ImageType-100/0128-1/{98595199-1CBB-4B20-8AB7-F2DF77C9C0B5}Img100.jpg" ;
    schema:workExample <http://worldcat.org/isbn/9780470625514> ;
    schema:workExample <http://worldcat.org/isbn/9780470625538> ;
    schema:workExample <http://worldcat.org/isbn/9781118257630> ;
    schema:workExample <http://worldcat.org/isbn/9781621984283> ;
    schema:workExample <http://dx.doi.org/10.1002/9781118257630> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/680048766> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/495568278#CreativeWork/microsoft_excel_computer_file> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
    schema:name "Microsoft Excel (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/495568278#CreativeWork/microsoft_excel_computer_software> # Microsoft Excel (Computer software)
    a schema:CreativeWork ;
    schema:name "Microsoft Excel (Computer software)" ;
    .

<http://experiment.worldcat.org/entity/work/data/495568278#Series/mr_spreadsheet_s_bookshelf> # Mr. Spreadsheet's bookshelf.
    a bgn:PublicationSeries ;
    schema:hasPart <http://www.worldcat.org/oclc/680048766> ; # Excel 2010 formulas
    schema:name "Mr. Spreadsheet's bookshelf." ;
    schema:name "Mr. Spreadsheet's bookshelf" ;
    .

<http://experiment.worldcat.org/entity/work/data/495568278#Topic/business_computer_programs> # Business--Computer programs
    a schema:Intangible ;
    schema:name "Business--Computer programs"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/495568278#Topic/business_computer_software> # Business--Computer software
    a schema:Intangible ;
    schema:name "Business--Computer software"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/495568278#Topic/computers_desktop_applications_spreadsheets> # COMPUTERS--Desktop Applications--Spreadsheets
    a schema:Intangible ;
    schema:name "COMPUTERS--Desktop Applications--Spreadsheets"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/495568278#Topic/electronic_spreadsheets> # Electronic spreadsheets
    a schema:Intangible ;
    schema:name "Electronic spreadsheets"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/495568278#Topic/spreadsheet_software> # Spreadsheet software
    a schema:Intangible ;
    schema:name "Spreadsheet software"@en ;
    .

<http://id.loc.gov/authorities/subjects/sh85018263> # Business--Computer programs
    a schema:Intangible ;
    schema:name "Business--Computer programs"@en ;
    .

<http://id.worldcat.org/fast/1366659> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
    schema:name "Microsoft Excel (Computer file)" ;
    .

<http://onlinelibrary.wiley.com/book/10.1002/9781118257630>
    rdfs:comment "URL des Erstveröffentlichers" ;
    .

<http://viaf.org/viaf/66601806> # John Walkenbach
    a schema:Person ;
    schema:familyName "Walkenbach" ;
    schema:givenName "John" ;
    schema:name "John Walkenbach" ;
    .

<http://worldcat.org/isbn/9780470625514>
    a schema:ProductModel ;
    schema:isbn "0470625511" ;
    schema:isbn "9780470625514" ;
    .

<http://worldcat.org/isbn/9780470625538>
    a schema:ProductModel ;
    schema:isbn "0470625538" ;
    schema:isbn "9780470625538" ;
    .

<http://worldcat.org/isbn/9781118257630>
    a schema:ProductModel ;
    schema:isbn "1118257634" ;
    schema:isbn "9781118257630" ;
    .

<http://worldcat.org/isbn/9781621984283>
    a schema:ProductModel ;
    schema:isbn "1621984281" ;
    schema:isbn "9781621984283" ;
    .

<http://www.worldcat.org/oclc/567008116>
    a schema:CreativeWork ;
    rdfs:label "Excel 2010 formulas." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/680048766> ; # Excel 2010 formulas
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

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