|
|
All the methods and tools you need to successfully program with Excel John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.* Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA)* Features invaluable advice from "Mr. Spreadsheet" himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applications* Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won't find anywhere else* Includes a CD with templates and worksheets from the book This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
| ISBN | 0470475358 | | Pages | 1080 | | ISBN13 | 9780470475355
(What's this?) | | Weight (grammes) | 1592 | | Publisher | John Wiley and Sons Ltd | | Published in | Chichester | | Imprint | John Wiley & Sons Ltd | | Series title | Mr. Spreadsheet's Bookshelf | | Format | Paperback | | Height (mm) | 233 | | Publication date | 11 May 2010 | | Width (mm) | 188 | | DEWEY | 005.54 | | Spine width (mm) | 58 | | DEWEY edition | DC22 | | Academic level | General |
|
| |
| | | Introduction | | 1 | | Part I | | Some Essential Background | | | | Chapter 1 | | Excel 2010: Where It Came From | | 11 | | | | A Brief History of Spreadsheets | | 11 | | | | It all started with VisiCalc | | 11 | | | | Lotus 1-2-3 | | 12 | | | | Quattro Pro | | 14 | | | | Microsoft Excel | | 15 | | | | Current Competition | | 20 | | | | Why Excel Is Great for Developers | | 20 | | | | Excel's Role in Microsoft's Strategy | | 22 | | Chapter 2 | | Excel in a Nutshell | | 23 | | | | Thinking in Terms of Objects | | 23 | | | | Workbooks | | 24 | | | | Worksheets | | 24 | | | | Chart sheets | | 26 | | | | XLM macro sheets | | 26 | | | | Excel 5/95 dialog sheets | | 28 | | | | Excel's User Interface | | 28 | | | | About the Ribbon | | 28 | | | | Shortcut menus and the Mini Toolbar | | 34 | | | | Dialog boxes | | 35 | | | | Keyboard shortcuts | | 36 | | | | Smart Tags | | 36 | | | | Task pane | | 36 | | | | Customizing the Display | | 37 | | | | Data Entry | | 38 | | | | Formulas, Functions, and Names | | 38 | | | | Selecting Objects | | 40 | | | | Formatting | | 40 | | | | Protection Options | | 42 | | | More... | | |
|
|
|
|
|
Enlarge
