Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Excel 2003 For Dummies: Quick Reference / Edition 1

Excel 2003 For Dummies: Quick Reference / Edition 1

by John Walkenbach

See All Formats & Editions

ISBN-10: 0764539876

ISBN-13: 2900764539878

Pub. Date: 09/23/2003

Publisher: Wiley

If you like your answers quick and your information up-to-date, look no further. With this concise, superbly organized reference, you'll quickly find just what you need to know about opening, saving, protecting, and recovering workbook files; adding, copying, and deleting worksheets; entering and editing data and text; creating formulas and functions; auditing,


If you like your answers quick and your information up-to-date, look no further. With this concise, superbly organized reference, you'll quickly find just what you need to know about opening, saving, protecting, and recovering workbook files; adding, copying, and deleting worksheets; entering and editing data and text; creating formulas and functions; auditing, formatting, printing, and a whole lot more.

Product Details

Publication date:
For Dummies Quick Reference Series
Edition description:

Table of Contents

What You Can Do: Create and Analyze Data
The Big Picture: Microsoft Office Excel 20031
What You See: The Excel Window2
What You See: Dialog Boxes4
Toolbar Table6
The Basics: Starting Excel8
The Basics: Getting Acquainted with Excel8
Navigating with the keyboard8
Navigating with the mouse9
Understanding the Excel menu bar9
The Basics: Getting Help11
The Basics: Creating an Empty Workbook File13
The Basics: Saving a Workbook File13
The Basics: Opening a Workbook File14
The Basics: Closing a Workbook File and Exiting Excel15
What You Can Do: Show Data Graphically17
What You Can Do: Import Data for Analysis18
Part IUsing Workbook Files1
Changing the Default File Location2
Creating Multiple Windows (Views) for a Workbook2
Deleting a Workbook File3
Opening Nonstandard Files4
Opening a non-Excel or older Excel file4
Opening a workspace file4
Protecting a Workbook File4
Recovering Workbook Files after a System Crash5
Saving Files7
Saving a workbook under a different name7
Saving a workbook in a different or older file format7
Saving a workspace file8
Switching among Open Workbooks9
Working with Workbook Templates9
Creating a workbook template9
Creating a workbook from a template10
Creating a default workbook template11
Part IIWorking with Worksheets13
Activating Worksheets14
Adding a New Worksheet14
Arranging Windows Automatically14
Changing a Worksheet's Name15
Coloring a Worksheet Tab15
Copying a Worksheet16
Deleting a Worksheet17
E-Mailing Worksheet Data17
Freezing Row or Column Titles18
Hiding and Unhiding a Worksheet19
Moving a Worksheet19
Protecting a Worksheet20
Publishing Your Worksheet Data to the Web21
Publishing your worksheet data to a Web page22
Republishing your worksheet data to the Web23
Splitting Panes24
Using Full-Screen View25
Zooming Worksheets25
Part IIIEntering and Editing Worksheet Data27
Copying Cells and Ranges28
Copying a cell to another cell or a range28
Copying a range to another range29
Copying data to another worksheet or workbook30
Copying multiple cells or ranges to another range31
Deleting Entire Rows and Columns32
Editing a Cell's Contents33
Entering Data into a Range35
Entering data into a specific range35
Entering the same data into a range of cells35
Entering Dates and Times36
Entering specific dates and times36
Entering the current date or time37
Entering Formulas37
Entering formulas manually38
Entering formulas by pointing38
Entering Text39
Entering text into cells39
Completing text entries by using AutoComplete40
Entering Values40
Entering values into cells41
Entering fractions41
Erasing Data in Cells and Ranges41
Filling a Series42
Entering a series of incremental values or dates43
Entering a series of text43
Inserting Decimal Points Automatically44
Inserting Entire Rows and Columns44
Moving Cells and Ranges45
Moving data to a new location in the same worksheet45
Moving data to a different worksheet or workbook46
Replacing the Contents of a Cell47
Searching and Replacing Data47
Searching for data48
Searching for and replacing data49
Selecting Cells and Ranges50
Selecting a cell50
Selecting a range50
Selecting noncontiguous ranges51
Selecting entire rows and columns51
Selecting a multisheet (3-D) range52
Transposing a Range52
Undoing Changes and Mistakes53
Validating Data Entry54
Part IVUsing Formulas and Functions57
Absolute, Relative, and Mixed References58
Add-In Functions58
Basic Formula Essentials59
Changing When Formulas Are Calculated60
Converting Formulas to Values61
Editing Functions in Formulas61
Entering Functions in Formulas62
Entering functions manually62
Using the Extended AutoSum tool63
Using the Insert Function dialog box64
Modifying a Range Reference Used in a Function65
Referencing Cells in Other Worksheets66
Part VCreating and Using Names67
Changing Names69
Creating Names69
Creating names by using the Define Name dialog box69
Creating names by using the Name Box70
Creating names automatically70
Creating multisheet names71
Creating a Table of Names72
Deleting Names72
Names in Formulas73
Applying names to existing cell references73
Pasting names into a formula74
Using row and column headers74
Using sheet-level names75
Naming Constants75
Redefining Name References76
Part VIAuditing Your Work77
Cell Comments79
Adding a cell comment79
Editing a cell comment79
Changing the looks of a cell comment79
Viewing cell comments80
Checking for Specific Worksheet Errors80
Checking for errors in the background81
Checking for errors manually81
Displaying Formulas in a Worksheet82
Evaluating Parts of a Formula83
Formula Error Values84
Handling Circular References85
Locating Errors by Selecting Special Cells86
Proofreading Your Worksheet Data87
Spell Checking88
Tracing Cell Relationships88
Tracing precedents and dependents89
Tracing formula error values90
Using the Watch Window90
Displaying and adding cells to the Watch Window91
Removing cells from the Watch Window92
Hiding the Watch Window92
Part VIIFormatting Your Data93
Adding Borders to a Cell or Range94
Aligning Cell Contents96
Setting horizontal and vertical alignment96
Indenting the contents of a cell96
Justifying (refitting) text across cells97
Wrapping text within a cell98
Applying Background Colors and Patterns99
Applying a Background Graphic99
Changing the Appearance of Text in Cells100
Changing fonts and text sizes100
Applying colors to text100
Changing text attributes101
Changing Text Orientation (Direction)101
Copying Formats102
Formatting Based on a Cell's Contents103
Formatting Numbers104
Using Excel's built-in number formats104
Creating custom number formats105
Formatting a Table Automatically106
Hiding Cell Contents106
Hiding and Unhiding Columns and Rows107
Hiding columns and rows107
Unhiding columns and rows107
Merging Cells108
Modifying Cell Size109
Changing column width109
Changing row height110
Using Named Styles111
Creating named styles111
Applying named styles112
Part VIIIPrinting Your Work113
Adjusting Margins114
Centering Printed Output115
Changing Default Print Settings by Using a Template115
Changing the Header or Footer116
Selecting a predefined header or footer116
Creating a custom header or footer116
Controlling Page Settings118
Changing page orientation118
Selecting paper size119
Scaling your printed output119
Specifying the beginning page number119
Dealing with Page Breaks120
Inserting manual page breaks120
Removing manual page breaks121
Previewing and adjusting page breaks121
Previewing Your Work122
Printing Cell Comments122
Printing Charts123
Printing Colors in Black and White124
Printing in Draft Quality124
Printing or Substituting Error Values124
Printing or Suppressing Gridlines125
Printing Row and Column Headings125
Selecting Global Print Options125
Printing noncontiguous ranges125
Printing selected pages126
Selecting a printer126
Setting the print area127
Specifying the data range to print127
Setting Print Titles128
Specifying Page Order128
Part IXCharting Your Data129
Adding Elements to a Chart130
Adding a new data series to a chart130
Adding a trendline to a data series131
Adding Fill Effects to a Chart132
Changing a Chart's Data Series132
Changing a Chart's Location133
Changing Chart Elements133
Changing a chart's scale133
Changing a chart's gridlines135
Changing data markers136
Changing the Chart Type137
Creating a Chart by Using the Chart Wizard137
Chart Wizard--Dialog box 1 of 4138
Chart Wizard--Dialog box 2 of 4139
Chart Wizard--Dialog box 3 of 4139
Chart Wizard--Dialog box 4 of 4140
Creating a Custom Chart Type140
Creating a Default Chart on a Chart Sheet141
Deleting a Chart Element or Data Series141
Displaying a Data Table in a Chart141
Displaying Data Labels in a Chart142
Formatting a Chart Element143
Handling Missing Data in a Chart144
Inserting and Modifying Chart Legends145
Adding a legend to a chart145
Adding titles to a chart legend145
Formatting a chart legend or legend entry146
Moving a Chart Element146
Rotating 3-D Charts147
Selecting a Chart Element147
Part XLinking and Consolidating Worksheets149
Consolidating Worksheets150
Consolidating by position or by matching labels150
Consolidating by using formulas151
Linking Workbooks152
Referencing cells in other workbooks152
Changing the source of links153
Severing (breaking) links153
Updating links154
Part XIWorking with Lists and External Data155
Accessing Advanced Filtering157
Setting up a criteria range for advanced filtering157
Performing advanced filtering158
Applying Database Functions with Lists159
Calculating Subtotals160
Filtering a List160
Filtering by using an Excel AutoFilter160
Filtering by using a custom AutoFilter162
Importing Data from a Text File163
Importing Data from the Web164
By using an existing Web query file164

Customer Reviews

Average Review:

Post to your social network


Most Helpful Customer Reviews

See all customer reviews