Excel Hacks
100 Industrial Strength Tips and Tools
Publisher: O'Reilly Media
Released: March 2004
Pages: 304

If you think that getting creative with Excel means the underhanded tweaking of numbers, think again. Excel Hacks shows even the most experienced users how to do things with Excel they might never have thought of doing--and lets them have a little fun while they're at it.

Microsoft Excel is not just the dominant spreadsheet in the world; it's also one of the most popular applications ever created. Its success lies not only in its power and flexibility, but also in its streamlined, familiar interface that casually conceals its considerable capabilities. You don't need to know everything that Excel can do in order to use it effectively, but if you're like the millions of Excel power users looking to improve productivity, then Excel Hacks will show you a wide variety of Excel tasks you can put to use, most of which are off the beaten path.

With this book, Excel power users can bring a hacker's creative approach to both common and uncommon Excel topics--"hackers" in this sense being those who like to tinker with technology to improve it. The "100 Industrial Strength Tips and Tools" in Excel Hacks include little known "backdoor" adjustments for everything from reducing workbook and worksheet frustration to hacking built-in features such as pivot tables, charts, formulas and functions, and even the macro language.

This resourceful roll-up-your-sleeves guide is for intermediate to advanced Excel users eager to explore new ways to make Excel do things--from data analysis to worksheet management to import/export--that you never thought possible. Excel Hacks will help you increase productivity with Excel and give you hours of "hacking" enjoyment along the way.

Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyExcel Hacks
 
4.7

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (2)

  • 4 Stars

     

    (1)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 3 customers

Sort by

Displaying reviews 1-3

Back to top

 
4.0

Valuable for advanced users

By Willyboy

from Undisclosed

Comments about oreilly Excel Hacks:

I'm always looking to improve my Excel skills, and this book intrigued me because of the way it is organized.

The Hawleys have done a good job providing insights into common Excel tasks, especially list management and creative use of graphs. They wring some clever results from infrequently used Excel functions, such as OFFSET, and from conditional formatting. As other readers have pointed out in these reviews, the hack on dynamic ranges (hack 42, for example) may justify the price of the book.

This definitely isn't for the novice, though. The authors don't do much hand-holding, and if all you do is copy in their code and use it, you'll be missing out on the message: stretch, massage and manipulate these techniques, and others hidden within Excel, to expand Excel's usefulness and your own capabilities. You definitely need to be comfortable with the VBA editor - they give you the code, but with no explanations or analyses.

Incidentally, there are really only 99 hacks. Hack #10 and hack #25 are the same. But it's still well worth the money.

Willyboy

 
5.0

Excellent book - One working hack makes it worth the money

By graemeaustin

from Undisclosed

Comments about oreilly Excel Hacks:

I bought this book about a month ago as I was fed up with Excel's limitations - and I needed to know what would work on PCs and Macs. This book has saved me time (& hence money).

The 2 that have worked so far for me are Hack #42 (dynamic named ranges) and #32 (cell formatting).

I understand that the cell formatting one is probably buried somewhere in the so-called documentation from MS but I never found it. And dynamic named ranges have so many different uses, I can't begin to list them all - list management, more efficiently run macros using pre-determined ranges etc.

There's about another dozen hacks which are now at the back of my head and the next time I update more workbooks, they will come into play.

(1 of 1 customers found this review helpful)

 
5.0

Beyond the Ordinary

By Michael

from Undisclosed

Comments about oreilly Excel Hacks:

This book is fantastic! I just made it through 17 of the 100 industrial strength tips included in this book and I'm very impressed. This will be an enormous help in improving my Excel skills. I can't wait to get through the other 83.

Displaying reviews 1-3

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $19.99
Formats:  DAISY, ePub, Mobi, PDF