TY  - BOOK
AU  - Walkenbach,John
TI  - Excel 2010 formulas
T2  - Mr. Spreadsheet's bookshelf
SN  - 9780470625514
AV  - HF5548.4.M523 W34489 2010eb
U1  - 005.54 22
PY  - 2010///
CY  - Hoboken, NJ
PB  - Wiley Pub.
KW  - Microsoft Excel (Computer file)
KW  - fast
KW  - Microsoft Excel (Computer software)
KW  - sears
KW  - Business
KW  - Computer programs
KW  - Electronic spreadsheets
KW  - Tableurs
KW  - COMPUTERS
KW  - Desktop Applications
KW  - Spreadsheets
KW  - bisacsh
KW  - Excel
KW  - sao
KW  - Computer software
KW  - Spreadsheet software
N1  - 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
UR  - https://onlinelibrary.wiley.com/doi/book/10.1002/9781118257630
ER  -