Excel 2003 For Dummies: Quick Reference


If you’re using Excel 2003 and you’d rather be working on your projects instead of plodding through everything you could ever need to know (and may never need to know) about Excel, this is the reference for you. In a compact, info-packed, spiral-bound book that puts the facts you need at your fingertips, it covers the basics most Excel users need to know, including:

  • Opening, saving protecting, and recovering workbook files and using workbook ...
See more details below
Paperback (SPIRAL)
BN.com price
(Save 21%)$19.99 List Price
Other sellers (Paperback)
  • All (27) from $1.99   
  • New (8) from $7.39   
  • Used (19) from $0.00   
Sending request ...


If you’re using Excel 2003 and you’d rather be working on your projects instead of plodding through everything you could ever need to know (and may never need to know) about Excel, this is the reference for you. In a compact, info-packed, spiral-bound book that puts the facts you need at your fingertips, it covers the basics most Excel users need to know, including:

  • Opening, saving protecting, and recovering workbook files and using workbook templates
  • Adding, copying, and deleting worksheets, e-mailing worksheet data, and publishing worksheet data to the Web
  • Entering and editing data and text and working with cells and ranges
  • Creating formulas and functions
  • Creating and using names
  • Auditing, formatting, and printing your work
  • Charting your data
  • Analyzing data with pivot tables

Complete with concise, step-by-step explanations (most of which take less than one page) and lots of screen shots and tables, this no nonsense guide gets you working instead of searching or reading, A detailed index makes it easy to find what you need to know fast. Excel 2003 For Dummies is a practical, at-a-glance reference for any Excel user.

Read More Show Less

Product Details

  • ISBN-13: 9780764539879
  • Publisher: Wiley
  • Publication date: 9/23/2003
  • Series: For Dummies Quick Reference Series
  • Edition description: SPIRAL
  • Edition number: 1
  • Pages: 240
  • Sales rank: 1,560,507
  • Product dimensions: 5.88 (w) x 8.44 (h) x 0.27 (d)

Table of Contents

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.


Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)