CDN$ 35.55
  • List Price: CDN$ 41.91
  • You Save: CDN$ 6.36 (15%)
Temporarily out of stock.
Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we ship the item.
Ships from and sold by Gift-wrap available.
Excel Hacks: Tips & Tools... has been added to your Cart
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 3 images

Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets Paperback – Jun 30 2007

See all 2 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
"Please retry"
CDN$ 35.55
CDN$ 26.23 CDN$ 16.47

Save an Additional 10% on Textbooks When you Join Amazon Student

Special Offers and Product Promotions

  • Amazon Student members save an additional 10% on Textbooks with promo code TEXTBOOK10. Enter code TEXTBOOK10 at checkout. Here's how (restrictions apply)

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your e-mail address or mobile phone number.

Product Details

  • Paperback: 412 pages
  • Publisher: O'Reilly Media; Second Edition edition (June 30 2007)
  • Language: English
  • ISBN-10: 0596528345
  • ISBN-13: 978-0596528348
  • Product Dimensions: 15.2 x 2.6 x 22.9 cm
  • Shipping Weight: 522 g
  • Average Customer Review: Be the first to review this item
  • Amazon Bestsellers Rank: #460,843 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

  • See Complete Table of Contents

Product Description

About the Author

David Hawley of Perth, Australia is a professional Microsoft Excel consultant whose company, OzGrid Business Applications, offers services in all aspects of Excel, and VBA for Excel. The company's web site at provides online and email Excel training, a directory of useful Excel add-ins, a user forum, and lots of tips and tricks.

Raina Hawley of Perth, Australia is a professional Microsoft Excel consultant whose company, OzGrid Business Applications, offers services in all aspects of Excel, and VBA for Excel. The company's web site at provides online and email Excel training, a directory of useful Excel add-ins, a user forum, and lots of tips and tricks. Raina is also a lecturing team member at West Australian Institute of Management (WAIM) with specific expertise in Word, Excel, Powerpoint, Internet and email.

Inside This Book

(Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star

Most Helpful Customer Reviews on (beta) HASH(0xb3502210) out of 5 stars 19 reviews
12 of 12 people found the following review helpful
HASH(0xb365cf48) out of 5 stars Excellent book for common issues Aug. 3 2007
By J. Druin - Published on
Format: Paperback
This book could be titled "The Top 138 Excel Tips" book as well. The title seems to come from being a part of Oreilly's "Hack Series". The book is aranged roughly as 138 separate short chapters, one chapter per tip. Each tip is to the point and well explained. Samples, screenshots, and explanations accompany each tip. The tips are grouped into 8 actualy chapters that cover workbooks, built in features, naming, pivot tables, charts, formulas, macros and cross-application (such as Access integration). There are enough tips covered that different people will appreciate various parts of the book. It is not designed to be read cover to cover but to be indexed when trying to solve a problem in Excel. The titles of each tip are verbose enough that I can find what I am looking for by just scanning the table of contents rather than having to flip through the actual pages. This makes it easy to use and quicker; especially when I am at the computer and I just need to figure out how to do soemthing. I used tip #17 (validate data from a list on another worksheet) immediately to validate data being prep for posting to a database. Other tips were used within a few days so the book has already made itself useful in a short time.
9 of 9 people found the following review helpful
HASH(0xb32a6ac8) out of 5 stars Required reading for anyone using Excel 2007... March 6 2008
By Busy B - Published on
Format: Paperback
I've been preparing financial and statistical models in Excel for about 13 years, and I found the Hawley's book to be well written and organized. Unlike 2004's Excel Hacks: 100 Industrial-Strength Tips and Tools, this book covers how you can use Excel 2007 more effectively.

Disclaimer: I'm not a fan of Excel 2007 and its new layout and shortcuts, but this book is more useful than anything I've come across.
6 of 6 people found the following review helpful
HASH(0xb35ec00c) out of 5 stars A fine reference Sept. 7 2007
By Midwest Book Review - Published on
Format: Paperback
Users of the Excel program who want to move from beginning to intermediate levels without hours of study will find this handbook of over a hundred 'hacks' invaluable, offering tools and resources perfect for handling information, worksheets, and data analysis tasks. Hack formulas and functions show how to use macros and other shortcuts to maximum effectiveness, making this a fine reference for not only college-level libraries strong in Excel resources, but for general interest lending collections where patrons use computers for business purposes.

Diane C. Donovan
California Bookwatch
4 of 4 people found the following review helpful
HASH(0xb3426b10) out of 5 stars Superior April 27 2008
By Omnilord - Published on
Format: Paperback Verified Purchase
Excel Hacks is extremely useful for anyone who works with MS Excel frequently. From the moment you open the book, or just page through it, you can pick up on so many useful tips that may not be apparent even in formal classes or after years of use. Having had both formal classes and spent years creating spreadsheets used in production environments, Excel Hacks has helped me improve my spreadsheet knowledge.
5 of 6 people found the following review helpful
HASH(0xb3426b94) out of 5 stars More useful than I ever could have imagined Aug. 13 2007
By Greg A. Hurst - Published on
Format: Paperback
There are over 100 tips and tricks ranging from relatively simple for the novice user to reasonably complex for the power user. I've found myself going back to it again and again...and it's become the most dog-eared book on my shelf.

It does the best job of any book I've seen of truly explaining Pivot Tables as well as complex database functions.

Whether you're just getting started with Excel or whether you are a power-user (I generally fit into the power-user category), there is something for everyone!

I strongly recommend this book and give it my highest rating!