Excel 2010 formulas /
Walkenbach, John.
Excel 2010 formulas / Microsoft Excel 2010 formulas by John Walkenbach. - New Delhi : Wiley India Pvt. Ltd., 2011. - xxiii, 788 p. : ill. ; 23 cm. 1 CD-ROM (4 3/4 in.). - Mr. Spreadsheet's bookshelf . - Mr. Spreadsheet's bookshelf. .
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.
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.
9780470475362 (pbk.) 9788126529407
2010925706
Microsoft Excel (Computer file)
Business--Computer programs.
Electronic spreadsheets.
HF5548.4.M523 / W344858 2010
005.54 WAL/Exc
Excel 2010 formulas / Microsoft Excel 2010 formulas by John Walkenbach. - New Delhi : Wiley India Pvt. Ltd., 2011. - xxiii, 788 p. : ill. ; 23 cm. 1 CD-ROM (4 3/4 in.). - Mr. Spreadsheet's bookshelf . - Mr. Spreadsheet's bookshelf. .
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.
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.
9780470475362 (pbk.) 9788126529407
2010925706
Microsoft Excel (Computer file)
Business--Computer programs.
Electronic spreadsheets.
HF5548.4.M523 / W344858 2010
005.54 WAL/Exc