Excel 2007 formulas / John Walkenbach.
By: Walkenbach, John
.
Material type: 



Item type | Current library | Collection | Call number | Status | Date due | Barcode | |
---|---|---|---|---|---|---|---|
Two Weeks | Davenport Library Circulating Collection | Print-Circulating | 005.54 W15 2007 (Browse shelf(Opens below)) | Available | 34284003710910 |
Includes index.
Companion CD-ROM contains example files and an electronic version of the book.
Excel in a nutshell -- Basic fact about formulas -- Working with names -- Introducing worksheet functions -- 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 depreciating 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.
There are no comments on this title.