| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 noncontiguous 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 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |