Normal view MARC view ISBD view

Walkenbach, John.

Excel 2010 formulas / Microsoft Excel 2010 formulas by John Walkenbach. - Hoboken, NJ : Wiley Pub., �2010. - 1 online resource (xxiii, 788 pages) : illustrations - Mr. Spreadsheet's bookshelf . - Mr. Spreadsheet's bookshelf. .

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.

ISBN: 9780470625514 0470625511 9780470625538 0470625538 9781118257630 1118257634 9781621984283 1621984281

Standard No.: 10.1002/9781118257630 doi

Source: 98595199-1CBB-4B20-8AB7-F2DF77C9C0B5 OverDrive, Inc. http://www.overdrive.com

Subjects--Uniform Titles:
Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Microsoft Excel (Computer software)

Subjects--Topical Terms:
Business--Computer programs.
Electronic spreadsheets.
Tableurs.
COMPUTERS--Desktop Applications--Spreadsheets.
Business--Computer programs
Electronic spreadsheets
Excel.
Business--Computer software.
Spreadsheet software.

LC Class. No.: HF5548.4.M523 / W34489 2010eb

Dewey Class. No.: 005.54

Gov. Doc. Class. No.: ACC1023