Skip to content

Excel 2002 for Dummies

Spend $50 to get a free DVD!

ISBN-10: 0764508296

ISBN-13: 9780764508295

Edition: 2001

Authors: Colin Banfield, John Walkenbach

List price: $21.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!


To remain competitive in a changing environment, organisations require spreadsheet software that helps them work efficiently with numerical data. New features in Microsoft Excel 2002 help users work with data quickly and share their results easily.
Customers also bought

Book details

List price: $21.99
Copyright year: 2001
Publisher: John Wiley & Sons, Incorporated
Publication date: 6/29/2001
Binding: Paperback
Pages: 240
Size: 5.90" wide x 8.50" long x 0.55" tall
Weight: 0.550
Language: English

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
Book Registration Information