TY  - BOOK
AU  - Walkenbach,John
TI  - Excel 2010 formulas
T2  - Mr. Spreadsheet's bookshelf
SN  - 9780470475362 (pbk.)
AV  - HF5548.4.M523 W344858 2010
U1  - 005.54 WAL/Exc 
PY  - 2011///
CY  - New Delhi
PB  - Wiley India Pvt. Ltd.
KW  - Microsoft Excel (Computer file)
KW  - Business
KW  - Computer programs
KW  - Electronic spreadsheets
N1  - Includes index; 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
N2  - A reference collection of formulas for spreadsheet challenges covers operators, nesting, functions, error values, naming, cell formatting, protection options, array formulas, pivot tables, and auditing
ER  -