Page 8 - Excel Timesaving Techniques for Dummies

00b_574272_ftoc.qxd 10/1/04 10:24 PM Page vii
Contents at a Glance

Introduction 1 Part III: Handy Ways to Format and
Present Worksheet Data 85
Part I: Making Excel Work Your Way 5
Technique 17: Instant Range Formatting 87
Technique 1: Customizing the Excel Screen
Display 7 Technique 18: Style Formatting Magic 92
Technique 2: Customizing the Excel Menus Technique 19: Controlling When Certain
and Toolbars 13 Formats Are Used 97
Technique 3: Perfecting Your Spreadsheet Technique 20: Customizing Number Formats 102
Workspace 19 Technique 21: Dazzling Alignments for Data
Technique 4: Saving Your Worksheets So Entries 111
You Can Find Them 22 Technique 22: Charting Data in a Snap 117
Technique 5: Tailoring Excel’s Error Technique 23: Chart Customization Tricks 123
Checking to Your Needs 27
Technique 6: Utilizing Excel’s Editing Settings 31 Part IV: Worksheet Formula
Timesavers 129
Technique 7: Streamlining Excel Program
Startup 36 Technique 24: Efficient Formula Copying 131
Technique 8: Saving Time with Excel Add-ins 40 Technique 25: Speeding Up Table Creation
with Array Formulas 137
Part II: Quick Worksheet Creation Tricks 45 Technique 26: Using Range Names 141

Technique 9: Navigating the Worksheet
in a Snap 47 Technique 27: Smarter Formula Construction 148
Technique 28: Trapping Those Terrible
Technique 10: Making the Most Efficient
Cell Selections 53 Errors 154
Technique 29: Eliminating Errors with Error
Technique 11: Speeding Through Long Data
Entries with AutoCorrect 58 Tracing 158
Technique 30: Creating Efficient Date and
Technique 12: Data Entry Tricks 62
Time Formulas 164
Technique 13: Speeding Up Data Entry
with AutoFill 67 Part V: Worksheet Editing Timesavers 169
Technique 14: Ensuring Accurate Data Technique 31: Quickly Finding the Workbook
Entries with Data Validation 72 You Want to Edit 171
Technique 15: All Aboard the Numerical Technique 32: Controlling the Worksheet
Entry Express! 78 Window Display 177
Technique 16: Verifying Entries with Text Technique 33: Managing Worksheet Windows 182
to Speech 82
Technique 34: Quick and Easy Insertion and
Deletion 187