Stepping into Excel -- Start Excel -- Use the Start Menu to Load Excel -- Starting Excel -- Open a Workbook -- Opening a Workbook -- Add Identifying Information -- Find a Workbook -- Using Task Panes -- Personalize Excel -- Remove the Getting Started Task Pane -- Select a Toolbar to Display -- Show Toolbars on Two Rows -- Customize a Toolbar -- Using Toolbars -- Get Help -- Open Help -- Using Help -- Do Research -- End Your Excel Workbook -- Save a Workbook Automatically -- Save a Workbook Manually -- Save a Copy of Your Workbook -- Save a Workbook As a Template -- Close an Excel Session -- Entering and Editing Data -- Enter Data -- Enter Text -- Completing an Entry -- Enter Numeric Data -- Enter Dates -- Formatting Numbers -- Use Times -- Adding Data Quickly -- Edit Data -- Edit Cell Data -- Remove Cell Contents -- Selecting Cells and Ranges -- Copy and Paste Data -- Use Paste Special -- Find and Replace Data -- Verify Spelling -- Modify Automatic Corrections -- Formatting a Worksheet -- Work with Cells, Rows, and Columns -- Adding and Removing Rows, Columns, and Cells -- Adjust Row Height -- Adjust Column Width -- Hide and Unhide Rows and Columns -- Change Cell Borders -- Add a Background -- Add a Comment -- Change How Text Looks -- Use Fonts -- Using Comments -- Change Alignment and Orientation -- Use Styles -- Transfer Formatting -- Format Automatically -- Format Conditionally -- Arrange and Organize Worksheets -- Lock Rows and Columns -- Split a Worksheet -- View Worksheets from Multiple Workbooks -- Working with Worksheets -- Using Formulas and Functions -- Reference Cells -- Change Cell References in Formulas -- Change to R1C1 References -- Using Cell Reference Operators -- Name a Cell -- Go to a Named Cell -- Build Formulas -- Create a Formula -- Edit a Formula -- Move Formulas -- Copy Formulas -- Using Formulas -- Recalculate Formulas -- Use External References in Formulas -- Use Functions -- Enter a Function -- Using Functions -- Sum Numbers in Columns or Rows Quickly -- Find and Correct Errors -- Check for Errors -- Trace Precedent and Dependent Cells -- Watch a Cell -- Evaluate a Formula in Pieces -- Printing Data -- Set Up the Print Job -- Add Headers and Footers -- Formatting Headers and Footers -- Add Pictures to Headers and Footers -- Adjust Margins -- Select Page Orientation and Scaling -- Use Headings as Page Titles -- Choosing Worksheet Print Options -- Change the Order Pages Print -- Print Comments -- Choosing What to Print -- Print the Data -- Use Print Areas -- Preview the Print Job -- Output the Print Job -- Charting Data -- Build a Chart with the Chart Wizard -- Start the Chart Wizard -- Choose a Chart Type -- Select Data for Charting -- Modify Chart Items -- Choose a Chart Location -- Modify Existing Charts -- Create a Chart from the Chart Toolbar -- Selecting Chart Items -- Identify Items -- Add Titles -- Show or Hide Axes -- Add or Remove Gridlines -- Show or Hide a Legend -- Add Data Labels -- Display the Data Table -- Format Chart Items -- Add a Second Value Axis -- Create Your Own Chart Type -- Working with Charts -- Use Charts -- Add Pictures and Text -- Add a Trendline -- Print a Chart -- Work with Pie Charts -- Working with Graphics -- Add Graphics -- Add Pictures -- Organize Clip Art -- Use Clip Art -- Add AutoShapes -- Add Objects from Other Programs -- Working with Curves -- Add Special Effects to Text -- Create a Diagram -- Format and Modify Graphics -- Use Color Effects -- Using Handles and Borders to Change Graphics -- Resize and Rotate a Graphic -- Trim a Picture -- Positioning Graphics -- Combine Graphics by Grouping -- Create a Mirrored Image -- Keep Changes Intact -- Managing Data -- Build Lists -- Create a List -- Adding Rows and Columns to a List -- Enter and Manage Data Using a Form -- Locating Data Using a Form -- Add a Total Row -- Remove a List -- Validate Data -- Organize Data -- Sort Data by Columns -- Sort Data by Rows -- Create an AutoFilter -- Removing Filters -- Outline Data Automatically -- Outline Data by Grouping -- Add Styles to an Outline -- Using Outlines -- Acquire Data -- Convert Text to Data -- Add All Data from an Access Table -- Add Selective Data from an Access Table -- Get Data from the Web -- Change External Data -- Setting External Data Range Properties -- Analyzing and Sharing Data -- Get the Results You Want -- Use Goal Seek -- Compare Alternatives Using Scenarios -- Use Multiple Variables to Provide a Result -- Save Solver Results and Settings -- Changing Solver Settings -- Work with PivotTables -- Create a PivotTable -- Create the PivotTable Layout -- Using PivotTables -- Create a PivotTable Chart -- Work with Others -- Guard Workbooks with Passwords -- Using Passwords in a Shared Workbook -- Share a Workbook -- Merge Shared Workbooks -- Working with Changes in a Shared Workbook -- Protect a Shared Workbook -- Work with Views -- Protect Non-Shared Workbooks and Worksheets -- Extending Excel -- Use Excel with Web Technology -- Save or Publish a Workbook as a Web Page -- Save Workbook Items as a Web Page -- Publish Workbook Items -- Using Excel Interactive Web Pages -- Keep Web Pages Updated -- Package Excel Web Files -- Use Hyperlinks -- Plan for the Future -- Automate Excel -- Use Recorded Macros -- Edit a Macro -- Starting a Macro -- Communicate with Excel -- Listen to Excel -- Tell Excel What to Do.