Excel 2007 formulas / John Walkenbach.
By: Walkenbach, John
.
Material type: 
TextSeries: Mr Spreadsheet's bookshelf. Publisher: Indianapolis, IN : Wiley, 2007General Notes: Includes index; Companion CD-ROM contains example files and an electronic version of the book.Description: xxxii, 804 p. : ill. ; 24 cm. + 1 CD-ROM (4 3/4 in.).ISBN: 9780470044025 (pbk.); 0470044020 (pbk.).Subject(s): Microsoft Excel (Computer file) | Microsoft Excel (Computer file) | Electronic spreadsheetsDDC classification: 005.54 | 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.