UID:
edocfu_9959327585502883
Format:
1 online resource (xxiii, 788 pages) :
,
illustrations
ISBN:
9780470625514
,
0470625511
,
9780470625538
,
0470625538
,
9781118257630
,
1118257634
,
9781621984283
,
1621984281
Series Statement:
Mr. Spreadsheet's bookshelf
Content:
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.
Note:
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.
Additional Edition:
Print version: Walkenbach, John. Excel 2010 formulas. Hoboken, NJ : Wiley Pub., ©2010 ISBN 9780470475362
Language:
English
Keywords:
Electronic books.
DOI:
10.1002/9781118257630
URL:
https://onlinelibrary.wiley.com/doi/book/10.1002/9781118257630
Bookmarklink
