|
|
* 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 | 0470044012 | | Volumes | 1 | | ISBN13 | 9780470044018 (What's this?) | | Weight (grammes) | 1442 | | Publisher | John Wiley and Sons Ltd | | Published in | Chichester | | Imprint | John Wiley & Sons Ltd | | Series ISSN | 2 | | Format | Paperback | | Series title | Mr. Spreadsheet's Bookshelf | | Publication date | 17 Apr 2007 | | Height (mm) | 231 | | Library of Congress | HF | | Width (mm) | 186 | | DEWEY | 005.54 | | Spine width (mm) | 53 | | DEWEY edition | DC22 | | Academic level | Professional / Scholarly | | Pages | 1104 | |
|
| |
| Ch. 1 | | Excel 2007 : where it came from | | 3 | | Ch. 2 | | Excel in a nutshell | | 15 | | Ch. 3 | | Formula tricks and techniques | | 47 | | Ch. 4 | | Understanding Excel's files | | 73 | | Ch. 5 | | What is a spreadsheet application? | | 97 | | Ch. 6 | | Essentials of spreadsheet application development | | 109 | | Ch. 7 | | Introducing Visual Basic for applications | | 133 | | Ch. 8 | | VBA programming fundamentals | | 189 | | Ch. 9 | | Working with VBA sub procedures | | 237 | | Ch. 10 | | Creating function procedures | | 275 | | Ch. 11 | | VBA programming examples and techniques | | 315 | | Ch. 12 | | Custom dialog box alternatives | | 389 | | Ch. 13 | | Introducing UserForms | | 413 | | Ch. 14 | | UserForm examples | | 449 | | Ch. 15 | | Advanced UserForm techniques | | 487 | | Ch. 16 | | Developing Excel utilities with VBA | | 533 | | Ch. 17 | | Working with pivot tables | | 555 | | Ch. 18 | | Working with charts | | 571 | | Ch. 19 | | Understanding Excel's events | | 629 | | Ch. 20 | | Interacting with other applications | | 669 | | Ch. 21 | | Creating and using add-ins | | 699 | | Ch. 22 | | Working with the ribbon | | 727 | | Ch. 23 | | Working with shortcut menus | | 761 | | Ch. 24 | | Providing help for your applications | | 781 | | Ch. 25 | | Developing user-oriented applications | | 801 | | Ch. 26 | | Compatibility issues | | 817 | | | More... | | |
|
|
|
|
|