Part I: Making Excel Work Your Way 5
Technique 1: Customizing the Excel Screen Display 7
Technique 2: Customizing the Excel Menus and Toolbars 13
Technique 3: Perfecting Your Spreadsheet Workspace 19
Technique 4: Saving Your Worksheets So You Can Find Them 22
Technique 5: Tailoring Excel’s Error Checking to Your Needs 27
Technique 6: Utilizing Excel’s Editing Settings 31
Technique 7: Streamlining Excel Programm Startup 36
Technique 8: Saving Time with Excel Add-ins 40
Part II: Quick Worksheet Creation Tricks 45
Technique 9: Navigating the Worksheet in a Snap 47
Technique 10: Making the Most Efficient Cell Selections 53
Technique 11: Speeding Through Long Data Entries with AutoCorrect 58
Technique 12: Data Entry Tricks 62
Technique 13: Speeding Up Data Entry with AutoFill 67
Technique 14: Ensuring Accurate Data Entries with Data Validation 72
Technique 15: All Aboard the Numerical Entry Express! 78
Technique 16: Verifying Entries with Text to Speech 82
Part III: Handy Ways to Format and Present Worksheet Data 85
Technique 17: Instant Range Formatting 87
Technique 18: Style Formatting Magic 92
Technique 19: Controlling When Certain Formats Are Used 97
Technique 20: Customizing Number Formats 102
Technique 21: Dazzling Alignments for Data Entries 111
Technique 22: Charting Data in a Snap 117
Technique 23: Chart Customization Tricks 123
Part IV: Worksheet Formula Timesavers 129
Technique 24: Efficient Formula Copying 131
Technique 25: Speeding Up Table Creation with Array Formulas 137
Technique 26: Using Range Names 141
Technique 27: Smarter Formula Construction 148
Technique 28: Trapping Those Terrible Errors 154
Technique 29: Eliminating Errors with Error Tracing 158
Technique 30: Creating Efficient Date and Time Formulas 164
Part V: Worksheet Editing Timesavers 169
Technique 31: Quickly Finding the Workbook You Want to Edit 171
Technique 32: Controlling the Worksheet Window Display 177
Technique 33: Managing Worksheet Windows 182
Technique 34: Quick and Easy Insertion and Deletion 187
.......and other