Includes index.

Making Excel Work Your Way -- Customizing the Excel Screen Display -- Standard Display Settings -- Switching to Full Screen -- Customizing the Worksheet Display -- Saving Custom Display Settings -- Customizing the Excel Menus and Toolbars -- Showing the Toolbars and Menus in All Their Glory -- Toolbars and Menus Made to Order -- A Toolbar and Menu of Your Own -- Adding Macros and Links to Toolbars and Menus -- Perfecting Your Spreadsheet Workspace -- Saving Your Workspace -- Opening a Workspace Whenever Excel Launches -- Saving Your Worksheets So You Can Find Them -- Modifying the Default File Location -- Saving New Files with Summary Information -- Changing the AutoRecover Settings -- Tailoring Excel's Error Checking to Your Needs -- Modifying the Error Checking Settings -- Suppressing All Error Indicators -- Hiding Error Values On-Screen and in Print -- Utilizing Excel's Editing Settings -- Putting the Cell Pointer in the Right Direction -- Completely Turned Off to AutoComplete -- Doing the Drag-and-Drop Thing -- Doing Direct Cell Editing -- Streamlining Excel Program Startup -- Excel Desktop Shortcut -- Adding Excel to the Quick Launch Toolbar -- Pinning Excel to the Start Menu -- Launching Excel on Windows Startup -- Saving Time with Excel Add-ins -- Installing Add-ins -- Using the Built-in Add-ins -- Getting Online Add-ins -- Quick Worksheet Creation Tricks -- Navigating the Worksheet in a Snap -- Saving the Cell Pointer's Position -- Going Direct -- A Little Go To Magic -- Zooming Out to Get the Big Picture -- Making the Most Efficient Cell Selections -- AutoSelect at Your Service -- Go To It and Select It -- Going for the Big Selections -- Speeding Through Long Data Entries with AutoCorrect -- Setting the Correct AutoCorrect Settings -- Losing the Links -- Taming the Smart Tags -- Data Entry Tricks -- Making the Same Entry in Many Places -- Putting the Wraps on the Data Entry -- Let's Do It as a Group! -- Speeding Up Data Entry with AutoFill -- Getting Your Fill of AutoFill -- Incrementally Speaking -- Fill Lists Made to Order -- Ensuring Accurate Data Entries with Data Validation -- Only the Valid Need Apply -- Information Please! -- Warnings to Make Them Wary -- All Aboard the Numerical Entry Express! -- Taking Advantage of the Numeric Keypad -- Putting the Decimal Places at Your Service -- Number Please! -- Verifying Entries with Text to Speech -- "Can You Hear Me Now?" -- Modifying the Text to Speech Settings -- Handy Ways to Format and Present Worksheet Data -- Instant Range Formatting -- Head-to-Toe Table Formatting with AutoFormat -- Getting Artistic with the Format Painter -- Cutting and Pasting Formats Only -- Style Formatting Magic -- Styling -- Creating Styles of Your Own -- Merging Styles from One Book into Another -- Controlling When Certain Formats Are Used -- Formats to Suit Every Condition -- Making Your Outstanding Errors Stand Out -- Customizing Number Formats -- Creating Custom Number Formats -- Assigning Custom Number Formats to Styles and Toolbars -- Applying Euro Currency Formats -- Dazzling Alignments for Data Entries -- Line Me Up -- Getting Your Text under Control -- Charting Data in a Snap -- Instant Charts -- Chart Wizard Magic -- Chart Customization Tricks -- Getting the Chart Titles and Headings in Balance -- Scaling and Formatting the Chart Axes -- Tricks for Making the Plotted Data Easier to Decipher -- Worksheet Formula Timesavers -- Efficient Formula Copying -- Going from Relative to Absolute -- When It's Copy Time -- Speeding Up Table Creation with Array Formulas -- A Quick Look at Array Ranges -- Hurray for Array Formulas! -- Editing Array Formulas -- Using Range Names -- Name That Range! -- Assigning Range Names to Constants -- Using Your Range Names in Formulas -- Smarter Formula Construction -- Pointing Out Cell References in Formulas -- Putting the Insert Function Feature at Your Service -- Using Labels Instead of Cell References in Formulas -- Trapping Those Terrible Errors -- If I Were a Logical Function -- Trapping Division by Zero Errors -- Trapping All Types of Error Values -- Eliminating Errors with Error Tracing -- Formula Auditing 101 -- Tracing Formula Precedents -- Tracing Formula Dependents -- Finding the Original Error and Fixing Its Formula -- Creating Efficient Date and Time Formulas -- The Deal with Dates and Times -- You Do the Date Math! -- When Your Time Is Up -- Worksheet Editing Timesavers -- Quickly Finding the Workbook You Want to Edit -- Opening Recently Used Files -- Making the Most of the File Search Task Pane -- Searching for Files in the Open Dialog Box -- Controlling the Worksheet Window Display -- Zooming In for the Edits -- Frozen Panes in My Windows -- A Worksheet with a Custom View -- Managing Worksheet Windows -- Opening Panes in the Worksheet Window -- Comparing Sheets in the Same Workbook -- Comparing Sheets in Separate Workbooks -- Quick and Easy Insertion and Deletion -- Inserting and Deleting Cells in an Existing Range -- Inserting and Deleting Rows and Columns -- Inserting and Deleting Worksheets -- Outline and Subtotal Magic -- Adding Outline Levels to a Table or List -- Subtotaling a Table or List -- Consolidating Data from Different Worksheets -- Consolidating Data by Position -- Consolidating Data by Category -- Linking Consolidated Data -- Editing with Search & Replace and Spell Check -- Using Find and Replace -- Eliminating Typing Errors with Spell Check -- Tips for Printing, Sharing, and Reviewing Workbooks -- Spreadsheet Security -- Assigning a Password for Opening a Workbook -- Protecting the Worksheet Against Unwanted Changes -- Hiding Sensitive Worksheet Data -- Printing Tricks for Flawless Reports -- Making Last-Minute Adjustments with Print Preview -- Controlling Bad Page Breaks -- Adding Headings to Your Report -- Printing the Formulas in the Report -- Printing the Charts in the Report -- Sharing Data with Other Office Programs -- Swapping Data via the Clipboard -- Importing Text Files into Excel -- Embedding Excel Data in Other Office Documents -- Sharing Workbooks on a Network -- Let's All Learn to Share -- Merging Changes from Different Users -- Merging Different Copies of a Shared Workbook -- Sending Workbooks Out for Review -- Getting a Workbook Ready for Review -- Sending Out a Workbook for Review -- Streamlining Data Listing and Data Analysis -- Adding and Editing Data Lists with the Data Form -- Creating a New Data List and Data Form -- Sorting Worksheet Data -- Don't Be Out of Sorts -- Sorting the Field Names in a Data List -- Quick and Easy Basic Data List Filtering -- AutoFilter Basics -- Customizing the AutoFilter Settings -- More Data List Filtering plus Statistical Analysis -- Putting the Advanced Filter in Service -- Getting Data List Statistics -- Doing What-if Analysis in a Snap with Data Tables -- Creating a One-Variable Data Table -- Creating a Two-Variable Data Table -- Easy What-if Analysis through Scenarios and Goal Seeking -- Exploring Different Scenarios -- Reaching a Target with Goal Seeking -- Summarizing Data with Pivot Tables and Pivot Charts -- Creating Pivot Tables -- Creating a Pivot Chart -- Internet-Related Timesavers -- Saving Worksheets as Web Pages -- Saving Worksheets as Web Pages -- Creating Interactive Web Pages -- Importing Web Data into the Worksheet -- Capturing Information for the Spreadsheet with Web Queries -- Importing XML Data into a Worksheet -- Using Hyperlinks to Make Jumps in Workbooks -- Adding Hyperlinks to a Worksheet -- Following Links in a Worksheet -- Editing Links in a Worksheet -- Creating Hyperlinks for Custom Menus and Toolbars -- The Scary (Or Fun) Stuff -- Instant Lists in Excel 2003 -- Creating an Excel 2003 List -- Sorting and Filtering the List -- Toggling the List's Total Row On and Off -- Easy List Editing -- Sharing Excel Workbooks and Lists with a SharePoint Web Site -- Adding Excel Spreadsheets to the SharePoint Site -- Publishing Lists to the SharePoint Site -- Entering Data and Issuing Commands by Voice -- Hands-Free Data Entry -- Just Tell Me What to Do -- Sprucing Up Your Spreadsheets with Graphics -- Jazz It Up with Clip Art -- Adding Images from Graphics Files -- Drawing Objects for the Spreadsheet -- Doing Automated Table Lookups -- Looking Up a Single Table Value -- Doing a Two-Way Lookup in a Data Table -- Using Text Formulas for Fun and Profit -- Getting Right on the Case -- Joining Separate Text Entries Together -- Replacing Text Formulas with Their Results -- Creating Queries to Import Data from an External Database -- Setting Up the Data Source Definition -- Creating the Database Query -- Automating Repetitive Tasks with Macros -- Recording and Playing Back Macros -- Editing Macros in the Visual Basic Editor -- Creating Custom Functions to Use in Your Worksheets -- Creating Custom Functions -- Saving Custom Functions in an Excel Add-in.

Covering formulas, charts, data lists, macros, and versions 2000, 2002, and 2003, this book offers more than seventy easy-to-follow techniques that show both new and experienced Excel users how to save time and avoid tedious or redundant tasks. Bestselling author Greg Harvey includes information on customizing Excel’ s menus and toolbars; modifying Excel’ s editing settings; using add-ins, AutoCorrect, AutoFill, AutoFormat, and data validation; copying and moving data between worksheets; encryptin workbook files; creating external database queries; converting worksheet data and charts into Web pages; and much more. Written by Greg Harvey, one of the bestselling technology authors of all time, whose books have combined sales of more than four million copies A unique, two-column format makes it easy for readers to grasp and apply each technique– and begin working more efficiently