Press Room

Press Release: January 10, 2005

"Excel Annoyances": A Cure for Excel Angst

Sebastopol, CA--"There's a lot of accumulated Excel angst out there," says Curtis Frye, author of the new Excel Annoyances (O'Reilly, US $24.95). "But you don't have time for nail biting. You need solutions now. The faster you can navigate around the roadblocks, the faster you can make good decisions, earn that bonus, get promoted to partner, retire with full salary, and never use Excel again."

Toward that end, Frye delivers Excel Annoyances, the key to fixing all the problems that most annoy Excel users. In this, his seventh book on Excel, author, Excel guru, and professional improvisational comedian Frye comes to the rescue of the many users who are "at their wits' end because of some Excel 'feature,' bug, quirk, flaw, or just plain dumb design decision," as he observes.

Microsoft Excel is the must-have spreadsheet program that's used for everything from running Little League teams to managing the budgets and forecasts of businesses all over the planet. But with such power comes perils: date formats that mysteriously change, lists that won't sort properly, formulas with tangled references, endless recalculations, and charts that refuse to be labeled.

Based on real-world gripes from Excel users around the globe, Excel Annoyances tackles the frustrations, inconsistencies, limitations, and hidden features found in Excel 97, 2000, 2002, and 2003. It also guides readers to useful utilities, web sites, and other resources that are likely to make their lives easier.

Divided into practical, logical chapters dedicated to topics like data entry, formulas, formatting, exchanging data, printing, charts, macros/VBA, and more, this fully illustrated, entertaining guide is brimming with smart and simple fixes for most every annoyance users encounter. It covers:

  • Handling faulty formats, using conditional formats, and exporting/importing with ease
  • Making formulas snap by using arrays and names ranges, and troubleshooting wonky references
  • Sorting and filtering like a pro, using lookups, and mastering PivotTables
  • Creating and manipulating charts
  • Printing reports the intended way
  • Moving data to and from Access, SQL databases, and the Web
  • From eliminating Clippy, to using if-then statements, to bringing up the magic 8-ball, the fixes, tools, and tips in Excel Annoyances will help readers make Excel do precisely what they want it to--and plenty more they never considered--as they customize Excel inside and out.

    Additional Resources:

    Excel Annoyances
    Curtis Frye
    ISBN: 0-596-00728-0, 235 pages, $24.95 US, $46.95 CA
    1-800-998-9938; 1-707-827-7000

    About O'Reilly

    For almost 40 years, O’Reilly Media has provided technology and business training, knowledge, and insight to help companies succeed. Our unique network of experts and innovators share their knowledge and expertise through the company’s Safari training and learning platform and at O’Reilly conferences. As a SaaS learning platform, Safari delivers highly topical and comprehensive technology and business learning solutions to millions of users across enterprise, consumer, and university channels. For more information visit

    Return to: O'Reilly Press Room

    Press Contacts

    Media Relations – Corporate & North America

    Fama PR

    Media Relations – Japan

    Fumi Yamakawa
    +81 3-3356-5227

    Media Relations – United Kingdom

    Helen Codling
    +44 (0) 1252 721284