John Walkenbach
Simplify number
crunching and analysis
Create boardroom quality
charts and diagrams
Analyze mounds of
data with pivot tables
Walkenbach
The book you need to succeed!
The perennial bestseller—now fully
updated for Excel 2007!
Whether you’re already a power user or just starting, find
out how to get the most out of this major new release
of Excel from expert instructor and Microsoft MVP,
“Mr. Spreadsheet,” John Walkenbach. Each of the book’s
seven parts thoroughly focuses on key elements, so no
matter what your level of expertise, you’ll find what
you need in the hundreds of examples, techniques, and
tips in this comprehensive resource.
• Master Excel’s new “menu-less” Ribbon user interface
• Understand formulas, functions, tables, worksheets, and workbooks
• Explore the new unlimited conditional formatting
• Develop custom functions, program with VBA, and create UserForms
• Analyze data using external database files and pivot tables
• Enhance your worksheets with new SmartArt tools
• Customize the Quick Access Toolbar and save time
CD-ROM Included!
• All examples and workbooks from the book
• Searchable PDF of the book
Value-Packed CD-ROM
“ John Walkenbach provides excellent examples in this book…that Excel users will find very useful.”
— David McRitchie, Microsoft MVP
Meet John
Walkenbach
John Walkenbach, a.k.a “Mr.
Spreadsheet,” is a principal of
J-Walk and Associates, Inc. and
a Microsoft Excel MVP. He is a
leading authority on spreadsheet
software and creator of the award-
winning Power Utility Pak. He has
written more than 50 books,
including Excel 2003 Formulas and
Excel 2003 Power Programming
with VBA, as well as articles and
reviews for publications including
PC World, InfoWorld, and
Windows. He also maintains the
popular Spreadsheet Page at
www.j-walk.com/ss.
Shelving Category:
COMPUTERS/Spreadsheets
Reader Level:
Beginning to Advanced
$39.99 USA
$47.99 Canada
£25.99 UK
ISBN 0-470-04403-9
Easily create summary
reports of your data with the
enhanced PivotTa