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
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Hoboken, New Jersey :
John Wiley ,
c2010
|
| Series: | Mr. Spreadsheet?s bookshelf
|
| Subjects: |
| 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 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 |
|---|---|
| Item Description: | Includes index |
| Physical Description: | xxiii, 788 p. : ill. ; 24 cm. 1 CD-ROM (4 3/4 in.) |
| ISBN: | 0470475366 (paperback : alk. paper) 9780470475362 (paperback : alk. paper) |