Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 140 key Excel programming techniques, including:

-Assigning digital signatures to macros
-Setting properties for a project
-Assigning values to a variable   
-Changing the properties of an object
-Formatting a numeric expression   
-Processing a runtime error
-Saving worksheets to another file
-Displaying a built-in dialog box
-Creating custom Ribbon tabs
-Building and debugging add-ins

You already know Excel 2007. Now you'd like to go beyond with shortcuts, tricks, and tips that let you work smarter and faster. And because you learn more easily when someone shows you how, this is the book for you. Inside, you'll find clear, illustrated instructions for 100 tasks that reveal cool secrets, teach timesaving tricks, and explain great tips guaranteedto make you more productive with Excel 2007.
1. Minimal text and maximum illustrations
2. Task-oriented, step-by-step approach
3. Navigational aids connect instructions to illustrations
4. Self-contained, two-page lessons
5. Uniform layout makes it easy to read less, learn more

Take your Microsoft Office experience to the next level by programming custom business solutions with Excel 2003. This supremely organized reference and tutorial packs hundreds of timesaving answers, tips, and workarounds for advanced Excel users.

From writing code in Microsoft Visual Basic for Applications (VBA) to taking advantage of new XML data-sharing features, this book packs hundreds of timesaving programming solutions, troubleshooting tips, and handy workarounds all in concise, fast-answer format.

Discover the best and fastest ways to build custom business solutions with Excel—and challenge yourself to new levels of mastery!

* Essential for those who know basic Excel and want to explore the full potential of the program * Teaches how to manipulate data to suit specific needs and achieve more by doing less work
* Self-contained two-page lessons, featuring high-resolution screen shots and minimal text, show how to create custom functions, retrieve data from databases, use value chains, and slice and pivot information from the Web with Excel's PivotTable utility
* Covers data analyzing techniques for statistical functions, financial functions, data sharing, PivotTables and PivotCharts, Solver, and BackSolve

This book is intended for spreadsheet users who want to get the most out of Excel’s charting and graphics features. I approached this project with one goal in mind: to write the ultimate Excel charting book that would appeal to users of all levels.

This is not a book for beginning Excel users. If you have absolutely no experience with Excel, this may not be the best book for you. To get the most out of this book, you should have some background using Excel.

To make the best use of this book, you need a copy of Microsoft Excel. When I wrote the current edition of the book, I was using Excel 2002 (which is part of Microsoft Office XP). Most of the material in this book also applies to all earlier versions of Excel that are still in use. Fact is, Microsoft has made very few significant changes to Excel’s charting features over the years. Where applicable, I point out differences in previous versions.