"Excel Hacks" is a useful and easy-to-follow book. Excel is used for a wide array of tasks in today's corporate and educational environments. While Excel is used widely, its full range of utility is, based on my own experience, not utilized by a large percentage of Excel users.

This book covers versions of Excel preceding Excel 2007, and Excel 2007 offers an expanded range of formatting tools and options that diminish the need for some of the hacks in the publication. That being said, this book is a worthwhile investment for all Excel users.

For those readers who use VBA (Visual Basic for Applications) with Excel, there are a number of hacks in this book that lend themselves to quick and useful extensions into code.

Although there is some overlap between hacks, overall this is a great addition to an excel reference library

This book has great tips and reminders for mastering Excel beyond the basic tools that are similar across the Microsoft Office suite.

This actual book is better than advertised! Surpassed my expectations. Used several tips in the first day and left my co-workers speechless! THANKS!!!!

While this book is not really written to be something you read cover to cover, I did just to fill up my mental tookbox. (If you don't know that you have a hammer in your tool box, you might use a rock instead) This book prompted me to buy other books by the publisher because I was able to use things out of it right away. The hacks are easy to understand and use and before reading this book, I didn't know how many spreadsheet problems I had that were screaming for a solution.

I bought this book thinking I might learn a few VB tricks. I have used this for many sheets I am building. I may haave to buy another copy as I am wearing my first copy out. I found at least 20 items in this book that I used or modified to make Excel do what I needed it to do.

Thanks for this book.

Because of this book I have bought 4 other Hacks books.

A bit pricy, but otherwise a nice selection of Excel Tips and tools. In my mind the most useful are those which get around Excels seeming arbitrary limitations like #23,24,25,92 etc. but #42 is worth the price of the book if you haven't figured out a workaround. (it was interesting to contrast how the authors approached this, with my own solution). Not a beginners book or an "intro for Dummies" this is aimed at the user burgeoning on Expert.
I learnt some new approaches and will definitely be using them

First off this book shouldn't be called 100 tips, it should be 99, it turns out that #12 and #61 are the same tip. Anyways the book isn't bad if your looking for something to help you become more than a beginner excel users. Some of the tips are aren't that great but I'd say for the most part they are quite helpful. The book isn't a bad thing to have at your desk for a quick reference. If you really know excel then this book is not for you and you should probably think about getting a good vba book.

First off this book shouldn't be called 100 tips, it should be 99, it turns out that #12 and #61 are the same tip. Anyways the book isn't bad if your looking for something to help you become more than a beginner excel users. Some of the tips are aren't that great but I'd say for the most part they are quite helpful. The book isn't a bad thing to have at your desk for a quick reference. If you really know excel then this book is not for you and you should probably think about getting a good vba book.

Good book, I was definitly able to immediately use one or two tricks. If you dont know excel well, this isnt for you. Definitly for the much more advanced users. The best thing is that it specifically helps with the things that many of us recognize as "limitations" of excel. It would be great if they had an online resource for their code and examples, but they dont. Worth the price for an expert trying to expand their skills.

Microsoft Excel is an extremely powerful tool. Yet most users have only scratched the surface of its power, using only a small part of its capabilities.

Excel Hacks: 100 Industrial-Strength Tips & Tools by David & Raina Hawley, shows readers how to do more, and how to do things better, with the market-leading spreadsheet. The word "hack" here refers to its original meaning in computers. A hack was either a "quick and dirty solution" or a "clever way of doing things", and didn't refer to breaking into systems. This book presents 100 different hacks spread over eight categories, covering the basics; built-in features; naming hacks; pivot tables; charts; formulas and functions; macros; and connecting Excel to the rest of the world.

Individually, none of these hacks may cause you to run down the street shouting "Eureka", but together they should help just about every Excel user. I consider myself an expert user, working with spreadsheets for over twenty years and teaching classes in Excel and 1-2-3, yet I was still able to learn a lot from this book. In some cases, it was genuinely new information (Hack #50, Explode a Single Slice from a Pie Chart or Hack #99, Access SOAP Web Services from Excel). In other cases, it showed how to use a tool I knew about in some different way (Hack #41, Create Custom Functions Using Names or Hack #78, Construct Mega-Formulas). A couple of times, it served as a reminder to use some tool that I had been neglecting (Hack #6, Customize the Template Dialog and Default Workbook).

Some of the hacks are usability tips, showing how other tools (such as pivot tables) will be more useful if you lay out data in a certain way. Several tips help if you develop spreadsheets for others to use, limiting their capacity to screw things up. Sometimes, the hacks may just spur you to further thought, making you think "Gee, if you can use this tool to do this, maybe with just a little more work I can get it do that!"

The hacks are self-contained, so you don't have to read the book cover-to-cover. If a particular topic doesn't interest you, it won't hurt to jump ahead, or even skip a particular chapter. You don't need to type in long, complicated listings either. You can download the sample code for all the hacks from the authors' website. The authors do Excel training and application work in western Australia, and their website is crammed with more Excel material.

Who should read this book? The ideal audience is the broad middle class of Excel users. You shouldn't give it to a beginner, because they are still learning about the forest while this book looks at individual trees. Super power users, who may know ninety of these hacks already, won't get that much of it either, but they should be writing the books, not reading them. But for everyone in between, the book is sure to teach something you didn't know about Excel.

[...]

This is one of those rare books which provides value for all skill levels. I have been using Excel for over 10 years and am generally happy if I learn 3 or 4 new methods for using Excel from a particular book. There are numerous examples here of implementing Excel solutions that I have not seen or thought of previously. Further, these examples can be implemented by virtually any user of the product. The content is well-written and provides very good examples of the "hacks." BUY it even if you think you know everything there is to know about Excel.

This book is a good introduction, but it's not a Hacks book. The Hacks series, which I really like, is all about unique and novel approaches to tricky problems. This book is a nice introduction to Excel, but it doesn't provide particularly unique content. I'm sorry to see that since I haven't yet seen a Hacks book I didn't like. Oh well, there is a first time for everything.

If you are interested in Excel introductory material you will probably like this book. If you are an experience Excel user looking for a Hacks style book with unique and cool solutions to tough problems, you won't find them here. I gave the book three stars because, even though it's not a Hacks book per se, it's still a tight and well written book on Excel that is still far superior to some of the 1000 page screenshot collection doorstops on the market.

Every excel user should have this on their desk for quick reference. This book reveals many hidden kinks that we would never have thought was available in excel. This book apart from it easy to understand steps also reveals downloadable ADD-IN's to your excel >>> expanding your use of this powerful financial worksheet. This also has as many instructional's if your using a MAC.

If you spend any time working with Excel as part of your job, you'll really like this book... Excel Hacks by David & Raina Hawley (O'Reilly). This book contains 100 tips and tricks related to the Excel spreadsheet package from Microsoft. The tips are divided into the following chapters:

Reducing Workbook And Worksheet Frustration; Hacking Excel's Built-in Features; Naming Hacks; Hacking PivotTables; Charting Hacks; Hacking Formulas And Functions; Macro Hacks; Connecting Excel To The World

This particular Hacks book has an advantage that many other Hacks titles don't have. The subject matter relates to a single program, so nearly all the hacks are applicable to an Excel user. Contrast that to a Hacks title like Network Security Hacks, where your choice of operating system limits the number of tips that you can use. While there are some Windows-only Excel hacks included, most all the tricks work on both the Windows and Mac version of Excel. Nobody should feel left out here.

I especially liked the chapter on the charting hacks. They outline a technique for building a speedometer chart that is really impressive.

If you are an Excel power user (or know someone who is), this is the book for you.

I have bent Excel over backwards to do stuff it was not meant to do like track training metrics and use it as process bug-tracker (think programming bug tracking system except it's for processes).

PivotTables are useful, but when I need them, I have forgotten how to use them to their fullest. My mind goes blank when I face the PivotTable wizard. A whole chapter is devoted to its magic and scanning the hack titles helps you quickly decide what you need and go to work.

The hacks go from easy as pie to tough as nails. Did you know the comments boxes don't have to be square? It's a simple hack and the first cool thing I learn from the book. The hacks covering XML and macros are for the advanced users, but intermediate users should be able to do them and hard working beginners can get there.

Excel isn't just for accountants anymore and the book shows how to use it for other things. The book is worth the investment for anyone who uses Excel. Make it break a sweat with these hacks and have fun doing it.

If you are one of the million users of MS Office, and had any use for numbers, you would hve used, with no doubt, MS Excel. Which of course has not made you any more productive, as much as MS would like us all to believe.

Now that you have Excel installed, you might as well use its power. With the help of two awesome Australians who share willingly their years of experience with Excel and VBA, you can too become a pro, at least as far as spreadsheets are concerned.

Here is a selection of some of the more interesting and handy topics and hacks covered:

- Lock and protect cells containing formulas
- Tie custom toolbars to a particular workbook
- Remove phantom workbook links
- Extract data from a corrupt workbook
- Use Replace... to remove unwanted characters
- Create custom functions using names
- Automate PivotTable creation
- Explode a single slice from a Pie Chart
- Create charts that adjust to data
- Hack chart data so that blank cells are not plotted
... plus 20 formula and function hacks and 14 macro hacks.

Last but not least, several very useful hacks on connection Excel to other applications using XML and SOAP Web Services.

Overall, as the Hacks series has proved so far, O'Reilly continues with its tradition of publishing useful books and pricing them so reasonably that anyone who has paid the price of the product would do well to buy the book as well.

This is a very useful guide to overcoming and avoiding irritations. Using Excel can be infuriating, but it's often the most convenient software to use. This book certainly increases my confidence and reduces my dread. For example, there are lots of tips on how to streamline your work and avoid repetetive tasks.

It goes far beyond that, though, and advises you how to personalize your workspace and use what I would call "magic" to make my work go more smoothly. Although it isn't the most exciting writing style, the information works and improves my Excel experience. I'm so much less frustrated when working with my data sets!