I received a really cool book today titled F1 Get The Most Out Of Excel by Joseph Rubin, CPA (Limelight Media). A unique format that has a lot of practical use...
Chapter list: What's New in Excel 2002 & 2003; Working Inside; Excel Environment; Text, Date, Times; Summing & Counting; Formulas; Printing & Mailing; Lists, Analyzing Data; Index
I like books that are practical, but I don't think I've ever seen one that is set up to be *this* practical. There are 322 tips spread out over the chapters listed above. Each tip occupies a left/right page arrangement. On the right page is the title of the tip, the explanation of how to accomplish the task, and a screen print that illustrates the point. On the left, you have an area for "Notes" and "My Tips/Shortcuts". So not only do you have the author's information, but you can build up your own collection of notes on Excel tricks. At the very bottom of the left page, there's a reference to any related tips or shortcuts. I'm very impressed with the layout of this book. It's excellent. Also, each tip notes the versions of Excel that the tip relates to. The vast majority of the information encompasses Excel 97, 2000, 2002, and 2003.
With all the tips and information, the book runs over 800 pages. It's printed in a smaller format, so it's pretty easy to carry around. About the only thing I can fault the publisher for (*not* the author) is the thickness of the paper used in the book. The paper is pretty thin in order to keep the book from getting too bulky. The problem is that ink will easily bleed through if you aren't careful with your own notes (or even if you *are* careful). I think you better plan on using a pencil for any notes.
Excellent material in a unique, practical format... A definite winner for Excel users.
I've bent Excel over backwards doing things that it's not meant to do. I believe I'm an average user, maybe a notch above. This means knowing some of the lesser known tricks, but not a pro at pivots or creating elaborate financial spreadsheets. I have used pivots, but nothing heavy-duty. This book is 820 pages, but half of it has room for notes on the left page that has Notes, My Tips/Shortcuts, and Related Tips for finding similar tips like the one on the current page. You … more
Thomas Duff, aka "Duffbert", is a long-time member of the Lotus community. He's primarily focused on the development side of the Notes/Domino environment, currently working for a large insurance … more
Consider the Source
Use Trust Points to see how much you can rely on this review.
Providing Excel users with a tutorial and help tool, this book offers simple answers and solutions for any problem or question. Contained in this tool is a complete collection of tips, tricks, and shortcuts, including some that have never been seen before. These include limiting the movement in an unprotected cell and reducing the workbook size for quick sending via email. How the suggestions can be implemented in only a few easy steps is explained in detail. All of the most recent versions of the software including Excel 97, Excel 2000, Excel 2002, and Excel 2003 are covered. Users will also find a list of related tips as well as blank lines where they can add their own notes, turning the book into a personalized manual for maximizing their Excel abilities.