Excel 2007 formulas / John Walkenbach.
Material type:
TextSeries: Mr Spreadsheet's bookshelf: Publisher: Indianapolis, IN : Wiley Pub., 2007Description: xxxii, 804 p. : ill. ; 24 cm. + 1 CD-ROM (4 3/4 in.)ISBN: 9780470044025 (pbk.); 0470044020 (pbk.)Subject(s): Microsoft Excel (Computer file) | Electronic spreadsheetsDDC classification: 005.54 LOC classification: HF5548.4.M523 | W334 2007| Item type | Current library | Call number | Copy number | Status | Notes | Date due | Barcode |
|---|---|---|---|---|---|---|---|
Books
|
Female Library | HF5548.4 .M523 W334 2007 (Browse shelf (Opens below)) | 1 | Available | STACKS | 51952000096924 | |
|
Books
|
Main Library | HF5548.4 .M523 W334 2007 (Browse shelf (Opens below)) | 1 | Available | STACKS | 51952000120490 |
Browsing Female Library shelves Close shelf browser
|
|
|
|
|
|
|
||
| HF5548.37 .L393 2007 Information security : design, implementation, measurement, and compliance / | HF5548.4 .M523 H376 2007 Microsoft Office Excel 2007 for dummies / | HF5548.4 .M523 S52 2004 Excel VBA macro programming / | HF5548.4 .M523 W334 2007 Excel 2007 formulas / | HF5548.4 .M525 .M853 2014 Microsoft Office 2013. Vol. 1. / | HF5548.4 .M525 B679 2007 Special edition using Microsoft Office 2007 / | HF5548.4 .M525 F49 2009 Microsoft office for teachers / |
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.
1 2
There are no comments on this title.