| |
| |
The Big Picture: Microsoft Excel 2002 | |
| |
| |
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 | |
| |
| |
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: Show Data Graphically | |
| |
| |
What You Can Do: Import Web Data for Analysis | |
| |
| |
| |
Using Workbook Files | |
| |
| |
Changing the Default File Location | |
| |
| |
Creating Multiple Windows (Views) for a Workbook | |
| |
| |
Deleting a Workbook File | |
| |
| |
Opening Non-Standard 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 | |
| |
| |
| |
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 | |
| |
| |
| |
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 noncontinguous ranges | |
| |
| |
Selecting entire rows and columns | |
| |
| |
Selecting a multisheet (3-D) range | |
| |
| |
Transposing a Range | |
| |
| |
Undoing Changes and Mistakes | |
| |
| |
Validating Data Entry | |
| |
| |
| |
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 | |
| |
| |
| |
Creating and Using Names | |
| |
| |
Changing Names | |
| |
| |
Creating Names | |
| |
| |
Creating names by using the Define Name dialog box | |
| |
| |
Creating names 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 Names | |
| |
| |
| |
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 on 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 | |
| |
| |
| |
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 a Table Automatically | |
| |
| |
Formatting Based on a Cell's Contents | |
| |
| |
Formatting Numbers | |
| |
| |
Using Excel's built-in number formats | |
| |
| |
Creating custom number formats | |
| |
| |
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 | |
| |
| |
| |
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 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 | |
| |
| |
| |
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 | |
| |
| |
| |
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 | |
| |
| |
| |
Working with Lists and External Data | |
| |
| |
Accessing Advanced Filtering | |
| |
| |
Setting up a criteria range for advanced filtering | |
| |
| |
Performing advanced filtering | |
| |
| |
Calculating Subtotals | |
| |
| |
Filtering a List | |
| |
| |
Filtering by using an 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 | |
| |
| |
| |
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 | |
| |
| |
| |
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 | |
| |
| |
Book Registration Information | |