Excel 2010 formulas
By: by John Walkenbach
Series: Mr. Spreadsheet's bookshelf
Publisher: Wiley Pub.
Published: 2010
Place of publication: Hoboken, NJ
Language: eng
Number of pages: 788
ISBN-13: 9780470475362
Subjects: Microsoft Excel (Computer file); Electronic spreadsheets; Business; Computer programs
Other titles: Microsoft Excel 2010 formulas
Description: 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.
Notes: Includes index.
Table of contents: title: Excel in a nutshell; title: Basic facts about formulas; title: Working with names; title: Introducing worksheet function; title: Manipulating text; title: Working with dates and times; title: Counting and summing techniques; title: Using lookup functions; title: Tables and worksheet databases; title: Miscellaneous calculations; title: Borrowing and investing formulas; title: Discounting and depreciation formulas; title: Financial schedules; title: Introducing arrays; title: Performing magic with array formulas; title: Intentional circular references; title: Charting techniques; title: Pivot tables; title: Conditional formatting and data validation; title: Creating megaformulas; title: Tools and methods for debugging formulas; title: Introducing VBA; title: Function procedure basics; title: VBA programming concepts; title: VBA custom function examples.