Excel Timesaving Techniques for Dummies

Excel Timesaving Techniques for Dummies

by Greg Harvey, T. Franklin
     
 

Covering formulas, charts, data lists, macros, and versions 2000, 2002, and 2003, this book offers more than seventy easy-to-follow techniques that show both new and experienced Excel users how to save time and avoid tedious or redundant tasks. Bestselling author Greg Harvey includes information on customizing Excel's menus and toolbars; modifying Excel's editing

Overview

Covering formulas, charts, data lists, macros, and versions 2000, 2002, and 2003, this book offers more than seventy easy-to-follow techniques that show both new and experienced Excel users how to save time and avoid tedious or redundant tasks. Bestselling author Greg Harvey includes information on customizing Excel's menus and toolbars; modifying Excel's editing settings; using add-ins, AutoCorrect, AutoFill, AutoFormat, and data validation; copying and moving data between worksheets; encrypting workbook files; creating external database queries; converting worksheet data and charts into Web pages; and much more.

• Written by Greg Harvey, one of the bestselling technology authors of all time, whose books have combined sales of more than four million copies

• A unique, two-column format makes it easy for readers to grasp and apply each technique-and begin working more efficiently

Editorial Reviews

bn.com
The Barnes & Noble Review
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

Product Details

ISBN-13:
9780764574276
Publisher:
Wiley
Publication date:
10/28/2004
Series:
For Dummies Series
Pages:
416
Product dimensions:
8.02(w) x 9.04(h) x 0.89(d)

Related Subjects

Meet the Author

Greg Harvey is a computer trainer and the author of some 50 books on technology. He operates Mind Over Media, a venture in multimedia publishing.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >