Excel 2010 formulas:
Saved in:
Bibliographic Details
Main Author: Walkenbach, John (Author)
Format: Electronic eBook
Language:English
Published: Hoboken, NJ Wiley Pub. c2010
Series:Mr. Spreadsheet's bookshelf
Subjects:
Online Access:Volltext
Item Description:Includes index. - Some online versions lack accompanying media packaged with the printed version
Paralleltitel: Microsoft Excel 2010 formulas
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
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
Physical Description:1 Online-Ressource (xxiii, 788 p.)
ISBN:9780470625514
0470625511
9780470625538
0470625538
9780470475362
0470475366

There is no print copy available.

Interlibrary loan Place Request Caution: Not in THWS collection! Get full text