The more time you spend in Excel, the more time its shortcuts and automation features can save you. But those goodies are buried in many Excel books. Not this one: It’s nothing but timesavers, all the way through.
Even Greg Harvey’s simplest tips are very helpful. Do you constantly find yourself adding or removing blank worksheets whenever you create a new workbook? Why not adjust the default setting so you get the number of worksheets you want, right off the bat? Are you always changing column widths? Incorporate a new default into a template you can use for all your workbooks. While you’re at it, if you’re always fiddling with the Save folder to place your workbooks somewhere besides Excel’s defaults, why not change your default Save folder, too?
The book really takes off when it moves into more advanced terrain. Tailoring Excel’s built-in error checking capabilities to your needs. Building smarter formulas -- and avoiding mistakes that can lurk quietly, raising havoc with decision making. (Did you know Excel can read your entries back to you aloud, to help make sure they’re right?) Along similar lines, Harvey shows how to use data validation to make sure nobody can enter data that’s the wrong type, or way out of range.
There’s a full section on data listing and analysis -- including easy “what-if” techniques and a quick guide to Pivot Tables and Pivot Charts (it’s time you got comfortable with these). From importing web data to automating table lookups, sharing to printing, this book’s easy techniques will make you more effective with any recent version of Excel. Bill Camarda, from the January 2005 Read Only