|
|
John Walkenbach
ISBN: 9780470044025
Format: Paperback
Publisher:John Wiley and Sons Ltd
Also available as an eBook
Write a review
Create killer formulas--Mr. Spreadsheet shows you how Excel master John Walkenbach has shared his expertise in two previous editions of this bestseller. Now he shows you how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and more with Excel 2007.
* This book is a single reference that's indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere* Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won't find anywhere else* John Walkenbach, aka "Mr. Spreadsheet," is one of the world's leading authorities on Excel* Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features* Includes a valuable CD-ROM with templates and worksheets from the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
| ISBN | 0470044020 | | Volumes | 1 | | ISBN13 | 9780470044025
(What's this?) | | Weight (grammes) | 1265 | | Publisher | John Wiley and Sons Ltd | | Published in | Chichester | | Imprint | John Wiley & Sons Ltd | | Series ISSN | 3 | | Format | Paperback | | Series title | Mr. Spreadsheet's Bookshelf | | Publication date | 08 Feb 2007 | | Height (mm) | 234 | | Library of Congress | HF | | Width (mm) | 187 | | DEWEY | 005.54 | | Spine width (mm) | 46 | | DEWEY edition | DC22 | | Academic level | Professional / Scholarly | | Pages | 840 | |
|
| |
| Ch. 1 | | Excel in a nutshell | | 3 | | Ch. 2 | | Basic facts about formulas | | 33 | | Ch. 3 | | Working with names | | 59 | | Ch. 4 | | Introducing worksheet functions | | 99 | | Ch. 5 | | Manipulating text | | 115 | | Ch. 6 | | Working with dates and times | | 139 | | Ch. 7 | | Counting and summing techniques | | 177 | | Ch. 8 | | Using lookup functions | | 211 | | Ch. 9 | | Tables and worksheet databases | | 233 | | Ch. 10 | | Miscellaneous calculations | | 277 | | Ch. 11 | | Borrowing and investing formulas | | 295 | | Ch. 12 | | Discounting and depreciation formulas | | 321 | | Ch. 13 | | Financial schedules | | 347 | | Ch. 14 | | Introducing arrays | | 375 | | Ch. 15 | | Performing magic with array formulas | | 399 | | Ch. 16 | | Intentional circular references | | 429 | | Ch. 17 | | Charting techniques | | 443 | | Ch. 18 | | Pivot tables | | 485 | | Ch. 19 | | Conditional formatting and data validation | | 527 | | Ch. 20 | | Creating megaformulas | | 563 | | Ch. 21 | | Tools and methods for debugging formulas | | 581 | | Ch. 22 | | Introducing VBA | | 607 | | Ch. 23 | | Function procedure basics | | 623 | | Ch. 24 | | VBA programming concepts | | 645 | | Ch. 25 | | VBA custom function examples | | 679 |
|
|
|
|
|
Enlarge
