Walkenbach, John. <br/><br/>
Excel 2007 formulas / 
John Walkenbach. 
 - Indianapolis, IN  :  Wiley Pub.,  2007. 
 - xxxii, 804 p. :  ill. ;  24 cm. +  1 CD-ROM (4 3/4 in.) 
 - Mr Spreadsheet's bookshelf .
 - Mr Spreadsheet's bookshelf. .
<br/><br/> Includes index.  Companion CD-ROM contains example files and an electronic version of the book. 
<br/><br/>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. 
<br/><br/><label>ISBN: </label>9780470044025 (pbk.) 0470044020 (pbk.) 
<br/><br/><label>LCCN: </label>2007920006 
<br/><br/><label>Subjects--Uniform Titles: </label><br/>Microsoft Excel (Computer file)
<br/><br/><label>Subjects--Topical Terms: </label><br/>Electronic spreadsheets.
<br/><br/><label>LC Class. No.: </label>HF5548.4.M523  / W334 2007 
<br/><br/><label>Dewey Class. No.: </label>005.54