Excel Timesaving Techniques For Dummies
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.