Excel Hacks: 100 Industrial Strength Tips and Tools and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.

Have one to sell? Sell yours here
Start reading Excel Hacks: 100 Industrial Strength Tips and Tools on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Excel Hacks: 100 Industrial Strength Tips and Tools [Paperback]

David Hawley , Raina Hawley
4.8 out of 5 stars  See all reviews (6 customer reviews)

Available from these sellers.


Formats

Amazon Price New from Used from
Kindle Edition CDN $11.01  
Paperback --  
There is a newer edition of this item:
Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets
CDN$ 19.75
In Stock.

Book Description

March 31 2004 059600625X 978-0596006259 1

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.


Customers Who Bought This Item Also Bought


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.

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 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. 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

3 star
0
2 star
0
1 star
0
4.8 out of 5 stars
4.8 out of 5 stars
Most helpful customer reviews
5.0 out of 5 stars Treasure chest full of tips for Excel users... May 31 2004
Format:Paperback
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.
Was this review helpful to you?
4.0 out of 5 stars Mary Ann Reviews Excel Hacks May 25 2004
Format:Paperback
This book is full of amazing tricks and shortcuts that one can use to customize workbooks and make them more user friendly and visually appealing.
The book is designed to be useful to both Macintosh and PC users. The writing style is easy to understand and uses step-by-step instructions. Therer are many helpful illustrations.
The hacks are rated for difficulty: Beginner, Moderate and Expert, and groups of hacks are organized into chapters.
Hack #1 is rated as Beginner. This hacks allows the user to view multiple workbooks on the screen simultaneously and also how to change the layout style of the workbooks viewed. The Excel user can then choose a method of viewing multiple workbooks best suited to his or her needs.
Hack #3, rated as a Moderate hack, is entitled "Prevent Users from Performing Certain Actions." This hack protects Excel workbooks from changes. The creator can protect his or her workbooks from being copied with the Save As. . .command, prevent the user from printing a workbook and prevent users from inserting more worksheets.
Hack #57 is an example of an Expert hack. "Create A Speedometer Chart" seems to be one of the more elaborate hacks in the book. It enables the user to create a circular chart with a moving needle by first compiling data in a worksheet and then using the Chart Wizard to combine doughnut and pie charts. The user can then create a unique chart that isn't offered by the Chart Wizard. The speedometer needle will move when a scrollbar is activated by the user.
This book isn't one to use to learn Excel for the first time. But anyone who has a basic understanding of Excel will find hacks that are useful and will make their work more productive.
Was this review helpful to you?
5.0 out of 5 stars Wow! What an Excel-lent book!! May 20 2004
Format:Paperback
Just when you think you know everything, someone like this has to come along and show you that, comparatively speaking, you didn't know anything. Thank goodness, NOW YOU DO because you've read this terrific book!
Kudos to Dave & Raina Hawley!
Was this review helpful to you?
Want to see more reviews on this item?
ARRAY(0xfe300f0)

Look for similar items by category


Feedback