Excel 2010 formulas / by John Walkenbach.
Material type:
TextSeries: Mr. Spreadsheet's bookshelfPublication details: New Delhi : Wiley India Pvt. Ltd., 2011.Description: xxiii, 788 p. : ill. ; 23 cm. 1 CD-ROM (4 3/4 in.)ISBN: - 9780470475362 (pbk.)
- 9788126529407
- Microsoft Excel 2010 formulas [Cover title]
- 005.54 WAL/Exc
- HF5548.4.M523 W344858 2010
| Item type | Current library | Call number | Status | Date due | Barcode | |
|---|---|---|---|---|---|---|
Books
|
Goa University Library General Stacks | 005.54 WAL/Exc (Browse shelf(Opens below)) | Available | 141624 |
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.
There are no comments on this title.