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.

There are endless tasks that can be made easier with Excel. Excel can be used to track classroom management from grade books, class rosters, attendance, testing results, assessment measurement charts, and more. Excel can be used as an aide in teaching. Use Excel to generate random fact worksheets. Use Excel to create graphs to help teach math standards. Finally, your students can use Excel to develop models and homework.

The concepts in this book apply equally well to every version of Excel from Excel 97 through Excel 2003. As this book goes to press, pre-beta copies of Excel 12 are available. I’ve reviewed these and many concepts will be different in Excel 12. While Excel 12 threatens to make every Excel book obsolete, most public school districts are in financial trouble and will not be upgrading to Excel 12 soon. If you happen to live in a district that upgrades to Excel 12, check the aforementioned web page for information about an e-book upgrade for Excel 12 users.

We will assume that you have Excel 97 or newer running on Windows or Macintosh. You should know how to start Excel and navigate from cell to cell.