Online Public Access Catalogue (OPAC)
Library,Documentation and Information Science Division

“A research journal serves that narrow

borderland which separates the known from the unknown”

-P.C.Mahalanobis


Normal view MARC view ISBD view

Excel 2010 formulas [electronic resource] / by John Walkenbach.

By: Walkenbach, John.
Material type: TextTextSeries: Mr. Spreadsheet's bookshelf: Publisher: Hoboken, NJ : Wiley Pub., c2010Description: 1 online resource (xxiii, 788 p.) : ill.ISBN: 9780470625514 (electronic bk.); 0470625511 (electronic bk.); 9780470625538 (electronic bk.); 0470625538 (electronic bk.).Other title: Microsoft Excel 2010 formulas [Cover title].Subject(s): Microsoft Excel (Computer file) | Business -- Computer programs | Electronic spreadsheets | COMPUTERS -- Desktop Applications -- Spreadsheets | Microsoft Excel (Computer software) | Business -- Computer software | Spreadsheet softwareGenre/Form: Electronic books.Additional physical formats: Print version:: Excel 2010 formulas.DDC classification: 005.54 Online resources: EBSCOhost
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.
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.
Tags from this library: No tags from this library for this title. Log in to add tags.
No physical items for this record

Includes index.

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.

Some online versions lack accompanying media packaged with the printed version.

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.

Description based on print version record.

There are no comments for this item.

Log in to your account to post a comment.

Other editions of this work

Excel 2010 formulas by Walkenbach, John. ©2010
Excel 2010 formulas by Walkenbach, John. ©2010
Library, Documentation and Information Science Division, Indian Statistical Institute, 203 B T Road, Kolkata 700108, INDIA
Phone no. 91-33-2575 2100, Fax no. 91-33-2578 1412, ksatpathy@isical.ac.in


Visitor Counter