Excel 2010 formulas / by John Walkenbach.
Series: Mr. Spreadsheet's bookshelfPublication details: Hoboken, NJ : Wiley Pub., ©2010.Description: 1 online resource (xxiii, 788 pages) : illustrationsContent type:- text
- computer
- online resource
- 9780470625514
- 0470625511
- 9780470625538
- 0470625538
- 9781118257630
- 1118257634
- 9781621984283
- 1621984281
- Microsoft Excel 2010 formulas [Cover title]
- Microsoft Excel (Computer file)
- Microsoft Excel (Computer file)
- Microsoft Excel (Computer software)
- Business -- Computer programs
- Electronic spreadsheets
- Business -- Computer programs
- Electronic spreadsheets
- Microsoft Excel (Computer file)
- COMPUTERS -- Desktop Applications -- Spreadsheets
- Business -- Computer programs
- Electronic spreadsheets
- Business -- Computer software
- Spreadsheet software
- Excel
- 005.54 22
- HF5548.4.M523 W34489 2010eb
| Item type | Current library | Home library | Call number | Materials specified | Copy number | Status | Date due | Barcode | |
|---|---|---|---|---|---|---|---|---|---|
| AM | PERPUSTAKAAN TUN SERI LANANG | PERPUSTAKAAN TUN SERI LANANG KOLEKSI AM-P. TUN SERI LANANG (ARAS 5) | ebook (Browse shelf(Opens below)) | 1 | Available |
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.
Print version record.
There are no comments on this title.