Covering formulas, charts, data lists, macros, and versions 2000, 2002, and 2003, this book offers more than 60 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
Technique 1: Customizing the Excel Screen Display.
Technique 2: Customizing the Excel Menus and Toolbars.
Technique 3: Perfecting Your Spreadsheet Workspace.
Technique 4: Saving Your Worksheets So You Can Find Them. Technique 5: Tailoring Excel’s Error Checking to Your Needs. Technique 6: Utilizing Excel’s Editing Settings.
Technique 7: Streamlining Excel Program Startup.
Technique 8: Saving Time with Excel Add-ins.
Part II: Quick Worksheet Creation Tricks.
Technique 9: Navigating the Worksheet in a Snap.
Technique 10: Making the Most Efficient Cell Selections.
...etc...