322 Tips for the Intermediate User

This book might have an alternative title of 322 Nifty Hints and Tips of things you can do with Excel. As such, it is not a beginners book for Excel. It doesn't tell you things like this is a spread sheet. Instead it tells you things like how to reverse the order of characters in a cell. For instance if you have a cell that contains ABCDE and it you want it to be EDCBA, you go to tip 139 on page 323 and it gives you a canned VBA module that will do it. Tip 139 just takes two pages, about average for a tip.

I find that I don't use this little book (it's little in format, not in page count) very often. But when I do, it gives me exactly the information that I want quickly and easily.

Two areas deserve particular mention:

Note the sub-title of the book where it talks about all the different versions of Excel. Some tips have to be spread out. Tip 144 talks about how to get continuously refreshed data from a web site in Excel 97. Tip 145 is the same subject but for Excel 2000. Tip 146 is the same thing for Excel 2002 and 2003.

And second Tips 296 through 322 cover nifty and wonderful things you can do with Pivot Tables. Many books don't even mention pivot tables, and they are a very powerful way to show data in different ways that are often more meaningful to executives.

Great help for those who are using Excel beyond the basics.

Other Reviews

• 322 Tips for the Intermediate User
• many concise tips on usage
• Good Excel Reference
• Filled with Time-Saving Tips That Are Easy to Locate
• The best Excel book in the market!