Author: John Walkenbach
Publisher: For Dummies
Keywords: dummies, computer, tech, programming, vba, excel
Number of Pages: 408
Published: 2004-08-20
List price: $24.99
ISBN-10: 0764574124
ISBN-13: 9780764574122

* Shows ordinary users how to harness the power of Visual Basic for Applications (VBA) and create custom Excel applications * This book introduces people to a wide array of new Excel options, including creating new worksheet functions, automating tasks and operations, creating new toolbars and menus, designing custom dialog boxes and add-ins, and much more * Begins with the most important tools and operations for the Visual Basic Editor, then provides an overview of the essential elements and concepts for programming with Excel * John Walkenbach, a.k.a. "Mr. Spreadsheet," runs a popular Web si

Author: John Walkenbach
Publisher: Wiley
Keywords: bible, excel
Number of Pages: 936
Published: 2003-09-19
List price: $39.99
ISBN-10: 0764539671
ISBN-13: 9780764539671

* The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features * Written by the leading Excel guru known as "Mr. * The definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and more * Covers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting information * Explores Excel programming for those who want advanced information * CD-ROM includes all templates and worksheets

Author: John Walkenbach
Publisher: For Dummies
Keywords: formulas, excel
Number of Pages: 864
Published: 2003-10-17
List price: $44.99
ISBN-10: 0764540734
ISBN-13: 9780764540738

Everything you need to know about Mastering operators, error values, naming techniques, and absolute versus relative references Debugging formulas and using the auditing tools Importing and exporting XML files and mapping the data to specific cells Using Excel 2003’s rights management feature Working magic with array formulas Developing custom formulas to produce the results you need Here’s the formula for Excel excellence Formulas are the lifeblood of spreadsheets, and no one can bring a spreadsheet to life like John Walkenbach. In thi

Author: John Walkenbach
Publisher: Wiley
Keywords: bookshelf, spreadsheet, formulas, excel
Number of Pages: 840
Published: 2007-02-12
List price: $44.99
ISBN-10: 0470044020
ISBN-13: 9780470044025

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 fe

Author: John Walkenbach
Publisher: Wiley
Keywords: bible, excel
Number of Pages: 866
Published: 2007-01-03
List price: $39.99
ISBN-10: 0470044039
ISBN-13: 9780470044032

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 liworld’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

Author: John Walkenbach
Publisher: Wiley
Keywords: spreadsheet, bookshelf, vba, programming, power, excel
Number of Pages: 1104
Published: 2007-04-16
List price: $49.99
ISBN-10: 0470044012
ISBN-13: 9780470044018

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 fe

Author: John Walkenbach
Publisher: Wiley
Keywords: bookshelf, spreadsheet, charts, excel
Number of Pages: 555
Published: 2007-10-01
List price: $44.99
ISBN-10: 0470044004
ISBN-13: 9780470044001

Excel, the top number-crunching tool, now offers a vastly improved charting function to help you give those numbers dimension and relativity. John Walkenbach, a.k.a. Mr. Spreadsheet, clearly explains all these charting features and shows you how to choose the right chart for your needs. You’ll learn to modify data within the chart, deal with missing data, format your chart, use trend lines, construct “impossible” charts, create charts from pivot tables, dress them up with graphics, and more. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook fi