John Walkenbach's Favorite Excel Tips & Tricks

John Walkenbach's Favorite Excel Tips & Tricks
by John Walkenbach

John Walkenbach's Favorite Excel Tips & Tricks
List Price: $39.99
Our Price: $24.66
You Save: $15.33 (38%)
Availability: Usually ships in 1-2 business days
Buy Used: from $5.74 (click here)
Category: Book
See more book details and other editions


(Click here)
Buy this book at online book store in your country
Canada | UK | Germany | France

Book Summary Information

Author: John Walkenbach
Edition: Paperback
Audio: English (Unknown); English (Original Language); English (Published)
Published: 2005-07-08
ISBN: 0764598163
Number of pages: 552
Publisher: Wiley
Product features:
  • ISBN13: 9780764598166
  • Condition: New
  • Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!

Book Reviews of John Walkenbach's Favorite Excel Tips & Tricks

Book Review: A Lot of Interesting Little Points Given Here
Summary: 5 Stars

There are only a few reasons to get a copy of John Walkenbach's books: One, he knows what he is talking about. His books show an insight far beyond the traditional click here to do this approach. Two, he writes far better than any other Excel writer that I have ever seen. Three, he gives you his e-mail address. He invites comments or suggestions about the book and says that he unfortunately cannot answer specific questions. But on the couple of occassions where I've had questions, I asked and he answered. They were, I think, pretty good questions, it well may be that he can't take the time to answer the simple obvious questions where the answers are in his book.

As the title implies, this book consists of a couple of hundred quick little things that mostly fall into the "I could have done that if I'd only thought that this was what I wanted to do" type. This includes things like wrapping text in a cell.

Some of the other points, like why does Excell take a credit card number and make the last digit a zero, fall into the obvious once you see the explanation.

This is not for the absolute beginner, you need to have some experience with Excell before you realize that you need the information that is here. For the advanced beginner to intermediate or even advanced user, the tips and tricks here will save you time and effort.

Summary of John Walkenbach's Favorite Excel Tips & Tricks

  • This unique book offers valuable tips and tricks to maximize the capabilities of Excel, the indispensable and immensely popular spreadsheet application
  • An ideal resource for advancing beginners and intermediate-level users, this book offers shortcuts that are sure to speed up application development with Excel and take readers' skills to the next level
  • Some of the author's favorite tips and tricks include dealing with function arguments, creating "impossible" charts, tweaking Pivot Tables, copying print settings across sheets, taming "automatic" toolbars, and using a UserForm
  • Additional tips and tricks show how to create dynamic chart data, use Analysis Toolpak, sort on more than three columns, attach toolbars to worksheets, enter fake data for testing purposes, apply custom functions, and much more

Software Books

Book Subjects
Most talked about in Software Books
Unix Unbounded: A Beginning Approach ImageUnix Unbounded: A Beginning Approach
by Amir Afzal
Prentice Hall; Published: 1997-07-08; Paperback; Book
Best price: $10.00
Price in other shops: $75.00
Just Java (Java Series (Mountain View, Calif.).) ImageJust Java (Java Series (Mountain View, Calif.).)
by Peter Van Der Linden, Peter Van Der Linden
Prentice Hall Ptr; Published: 1996-03; Paperback; Book
Best price: $3.15
Price in other shops: $34.95
Windows NT Device Driver Book, The: A Guide for Programmers ImageWindows NT Device Driver Book, The: A Guide for Programmers
by Art Baker
Prentice Hall Ptr; Published: 1996-12-20; Paperback; Book
Best price: $19.76
Price in other shops: $44.95
Outside-in Software Development: A Practical Approach to Building Successful Stakeholder-based Products, 1/e ImageOutside-in Software Development: A Practical Approach to Building Successful Stakeholder-based Products, 1/ e
by Carl Kessler, John Sweitzer
IBM Press; Published: 2007-10-04; Paperback; Book
Best price: $22.75
Price in other shops: $44.99
Oracle Database 10g DBA Handbook ImageOracle Database 10g DBA Handbook
by Kevin Loney, Bob Bryla
McGraw-Hill Osborne Media; Published: 2005-03-24; Paperback; Book
Best price: $32.64
Price in other shops: $66.00
Java: The Complete Reference, J2SE 5 Edition ImageJava: The Complete Reference, J2SE 5 Edition
by Herbert Schildt
McGraw-Hill Osborne Media; Published: 2004-12-14; Paperback; Book
Best price: $9.80
Price in other shops: $49.99
Sun Certified Programmer & Developer for Java 2 Study Guide (Exam 310-035 & 310-027) ImageSun Certified Programmer & Developer for Java 2 Study Guide (Exam 310-035 & 310-027)
by Kathy Sierra, Bert Bates
McGraw-Hill Osborne Media; Published: 2002-12-11; Paperback; Book
Best price: $9.50
Price in other shops: $49.99
OCP Oracle9i Database: Fundamentals I Exam Guide ImageOCP Oracle9i Database: Fundamentals I Exam Guide
by Jason Couchman, Sudheer Marisetti
McGraw-Hill Osborne Media; Published: 2002-01-14; Hardcover; Book
Best price: $9.94
Price in other shops: $49.99
Database Management Systems ImageDatabase Management Systems
by Raghu Ramakrishnan
William C Brown Pub; Published: 1997-08-21; Hardcover; Book
Best price: $2.00
Price in other shops: $97.65
Mastering ArcGIS with Video Clips CD-ROM ImageMastering ArcGIS with Video Clips CD-ROM
by Maribeth H. Price, Maribeth Price
McGraw-Hill Science/Engineering/Math; Published: 2003-09-15; Spiral-bound; Book
Best price: $148.44
Similar Books and other products
Microsoft Office Excel 2003: Comprehensive Concepts and Techniques, CourseCard Edition (Shelly Cashman) ImageMicrosoft Office Excel 2003: Comprehensive Concepts and Techniques, CourseCard Edition (Shelly Cashman)
by Gary B. Shelly, Thomas J. Cashman, James S. Quasney
Course Technology; Published: 2005-03-21; Paperback; Book
Best price: $15.16
Price in other shops: $129.95
Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets ImageExcel Hacks: Tips & Tools for Streamlining Your Spreadsheets
by David Hawley, Raina Hawley
O'Reilly Media; Published: 2007-06-27; Paperback; Book
Best price: $12.50
Price in other shops: $29.99
Excel 2007 Bible ImageExcel 2007 Bible
by John Walkenbach
Wiley; Published: 2007-01-03; Paperback; Book
Best price: $20.35
Price in other shops: $39.99
Microsoft® Office Excel® 2003 Step by Step (Step By Step (Microsoft)) ImageMicrosoft® Office Excel® 2003 Step by Step (Step By Step (Microsoft))
by Curtis Frye
Microsoft; Microsoft Press; Published: 2003-09-24; Paperback; Book
Best price: $14.50
Price in other shops: $24.99
Excel 2007 Formulas (Mr. Spreadsheet's Bookshelf) ImageExcel 2007 Formulas (Mr. Spreadsheet's Bookshelf)
by John Walkenbach
Wiley; Published: 2007-02-12; Paperback; Book
Best price: $24.34
Price in other shops: $44.99
Excel 2003 Power Programming with VBA (Book & CD-ROM) ImageExcel 2003 Power Programming with VBA (Book & CD-ROM)
by John Walkenbach
Wiley; Published: 2004-01-13; Paperback; Book
Best price: $22.07
Price in other shops: $49.99
Excel PivotTables and Charts (Mr Spreadsheet) ImageExcel PivotTables and Charts (Mr Spreadsheet)
by Peter G. Aitken
Wiley; Published: 2006-01-11; Paperback; Book
Best price: $6.22
Price in other shops: $34.99
Excel Charts ImageExcel Charts
by John Walkenbach
Wiley; Published: 2002-11-05; Paperback; Book
Best price: $13.95
Price in other shops: $44.99
Excel 2003 Formulas ImageExcel 2003 Formulas
by John Walkenbach
For Dummies; Published: 2003-10-17; Paperback; Book
Best price: $8.85
Price in other shops: $44.99
Excel 2003 Bible ImageExcel 2003 Bible
by John Walkenbach
Wiley; Published: 2003-09-19; Paperback; Book
Best price: $14.00
Price in other shops: $39.99
Book store. Illustrated catalog of books on different categories