Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com
Learn how to create Excel dashboards.

EXCEL HACKS 2nd Addition


NEW! More Books.. TIPS AND TOOLS FOR STREAMLINING YOUR SPREADSHEETS

 

By Dave and Raina Hawley of www.ozgrid.com

138 Tips and Tools for Streamlining Your SpreadsheetsAimed at the intermediate+ power user.

Table of Contents | Buy Excel Hacks | Working Examples  | Excel Book Store

On this page: Book Description | Reviews

Excel Hacks

As large number of hacks in this book require working examples, we have included these in the hope that they will help owners of Excel Hacks  save time by copying  working examples directly into their own Excel Workbooks.   

Should you have any question at all about anything in the book, please post your question to our Free Excel Forum in the Excel HELP category. You must first Register Here, only an email, username and password is required.

You may also wish to browse our list of Frequently Asked Questions on Excel. For many more free Excel Workbook Downloads, please go to Free Excel Downloads 1, Free Excel Downloads 2

Excel Hacks Book Description

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 138 "Tips and Tools for Streamlining Your Spreadsheets" 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.

Excel Hacks is written for Excel 2007 and prior versions.

Reviews

More useful than I ever could have imagined, August 14, 2007 By Greg A. Hurst "Hack Junkie" (Southlake, TX USA)

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!


Excellent book for common issues, August 3, 2007 By  J. Druin (Kentucky, USA)

This book could be titled "The Top 138 Excel Tips" book as well. The title seems to come from being a part of O Reilly's "Hack Series".

The book is arranged 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 actually 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 something. 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


Instant Download and Money Back Guarantee on Most Software

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Add to Google Search Tips FREE Excel Help

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft