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

Bibliographic Details
Main Author: Walkenbach, John (Author)
Format: Book
Language:English
Published: Hoboken, New Jersey : John Wiley , c2010
Series:Mr. Spreadsheet?s bookshelf
Subjects:

MARC

LEADER 00000cam a2200000 7i4500
001 0000074617
005 20111024093000.0
008 110621s2010 nju eng
020 |a 0470475366 (paperback : alk. paper) 
020 |a 9780470475362 (paperback : alk. paper) 
050 0 0 |a HF5548.4.M523   |b W351 2010 
090 0 0 |a HF5548.4.M523   |b W351 2010 
100 1 |a Walkenbach, John ,   |e author 
245 1 0 |a Excel 2010 formulas   |c by John Walkenbach 
246 3 0 |a Microsoft Excel 2010 formulas 
260 |a Hoboken, New Jersey :   |b John Wiley ,   |c c2010 
300 |a xxiii, 788 p. :   |b ill. ;   |c 24 cm.   |e 1 CD-ROM (4 3/4 in.) 
490 1 |a Mr. Spreadsheet?s bookshelf 
500 |a Includes index 
505 0 |a 1. Basic information -- 2. Using functions in your formulas -- 3. Financial formulas -- 4. Array formulas -- 5. Miscellaneous techniques -- 6. Developing custom worksheet functions 
520 |a 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 
520 |a 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 
630 0 0 |a Microsoft Excel (Computer file) 
650 0 |a Business   |x Computer programs 
650 0 |a Electronic spreadsheets 
999 |a 1000141482   |b Book   |c OPEN SHELF (30 DAYS)   |e Tembila Campus 
999 |a 1000142921   |b CD-ROM   |c Reference   |e Tembila Campus