Excel Timesaving Techniques For Dummies

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.