Excel 2003 For Dummies Quick Reference

The Big Picture: Microsoft Office Excel 2003.

What You See: The Excel Window.

What You See: Dialog Boxes.

Toolbar Table.

The Basics: Starting Excel.

The Basics: Getting Acquainted with Excel.

Navigating with the keyboard.

Navigating with the mouse.

Understanding the Excel menu bar.

The Basics: Getting Help.

The Basics: Creating an Empty Workbook File.

The Basics: Saving a Workbook File.

The Basics: Opening a Workbook File.

The Basics: Closing a Workbook File and Exiting Excel.

What You Can Do: Create and Analyze Data.

What You Can Do: Show Data Graphically.

What You Can Do: Import Data for Analysis.

Part I: Using Workbook Files.

Changing the Default File Location.

Creating Multiple Windows (Views) for a Workbook.

Deleting a Workbook File.

Opening Nonstandard Files.

Opening a non-Excel or older Excel file.

Opening a workspace file.

Protecting a Workbook File.

Recovering Workbook Files after a System Crash.

Saving Files.

Saving a workbook under a different name.

Saving a workbook in a different or older file format.

Saving a workspace file.

Switching among Open Workbooks.

Working with Workbook Templates.

Creating a workbook template.

Creating a workbook from a template.

Creating a default workbook template.

Part II: Working with Worksheets.

Activating Worksheets.

Adding a New Worksheet.

Arranging Windows Automatically.

Changing a Worksheet’s Name.

Coloring a Worksheet Tab.

Copying a Worksheet.

Deleting a Worksheet.

E-Mailing Worksheet Data.

Freezing Row or Column Titles.

Hiding and Unhiding a Worksheet.

Moving a Worksheet.

Protecting a Worksheet.

Publishing Your Worksheet Data to the Web.

Publishing your worksheet data to a Web page.

Republishing your worksheet data to the Web.

Splitting Panes.

Using Full-Screen View.

Zooming Worksheets.

Part III: Entering and Editing Worksheet Data.

Copying Cells and Ranges.

Copying a cell to another cell or a range.

Copying a range to another range.

Copying data to another worksheet or workbook.

Copying multiple cells or ranges to another range.

Deleting Entire Rows and Columns.

Editing a Cell’s Contents.

Entering Data into a Range.

Entering data into a specific range.

Entering the same data into a range of cells.

Entering Dates and Times.

Entering specific dates and times.

Entering the current date or time.

Entering Formulas.

Entering formulas manually.

Entering formulas by pointing.

Entering Text.

Entering text into cells.

Completing text entries by using AutoComplete.

Entering Values.

Entering values into cells.

Entering fractions.

Erasing Data in Cells and Ranges.

Filling a Series.

Entering a series of incremental values or dates.

Entering a series of text.

Inserting Decimal Points Automatically.

Inserting Entire Rows and Columns.

Moving Cells and Ranges.

Moving data to a new location in the same worksheet.

Moving data to a different worksheet or workbook.

Replacing the Contents of a Cell.

Searching and Replacing Data.

Searching for data.

Searching for and replacing data.

Selecting Cells and Ranges.

Selecting a cell.

Selecting a range.

Selecting noncontiguous ranges.

Selecting entire rows and columns.

Selecting a multisheet (3-D) range.

Transposing a Range.

Undoing Changes and Mistakes.

Validating Data Entry.

Part IV: Using Formulas and Functions.

Absolute, Relative, and Mixed References.

Add-In Functions.

Basic Formula Essentials.

Changing When Formulas Are Calculated.

Converting Formulas to Values.

Editing Functions in Formulas.

Entering Functions in Formulas.

Entering functions manually.

Using the Extended AutoSum tool.

Using the Insert Function dialog box.

Modifying a Range Reference Used in a Function.

Referencing Cells in Other Worksheets.

Part V: Creating and Using Names.

Changing Names.

Creating Names.

Creating names by using the Define Name dialog box.

Creating names by using the Name Box.

Creating names automatically.

Creating multisheet names.

Creating a Table of Names.

Deleting Names.

Names in Formulas.

Applying names to existing cell references.

Pasting names into a formula.

Using row and column headers.

Using sheet-level names.

Naming Constants.

Redefining Name References.

Part VI: Auditing Your Work.

Cell Comments.

Adding a cell comment.

Editing a cell comment.

Changing the looks of a cell comment.

Viewing cell comments.

Checking for Specific Worksheet Errors.

Checking for errors in the background.

Checking for errors manually.

Displaying Formulas in a Worksheet.

Evaluating Parts of a Formula.

Formula Error Values.

Handling Circular References.

Locating Errors by Selecting Special Cells.

Proofreading Your Worksheet Data.

Spell Checking.

Tracing Cell Relationships.

Tracing precedents and dependents.

Tracing formula error values.

Using the Watch Window.

Displaying and adding cells to the Watch Window.

Removing cells from the Watch Window.

Hiding the Watch Window.

Part VII: Formatting Your Data.

Adding Borders to a Cell or Range.

Aligning Cell Contents.

Setting horizontal and vertical alignment.

Indenting the contents of a cell.

Justifying (refitting) text across cells.

Wrapping text within a cell.

Applying Background Colors and Patterns.

Applying a Background Graphic.

Changing the Appearance of Text in Cells.

Changing fonts and text sizes.

Applying colors to text.

Changing text attributes.

Changing Text Orientation (Direction).

Copying Formats.

Formatting Based on a Cell’s Contents.

Formatting Numbers.

Using Excel’s built-in number formats.

Creating custom number formats.

Formatting a Table Automatically.

Hiding Cell Contents.

Hiding and Unhiding Columns and Rows.

Hiding columns and rows.

Unhiding columns and rows.

Merging Cells.

Modifying Cell Size.

Changing column width.

Changing row height.

Using Named Styles.

Creating named styles.

Applying named styles.

Part VIII: Printing Your Work.

Adjusting Margins.

Centering Printed Output.

Changing Default Print Settings by Using a Template.

Changing the Header or Footer.

Selecting a predefined header or footer.

Creating a custom header or footer.

Controlling Page Settings.

Changing page orientation.

Selecting paper size.

Scaling your printed output.

Specifying the beginning page number.

Dealing with Page Breaks.

Inserting manual page breaks.

Removing manual page breaks.

Previewing and adjusting page breaks.

Previewing Your Work.

Printing Cell Comments.

Printing Charts.

Printing Colors in Black and White.

Printing in Draft Quality.

Printing or Substituting Error Values.

Printing or Suppressing Gridlines.

Printing Row and Column Headings.

Selecting Global Print Options.

Printing noncontiguous ranges.

Printing selected pages.

Selecting a printer.

Setting the print area.

Specifying the data range to print.

Setting Print Titles.

Specifying Page Order.

Part IX: Charting Your Data.

Adding Elements to a Chart.

Adding a new data series to a chart.

Adding a trendline to a data series.

Adding Fill Effects to a Chart.

Changing a Chart’s Data Series.

Changing a Chart’s Location.

Changing Chart Elements.

Changing a chart’s scale.

Changing a chart’s gridlines.

Changing data markers.

Changing the Chart Type.

Creating a Chart by Using the Chart Wizard.

Chart Wizard — Dialog box 1 of 4.

Chart Wizard — Dialog box 2 of 4.

Chart Wizard — Dialog box 3 of 4.

Chart Wizard — Dialog box 4 of 4.

Creating a Custom Chart Type.

Creating a Default Chart on a Chart Sheet.

Deleting a Chart Element or Data Series.

Displaying a Data Table in a Chart.

Displaying Data Labels in a Chart.

Formatting a Chart Element.

Handling Missing Data in a Chart.

Inserting and Modifying Chart Legends.

Adding a legend to a chart.

Adding titles to a chart legend.

Formatting a chart legend or legend entry.

Moving a Chart Element.

Rotating 3-D Charts.

Selecting a Chart Element.

Part X: Linking and Consolidating Worksheets.

Consolidating Worksheets.

Consolidating by position or by matching labels.

Consolidating by using formulas.

Linking Workbooks.

Referencing cells in other workbooks.

Changing the source of links.

Severing (breaking) links.

Updating links.

Part XI: Working with Lists and External Data.

Accessing Advanced Filtering.

Setting up a criteria range for advanced filtering.

Performing advanced filtering.

Applying Database Functions with Lists.

Calculating Subtotals.

Filtering a List.

Filtering by using an Excel AutoFilter.

Filtering by using a custom AutoFilter.

Importing Data from a Text File.

Importing Data from the Web.

By using an existing Web query file.

By creating a new Web query.

Refreshing Imported Data.

Sorting a List.

Sorting numerically or alphabetically.

Using a custom sort order.

Part XII: Goal Seeking and What-If Analysis.

Creating Data Input Tables.

Creating a one-input table.

Creating a two-input table.

Goal Seeking.

Using Scenario Manager.

Creating a named scenario.

Creating a scenario summary report.

Displaying a named scenario.

Part XIII: Analyzing Data with PivotTables.

Adding and Removing Fields in a PivotTable Report.

Inserting a new field.

Removing a field.

Creating a PivotTable Report.

Formatting a PivotTable Report.

Grouping PivotTable Items.

Modifying a PivotTable’s Structure.

Refreshing a PivotTable Report.

Glossary: Tech Talk.

Index.