/LC.GIF&client=easterncarolinaedu)
Excel 2010 formulas / by John Walkenbach.
| Author/creator | Walkenbach, John |
| Format | Electronic |
| Publication Info | Hoboken, NJ : Wiley Pub., |
| Description | xxiii, 788 p. : ill. ; 24 cm. + 1 CD-ROM (4 3/4 in.). |
| Supplemental Content | Full text available from Ebook Central - Public Library Complete |
| Supplemental Content | Full text available from Ebook Central - Academic Complete |
| Subjects |
| Cover title | Microsoft Excel 2010 formulas |
| Series | Mr. Spreadsheet's bookshelf Mr. Spreadsheet's bookshelf. ^A1302504 |
| Contents | 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. |
| Abstract | 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. |
| General note | Includes index. |
| Access restriction | Available only to authorized users. |
| Technical details | Mode of access: World Wide Web |
| Genre/form | Electronic books. |
| LCCN | 2010925706 |
| ISBN | 9780470475362 (pbk.) |
| ISBN | 0470475366 (pbk.) |
Availability
| Library | Location | Call Number | Status | Item Actions |
|---|---|---|---|---|
| Electronic Resources | ✔ Available |