- Used Books
- Staff Picks
- Gifts & Gift Cards
- Sell Books
- Stores & Events
- Let's Talk Books
Special Offers see all
More at Powell's
Recently Viewed clear list
New Trade Paper
Ships in 1 to 3 days
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
More copies of this ISBN
Other titles in the Hacks series:
Excel Hacks: Tips & Tools for Streamlining Your Spreadsheetsby David Hawley
Synopses & Reviews
Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. There are many ways to take advantage of Excel's advanced capabilities without spending hours on advanced study. Excel Hacks provides more than 130 hacks — clever tools, tips and techniques — that will leapfrog your work beyond the ordinary.
Now expanded to include Excel 2007, this resourceful, roll-up-your-sleeves guide gives you little known "backdoor" tricks for several Excel versions using different platforms and external applications. Think of this book as a toolbox. When a need arises or a problem occurs, you can simply use the right tool for the job. Hacks are grouped into chapters so you can find what you need quickly, including ways to:
Book News Annotation:
This reference provides about 130 hacks--quick and dirty solutions to common problems--for getting the most out of Excel 2007 (and later versions). Arrangement is in chapters on reducing workbook and worksheet frustration, Excel's built-in features, naming, PivotTables, charting, hacking formulas and functions, macro hacks, and cross-application hacks. Readers can use the hacks directly as they build and improve spreadsheets, or they can study them, learn some Visual Basic for Application code, and customize the hacks for their own purposes. Step-by-step instructions, code, and screenshots are included. The authors are Excel consultants and trainers in Australia. Annotation ©2008 Book News, Inc., Portland, OR (booknews.com)
Excel 2007 promises great new power for users if they can find the secrets. This compendium of power-user tricks can help readers squeeze more out of every aspect of Excel, from the new interface to new features.
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.
Table of Contents
DedicationCreditsPrefaceChapter 1: Reducing Workbook and Worksheet FrustrationChapter 2: Hacking Excel's Built-in FeaturesChapter 3: Naming HacksChapter 4: Hacking PivotTablesChapter 5: Charting HacksChapter 6: Hacking Formulas and FunctionsChapter 7: Macro HacksChapter 8: Cross-Application HacksColophon
What Our Readers Are Saying
Other books you might like