Excel Annoyances: How to Fix the Most Annoying Things about Your Favorite Spreadsheet

Excel Annoyances: How to Fix the Most Annoying Things about Your Favorite Spreadsheet
by Curtis Frye D.

Excel Annoyances: How to Fix the Most Annoying Things about Your Favorite Spreadsheet
List Price: $24.95
Our Price: $9.98
You Save: $14.97 (60%)
Availability: Usually ships in 1-2 business days
Buy Used: from $0.01 (click here)
Category: Book
See more book details and other editions


or

Book Summary Information

Author: Curtis Frye D.
Edition: Paperback
Audio: English (Unknown); English (Original Language); English (Published)
Published: 2005-01-04
ISBN: 0596007280
Number of pages: 256
Publisher: O'Reilly Media

Book Reviews of Excel Annoyances: How to Fix the Most Annoying Things about Your Favorite Spreadsheet

Book Review: Excel Annoyances
Summary: 5 Stars

Excel Annoyances ...

This book is made for those who have had one or more vexing problems with Excel. If that's you, the answer can probably be found here and lots more besides.

Curtis Frye is an established author, including several books on Excel. He has the book divided into chapters that deal with several categories of problems: Entering Data, Formatting, Formulas, Manipulating Data, Charts, Exchanging Data, Printing, and Customization.

His solutions vary from basic training on how to use a feature, to how to tweak things "just so." Each Annoyance is the result of someone's problem with an aspect of Excel. Since many people do not upgrade to the latest version of Excel when it's available, the book covers solutions from Excel 97 through the current Excel 2003.

One of the most interesting things I learned was the existence of a function that translated numbers into Roman numerals! I never knew this existed. That's not to say I would ever have any use for such a function, but it was interesting playing around with it. If you want to try it out, type a number in one cell and in another, type this formula: = roman(cell), where "cell" is the location of the number you typed. You'll see the result in roman numbers, as advertised. Slick! Someone once threatened to file his income tax return using roman numbers, just to make things hard for IRS, and this is a way it could be done. IRS would probably object.

Screen shots are used liberally in the book. These may simply be a shot of a worksheet but often a related dialog box is also shown. Occasionally a text box includes extra information that may be of importance for a subject.

One extra feature include in the book is reference to some time-wasters, also known as games. Each is an Excel version and is free to download. There's Pac Man, Arkanoid, BlackJack, Rubik's Cube, Tetris and more.

There are occasional answers using Visual Basic, but for the most part, the answers simply use the settings that are already in Excel. Most users never tap the full potential of Excel, and I'm no exception. I feel I am an expert, but I certainly learned a lot by reading this book and you will too, if you use Excel at all.

Summary of Excel Annoyances: How to Fix the Most Annoying Things about Your Favorite Spreadsheet

It's the solution to almost all of your electronic organization needs. Need to present a detailed expense report? Try an Excel spreadsheet. Keeping track of a complicated budget? Excel to the rescue. Want to keep tabs on your office football pool? You guessed it.

Thanks to its incredible versatility and power, Excel has emerged as more than just a mainstream program; it's now one of the most used applications on the planet. Everyone from run-of-the-mill PC users to leading financial analysts count on Excel to make sense of overflowing data. And to keep up with the overwhelming user demand, three different versions of Excel have hit the market since the debut of Excel 97: Excel 97, 2000, 2002, and 2003. Naturally, each version offers a new slate of next-generation upgrades--and, of course, operating bugs!

At last, Excel users have some relief: Excel Annoyances emerged from the suggestions of numerous Excel users who've struggled with these irritating bugs over the years. Written in the popular Annoyances format, this latest O'Reilly helper addresses all of the quirks, bugs, inconsistencies, and hidden features found in each of the four versions. Chances are if someone, somewhere, found a certain step confusing, then it's addressed in Excel Annoyances.

Author Curtis D. Frye breaks down the cavalcade of information into several tip-of-the-finger categories such as Entering Data, Formatting, Charting, Printing, and more. If you're one of the millions of people who use Excel, you're sure to find a goldmine of helpful nuggets that you can use to fix the program's most annoying traits. In the end, Excel Annoyances will help you to truly maximize Excel's seemingly limitless potential.

Personal Finance Books

Book Subjects
Most talked about in Personal Finance Books
The Bond Book: Everything Investors Need to Know About Treasuries, Municipals, GNMAs, Corporates, Zeros, Bond Funds, Money Market Funds, and More ImageThe Bond Book: Everything Investors Need to Know About Treasuries, Municipals, GNMAs, Corporates, Zeros, Bond Funds, Money Market Funds, and More
by Annette Thau
McGraw-Hill; Published: 2000-11-02; Hardcover; Book
Best price: $6.33
Price in other shops: $34.95
The Essential Guide to Your 401(k) ImageThe Essential Guide to Your 401(k)
by Kenneth M. Morris, Virginia B. Morris, Lightbulb Press
McGraw-Hill Companies; Published: 2001-02-15; Paperback; Book
Best price: $5.99
Price in other shops: $14.95
Financial Security in Troubled Times: What You Need to Do Now ImageFinancial Security in Troubled Times: What You Need to Do Now
by Ric Edelman
HarperBusiness; Published: 2001-10-15; Hardcover; Book
Best price: $0.11
Price in other shops: $14.95
Discover the Wealth Within You Audiocassette ImageDiscover the Wealth Within You Audiocassette
by Ric Edelman
HarperAudio; Published: 2002-04; Audio Cassette; Book
Best price: $0.99
Price in other shops: $25.95
Alpha Teach Yourself Personal Finance in 24 Hours ImageAlpha Teach Yourself Personal Finance in 24 Hours
by Janet Bigham Bernstel, Lea Saslav
Alpha; Published: 2000-05-19; Mass Market Paperback; Book
Best price: $4.99
Price in other shops: $19.99
The Eleven Commandments of Wildly Succesful Women ImageThe Eleven Commandments of Wildly Succesful Women
by Pamela Gilberd
MacMillan Spectrum; Published: 1996; Paperback; Book
Best price: $3.30
Price in other shops: $14.95
Personal Finance: An Integrated Planning Approach ImagePersonal Finance: An Integrated Planning Approach
by Bernard J. Winger, Ralph R. Frasca
Macmillan Coll Div; Published: 1993-01; Hardcover; Book
Best price: $8.50
Price in other shops: $66.00
Protecting Your Pension For Dummies ImageProtecting Your Pension For Dummies
by Robert D. Gary, Jori Bloom Naegele
For Dummies; Published: 2007-07-30; Paperback; Book
Best price: $2.69
Price in other shops: $21.99
You Can Do It!: The Boomer's Guide to a Great Retirement ImageYou Can Do It!: The Boomer's Guide to a Great Retirement
by Jonathan D. Pond
HarperBusiness; Published: 2006-11-28; Hardcover; Book
Best price: $1.01
Price in other shops: $26.95
The Fundline Advisor ImageThe Fundline Advisor
by Richard Croft, Eric Kirzner
Harpercollins Canada; Published: 1998-10; Paperback; Book
Best price: $339.65
Similar Books and other products
Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel ImageExcel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel
by Bill Jelen
Holy Macro! Books; Published: 2009-04-01; Paperback; Book
Best price: $15.03
Price in other shops: $24.95
Fixing PowerPoint Annoyances: How to Fix the Most Annoying Things about Your Favorite Presentation Program ImageFixing PowerPoint Annoyances: How to Fix the Most Annoying Things about Your Favorite Presentation Program
by Echo Swinford
O'Reilly Media; Published: 2006-02-24; Paperback; Book
Best price: $8.96
Price in other shops: $19.99
Fixing Access Annoyances: How to Fix the Most Annoying Things about Your Favorite Database ImageFixing Access Annoyances: How to Fix the Most Annoying Things about Your Favorite Database
by Phil Mitchell, Evan Callahan
O'Reilly Media; Published: 2006-02-28; Paperback; Book
Best price: $8.48
Price in other shops: $19.99
Excel VBA Programming For Dummies ImageExcel VBA Programming For Dummies
by John Walkenbach
For Dummies; Published: 2010-05-24; Paperback; Book
Best price: $18.06
Price in other shops: $29.99
Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets ImageExcel Hacks: Tips & Tools for Streamlining Your Spreadsheets
by David Hawley, Raina Hawley
O'Reilly Media; Published: 2007-06-27; Paperback; Book
Best price: $12.50
Price in other shops: $29.99
Fixing Windows XP Annoyances ImageFixing Windows XP Annoyances
by David A. Karp
O'Reilly Media; Published: 2006-03-22; Paperback; Book
Best price: $10.55
Price in other shops: $19.99
PC Annoyances, Second Edition ImagePC Annoyances, Second Edition
by Steve Bass
O'Reilly Media; Published: 2005-03-05; Paperback; Book
Best price: $5.79
Price in other shops: $19.95
Excel Hacks: 100 Industrial-Strength Tips and Tools ImageExcel Hacks: 100 Industrial-Strength Tips and Tools
by Raina Hawley, David Hawley
O'Reilly Media; Published: 2004-03-01; Paperback; Book
Best price: $8.40
Price in other shops: $24.95
Word Annoyances: How to Fix the Most ANNOYING Things about Your Favorite Word Processor ImageWord Annoyances: How to Fix the Most ANNOYING Things about Your Favorite Word Processor
by Guy Hart-Davis
O'Reilly Media; Published: 2005-07-05; Paperback; Book
Best price: $6.04
Price in other shops: $19.95