Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets and over one million other books are available for Amazon Kindle. Learn more
  • List Price: CDN$ 40.50
  • You Save: CDN$ 16.52 (41%)
FREE Shipping on orders over CDN$ 25.
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.ca.
Gift-wrap available.
Excel Hacks: Tips and Too... has been added to your Cart
+ CDN$ 6.49 shipping
Used: Good | Details
Condition: Used: Good
Comment: **SHIPPED FROM UK** We believe you will be completely satisfied with our quick and reliable service. All orders are dispatched as swiftly as possible! Buy with confidence!
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 2 images

Excel Hacks: Tips and 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$ 23.98
CDN$ 21.67 CDN$ 3.07

Product Details

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 www.ozgrid.com provides online and email Excel training, a directory of useful Excel add-ins, a user forum, and lots of tips and tricks.

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 Amazon.ca
5 star
4 star
3 star
2 star
1 star

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 18 reviews
12 of 12 people found the following review helpful
Excellent book for common issues Aug. 3 2007
By J. Druin - Published on Amazon.com
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
Required reading for anyone using Excel 2007... March 6 2008
By Busy B - Published on Amazon.com
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
A fine reference Sept. 7 2007
By Midwest Book Review - Published on Amazon.com
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
Superior April 27 2008
By Omnilord - Published on Amazon.com
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
More useful than I ever could have imagined Aug. 13 2007
By Greg A. Hurst - Published on Amazon.com
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!