Excel Annoyances How to Fix the Most ANNOYING Things About Your Favorite Spreadsheet

Excel may be responsible for more people buying PCs than any other product in history. And it may also be responsible for untold nervous breakdowns. This must-have spreadsheet program is 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; charts that refuse to be labeled! Based on real-world gripes from Excel users around the globe, Excel Annoyances tackles the quirks, bugs, inconsistencies, and hidden features found in Excel 97, 2000, 2002, and 2003. In the end, Excel Annoyances will help you to truly maximize Excel's seemingly limitless potential. Among the topics covered: * Data data data! Fix faulty formats, use conditional formats, export/import with ease * Make your formulas snap. Use arrays and named ranges; troubleshoot wonky references * Sort and filter like a pro, what-if like Greenspan, use lookups, master PivotTables * Create and manipulate charts * Move data to and from Access, SQL databases, the Web * Customize Excel inside and out * Make XML and data lists do your bidding.Frye, Curtis D. is the author of 'Excel Annoyances How to Fix the Most ANNOYING Things About Your Favorite Spreadsheet', published 2005 under ISBN 9780596007287 and ISBN 0596007280.