Excel Timesaving Techniques For Dummies

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.

Introduction. Part I: Making Excel Work Your Way. 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. Technique 11: Speeding Through Long Data Entries with AutoCorrect. Technique 12: Data Entry Tricks. Technique 13: Speeding Up Data Entry with AutoFill. Technique 14: Ensuring Accurate Data Entries with Data Validation. Technique 15: All Aboard the Numerical Entry Express! Technique 16: Verifying Entries with Text to Speech. Part III: Handy Ways to Format and Present Worksheet Data. Technique 17: Instant Range Formatting. Technique 18: Style Formatting Magic. Technique 19: Controlling When Certain Formats Are Used. Technique 20: Customizing Number Formats. Technique 21: Dazzling Alignments for Data Entries. Technique 22: Charting Data in a Snap. Technique 23: Chart Customization Tricks. Part IV: Worksheet Formula Timesavers. Technique 24: Efficient Formula Copying. Technique 25: Speeding Up Table Creation with Array Formulas. Technique 26: Using Range Names. Technique 27: Smarter Formula Construction. Technique 28: Trapping Those Terrible Errors. Technique 29: Eliminating Errors with Error Tracing. Technique 30: Creating Efficient Date and Time Formulas. Part V: Worksheet Editing Timesavers. Technique 31: Quickly Finding the Workbook You Want to Edit. Technique 32: Controlling the Worksheet Window Display. Technique 33: Managing Worksheet Windows. Technique 34: Quick and Easy Insertion and Deletion. Technique 35: Outline and Subtotal Magic. Technique 36: Consolidating Data from Different Worksheets. Technique 37: Editing with Search & Replace and Spell Check Part VI: Tips for Printing, Sharing, and Reviewing Workbooks. Technique 38: Spreadsheet Security. Technique 39: Printing Tricks for Flawless Reports. Technique 40: Sharing Data with Other Office Programs. Technique 41: Sharing Workbooks on a Network. Technique 42: Sending Workbooks Out for Review. Part VII: Streamlining Data Listing and Data Analysis. Technique 43: Adding and Editing Data Lists with the Data Form. Technique 44: Sorting Worksheet Data. Technique 45: Quick and Easy Basic Data List Filtering. Technique 46: More Data List Filtering plus Statistical Analysis. Technique 47: Doing What-if Analysis in a Snap with Data Tables. Technique 48: Easy What-if Analysis through Scenarios and Goal Seeking. Technique 49: Summarizing Data with Pivot Tables and Pivot Charts. Part VIII: Internet-Related Timesavers. Technique 50: Saving Worksheets as Web Pages. Technique 51: Importing Web Data into the Worksheet. Technique 52: Using Hyperlinks to Make Jumps in Workbooks. Part IX: The Scary (Or Fun) Stuff. Technique 53: Instant Lists in Excel 2003. Technique 54: Sharing Excel Workbooks and Lists with a Share Point Web Site. Technique 55: Entering Data and Issuing Commands by Voice. Technique 56: Sprucing Up Your Spreadsheets with Graphics. Technique 57: Doing Automated Table Lookups. Technique 58: Using Text Formulas for Fun and Profit. Technique 59: Creating Queries to Import Data from an External Database. Technique 60: Automating Repetitive Tasks with Macros. Technique 61: Creating Custom Functions to Use in Your Worksheets. Index.