Title -- Copyright -- Dedication -- Acknowledgments -- About the Author -- Contents at a Glance -- Contents -- Introduction -- How This Book Is Organized -- Who Should Read This Book? -- Added Advice to Make You a Pro -- PART I Building a Basic Worksheet -- 1 Exploring the Excel Screen -- Starting Excel -- Exploring the Worksheet Screen -- Working with the Task Pane -- Changing Task Panes -- Closing and Redisplaying the Task Pane -- Working with Menus -- Personalized Menus -- Shortcut Menus -- Using Toolbars -- Separating Toolbars -- Moving a Toolbar -- Hiding and Displaying Toolbars -- Moving around the Worksheet Screen -- Using the Mouse -- Using the Keyboard -- Accessing the Go To Command -- Using Excel Help -- 2 Creating a Simple Worksheet -- Entering Data -- Entering Labels -- Entering Values -- Entering Dates -- Saving a Worksheet File -- Saving a File the First Time -- Resaving a Worksheet -- Closing a Worksheet -- Enabling AutoRecover -- Opening an Existing File -- Displaying the Open Dialog Box -- Opening a Recently Used Worksheet -- E-Mailing a Worksheet -- Starting a New Worksheet -- 3 Editing a Worksheet -- Editing Data -- Replacing the Contents of a Cell -- Editing the Contents of a Cell -- Clearing Cell Contents -- Learning Selection Techniques -- Inserting Areas -- Inserting Columns -- Inserting Rows -- Inserting Cells -- Deleting Areas -- Deleting Columns -- Deleting Rows -- Deleting Cells -- Using Undo and Redo -- Undoing the Previous Step -- Redoing the Previous Step -- Undoing a Series of Actions -- Moving Data Around -- Cutting and Pasting Data -- Using Drag and Drop to Move Cells -- Copying Data -- Using the Office Clipboard -- Using the Fill Feature -- 4 Making the Worksheet Look Good -- Using AutoFormat -- Formatting Numbers -- Formatting Numbers with the Toolbar -- Adding Commas -- Formatting for Currency.

Formatting Percentages -- Changing the Decimal Point Values -- Formatting Numbers through the Menu -- Formatting Numbers -- Formatting Dates -- Formatting with Fonts -- Selecting a Typeface -- Selecting a Font Size -- Adding Bold, Underline, or Italics -- Working with Font Colors -- Setting Font Options Using the Format Dialog Box -- Adjusting Column Width -- Adjusting Row Height -- Setting Worksheet Alignment -- Adjusting Cell Alignment -- Setting Vertical Alignment -- Centering Headings -- Adding Cell Borders -- Adding Background Color -- Using Cell Patterns -- Copying Cell Formatting -- 5 Selecting Printing Options -- Setting Up the Pages -- Setting Up Margins -- Setting Page Orientation and Size -- Setting Other Printing Options -- Creating a Header or Footer -- Selecting a Print Area -- Printing a Worksheet -- Using Print Preview -- Printing the Worksheet -- PART II Working with Formulas and Larger Worksheets -- 6 Working with Formulas -- Creating Formulas -- Creating a Simple Formula -- Creating a Compound Formula -- Editing Formulas -- Copying Formulas -- Copying Using the Fill Feature -- Copying with Copy and Paste -- Creating an Absolute Reference in a Formula -- Viewing Formulas -- Understanding Common Formula Error Messages -- 7 Using Excel Functions -- Understanding Function Syntax -- Creating a Total with the SUM Function -- Entering a SUM Function -- Entering an Argument with the Keyboard -- Entering an Argument with the Mouse -- Using the AutoSum Button -- Using Other Functions -- Calculating with Mathematical Functions -- Using the INT Function -- Using the ROUND Function -- Analyzing with Statistical Functions -- Using the AVERAGE Function -- Using the MAX and MIN Functions -- Using the COUNT and COUNTA Functions -- Using Date Functions -- Using the NOW Function -- Finding the Difference between Two Dates.

Figuring with Financial Functions -- Using the PMT Function -- Understanding Logical Functions -- Using the IF Function -- Getting Help with Excel Functions -- 8 Working with Larger Workbooks -- Moving from Worksheet to Worksheet -- Inserting Worksheets -- Naming Worksheets -- Hiding a Worksheet -- Deleting Worksheets -- Creating a Reference to Another Worksheet -- Creating Links to Other Workbooks -- 9 Managing Larger Worksheets -- Modifying Worksheet Views -- Hiding Rows and Columns -- Splitting a Window -- Freezing Panes -- Using Zoom -- Working with Ranges -- Creating Range Names -- Using Range Names -- Using Find and Replace -- Locating Data with Find -- Replacing Entries -- PART III Adding Visual Interest -- 10 Working with Art Images -- Inserting Images -- Inserting Clip Art -- Inserting Saved Images -- Inserting Images from Your Camera -- Customizing Art -- Resizing Images -- Moving Art -- Cropping an Image -- Adding WordArt -- Making Adjustments to the WordArt -- Editing WordArt Text -- Changing WordArt Style -- Reshaping WordArt -- Deleting an Art Image -- 11 Creating Charts from Excel Data -- Creating a Chart -- Modifying a Chart -- Resizing a Chart -- Moving a Chart -- Changing a Chart Style -- Editing the Series Appearance -- Modifying Chart Text -- Working with Labels -- Placing the Legend -- Displaying the Data Table -- Deleting a Chart -- Removing a Chart from a Data Sheet -- Deleting a Chart on Its Own Sheet -- 12 Using the Drawing Toolbar -- Drawing Shapes -- Displaying the Drawing Toolbar -- Creating Lines and Arrows -- Choosing a Line Style -- Setting Arrow Heads -- Rotating and Resizing Lines -- Adding Text Boxes -- Working with AutoShapes -- Editing the Drawing Object -- Changing the Object Color and Fill -- Adding Text to AutoShapes -- Creating Shadows -- Making Shapes 3-Dimensional -- PART IV Analyzing Data.

13 Working with Data -- Sorting -- Sorting with the Toolbar Buttons -- Sorting with the Sort Dialog Box -- Sorting by Dates -- Using Filters -- Working with AutoFilter -- Creating Custom Filters -- Data Subtotals -- Conditional Formatting -- 14 Discovering Tools for Speed and Quality -- Checking the Spelling -- Working with AutoCorrect -- Activating AutoCorrect Features -- Adding AutoCorrect Entries -- Deleting AutoCorrect Entries -- Using the Excel Research Tools -- Navigating the Research Pane -- Translating Words -- Checking for Errors -- Understanding Smart Tags -- 15 Customizing Excel -- Setting Preferences -- Working with Templates -- Using a Predefined Template -- Saving a Template -- Editing a Template -- Deleting a Template -- PART V Integrating Excel Technology -- 16 Integrating Excel with Word -- Using Excel Worksheets in Word -- Creating an Excel Worksheet from Within Word -- Resizing the Excel Worksheet in Word -- Inserting an Existing Excel Worksheet into Word -- Inserting an Entire Workbook -- Copying a Workbook Portion -- Inserting Word Data into Excel -- Inserting Paragraphs -- Inserting Word Tables -- 17 Using Excel with Access -- Exporting an Access Table or Query to Excel -- Importing Excel Data into Access -- Beginning a Data Import from Excel to Access -- Importing Excel Data as a New Table -- Appending Excel Data to an Existing Table -- Linking an Excel Worksheet to Access -- 18 Collaborating with Others -- Working with Comments -- Adding a Comment -- Editing a Comment -- Editing Comment Contents -- Displaying a Comment Box -- Formatting a Comment Box -- Resizing a Comment Box -- Printing Comments -- Deleting a Comment -- Working with Revisions -- Tracking Revisions -- Examining Revisions -- Accepting or Rejecting Revisions -- Sharing a Workbook -- Securing a Workbook -- Protecting a Worksheet -- Removing Worksheet Protection.

Unprotecting Specific Worksheet Cells -- Preventing Others from Opening a Workbook -- A Excel Shortcut Keys -- Learning the Basic Shortcuts -- Working with Menus -- Getting Help -- Working with Workbook Files -- Working inside Workbooks -- Moving around a Workbook -- Typing and Editing Cell Data -- Selecting Ranges of Cells -- Formatting Data -- Miscellaneous Commands -- Glossary -- Index -- Numerics -- A -- B -- C -- D -- E -- F -- G -- H -- I -- K -- L -- M -- N -- O -- P -- Q -- R -- S -- T -- U -- V -- W -- Z.