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 file.

Excel 2007 Charts

Computers & Technology

Walkenbach, John

Software

wiley

<ul>
<li>This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere</li> <li>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</li> <li>John Walkenbach, aka "Mr. Spreadsheet," is one of the world’s leading authorities on Excel</li> <li>Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features</li> <li>Includes a valuable CD-ROM with templates and worksheets from the book</li> </ul>
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Excel 2007 Power Programming with VBA

Programming

Excel 2007 Formulas

<ul>
<li>This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere</li> <li>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</li> <li>John Walkenbach, aka "Mr. Spreadsheet," is one of the liworld’s leading authorities on Excel</li> <li>Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features</li> <li>Includes a valuable CD-ROM with templates and worksheets from the book</li> </ul>
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Excel 2007 Bible

John Wiley&Sons, Inc.

Fast answers to frequently asked questions Excel 2007 essentials at your fingertips! If you like your answers quick and your information up-to-date, look no further. With this concise, superbly organized reference, you'll quickly find just what you need to know about navigating the new interface; using the Ribbon and Quick Access toolbar; saving, protecting, and recovering workbook files; entering and editing data; creating formulas and functions, and much more.

Excel 2007 For Dummies Quick Reference

Banfield, Colin

For Dummies

Step-by-step instructions for creating VBA macros Harness the power of VBA and create custom Excel applications Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more. Discover how to <ul>
<li>Grasp essential programming concepts</li> <li>Use the Visual Basic Editor</li> <li>Navigate the new Excel user interface</li> <li>Communicate with your users</li> <li>Deal with errors and bugs</li> </ul>

Excel 2007 VBA Programming For Dummies

Completely revised for Office 2007, this “best of the Bible” presents Office you with the most useful content from leading experts like John Walkenbach, Cary Prague, Faithe Wempen, and Herb Tyson. The book features valuable information to help you—no matter your level of expertise—get up to speed on the new features in Excel, Access, Outlook, Word, and PowerPoint. You’ll quickly get savvy with the most widely used business application suite worldwide.

Office 2007 Bible

Aitken, Peter G.

Wempen, Faithe

Bucki, Lisa A.

Prague, Cary N.

Irwin, Michael R.

Powell, Gavin

Tyson, Herb

Groh, Michael R.

John Walkenbach comments on the new Excel: "I've been using Excel for over 15 years, and Excel 2007 is by far the most significant upgrade ever. For starters, we've got a new user interface, new open file formats, a larger worksheet grid, better use of memory and CPUs, new functions, and more templates. Dig a bit deeper and you'll find worksheet tables, 100 levels of undo, easier formula construction, better-looking charts, unlimited color choices, SmartArt, a handy page layout view, new conditional formatting options, new collaboration features, a very useful compatibility checker, workbook themes—and even 'skins' so you can change the look of the entire program." 
John Walkenbach's Favorite Excel 2007 Tips &amp; Tricks consists of a series of non-trivial tips and tricks that cover all aspects of Excel. Tips are improved ways of maximizing the power of Excel to create robust applications. Tricks are shortcuts that will speed up application development with Excel. John's favorites include tips and tricks on dealing with function arguments, creating "impossible" charts, pivot tables, taming the new Ribbon, why use a UserForm, how to create add-ins in Excel 2007, absolute vs. relative references, changing data entry orientation, overcoming the 7-level nesting limit, dynamic chart data, sorting on more than three columns, entering fake data for testing purposes, custom functions, and much more.

John Walkenbach's Favorite Excel 2007 Tips and Tricks

Packed with examples, techniques, and tips from Microsoft MVP John Walkenbach, this perennial bestseller has been updated for Excel 2007 and is equally valuable for beginners and power users. You'll learn how to master Excel's new "menuless" Ribbon interface, develop custom functions, create UserForms, analyze data with external database files and PivotTables, and much more. Here's valuable comprehensive coverage of the fundamentals as well as advanced 2007 features like the new user interface and wider use of XML and Web services.

Office 2007 Library: Excel 2007 Bible, Access 2007 Bible, PowerPoint 2007 Bible, Word 2007 Bible

Stockman, Joseph C.

Reardon, Jennifer

The perennial bestseller, updated for Excel 2007 Equally valuable for beginners and power users, this book is packed with examples, techniques, and tips from Mr. Spreadsheet. Here's how to: * Understand formulas, functions, tables, worksheets, and workbooks * Explore unlimited conditional formatting * Develop custom functions and create UserForms * Analyze data with external database files and pivot tables * Enhance worksheets with SmartArt tools * Customize the Quick Access Toolbar to save time Create killer formulas that let you do more If you know Excel basics, Mr. Spreadsheet can help you create financial formulas, develop custom worksheet functions, and greatly extend Excel's capabilities. You can: * Release the power of array formulas * Master operators, error values, and absolute vs. relative references * Find errors and debug your formulas * Eliminate formulas by using pivot tables * Create single- and multi-cell array formulas * Use VBA to build custom functions Expand Excel with VBA, and feel the power This power-user's guide is packed with procedures, tips, and ideas for expanding Excel with Visual Basic for Applications. Mr. Spreadsheet helps you: * Create powerful Excel applications * Enhance Excel with VBA macros * Expand Excel's shortcut menus * Customize UserForms and develop new utilities * Write event-driven code * Build user-friendly toolbars, menus, and help systems Get acquainted with Excel 2007's all-new features There's a new user interface, new open file formats, a larger worksheet grid, better use of memory, new functions and templates, and more. Learn to: * Manage the Ribbon * Deal with function arguments * Change data entry orientation * Create a drop-down list in a cell * Convert a vertical range to a table * Change the look of the entire program Nobody knows Excel like Mr. Spreadsheet! Excel 2007 Bible Excel 2007 Formulas Excel 2007 Power Programming with VBA John Walkenbach's Favorite Excel 2007 Tips &amp; Tricks Bonus CD-ROM Award-winning Power Utility Pak on CD-ROM! Mr. Spreadsheet's Excel 2007 Library also includes a full, licensed version of John Walkenbach's famous Power Utility Pak, updated for Excel 2007 and valued at $40 US. It's a valuable collection of add-ins, providing additional functionality that will make your life with Excel easier!

Mr. Spreadsheet's Excel 2007 Library

See the best price to sell, buy, or rent books by Walkenbach, John. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Walkenbach, John