Descript |
xxiii, 788 p. : ill. ; 24 cm. + 1 CD-ROM (4 3/4 in.). |
Note |
Includes index. |
|
Accompanying CD-ROM contains complete text in PDF format and supplementary material. |
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. |
ISBN |
9780470475362 (pbk.) |
|
0470475366 (pbk.) |
|