Excel 97 For Windows<sup>®</sup> For Dummies<sup>®</sup> : Quick Reference: John Walkenbach: 9780764500602: Book: Computers: eCampus.com

The good news is that Microsoft Excel is out in a brand-new version with more features than ever before. The bad news is that this brand-new version contains plenty of new functions and commands to remember. So, to help you work productively with Excel 97 without being hindered by differences in its new functions, IDG Books Worldwide, Inc., presents Excel 97 For Windows For Dummies Quick Reference. In this book, you can find all the tips, shortcuts, commands, and quick solutions you need to get the most out of this latest update of your favorite spreadsheet software.

For quick answers to tough Excel questions, users need to look no further--this book has it all from beginning to advanced features and commands. It uncovers the most common features of Excel, ones users really need to know to get their work done. The book offers advice on how to protect a workbook file from being modified and how to copy the workbook to multiple members of a workgroup.

Introduction

(4)

How to Use This Book

(1)

This Book: Who Needs It?

(1)

Ways to use this book

(1)

How not to use this book

(1)

What the Little Pictures Mean

(2)

Part I: Getting to Know Excel 97

(10)

Excel: Behind the Scenes

(2)

The active cell and ranges

(1)

Navigational techniques

(1)

The Excel Screen

(1)

Introducing the Office Assistant

(1)

Excel Commands

(1)

Working with Dialog Boxes

(2)

Dialog box parts

(2)

Navigating through dialog boxes

(1)

Mousing Around with Toolbars

(1)

Actually Doing Things with Excel

(1)

Using Add-Ins

(1)

Part II: Using Workbook Files and Worksheets

(24)

Closing a Workbook

(1)

Creating an Empty Workbook File

(1)

Creating a Workbook from a Template

(1)

Creating a Workbook Template

(1)

Deleting a Workbook File

(1)

Exporting a Text File

(1)

Finding a Workbook File

(1)

Importing a Text File

(1)

Mailing a Workbook File

(1)

Opening a Non-Excel File

(1)

Opening a Workbook File

(1)

Protecting a Workbook File

(1)

Protecting a Worksheet

(1)

Routing (Sending) a Workbook

(1)

Saving a Workbook File

(2)

Saving a workbook under a different name

(1)

Saving a workbook file in an older Excel format

(1)

Saving your work automatically

(1)

Using a Default Worksheet Template

(1)

Using a Default Workbook Template

(1)

Using a Workspace File

(1)

Saving a workspace file

(1)

Opening a workspace file

(1)

Working with Worksheets

(10)

Adding a new worksheet

(1)

Arranging windows automatically

(1)

Changing a sheet's name

(1)

Changing a window's size (Maximizing, Minimizing, and Restoring)

(1)

Copying a worksheet

(1)

Creating multiple windows (views) for a workbook

(1)

Creating and using named views

(1)

Deleting a worksheet

(1)

Freezing row or column titles

(1)

Hiding and unhiding a worksheet

(1)

Moving a sheet

(1)

Moving and resizing windows

(1)

Moving around in a worksheet

(1)

Splitting panes

(1)

Using full screen view

(1)

Zooming worksheets

(1)

Part III: Formatting, Outlining, and Printing Your Work

(36)

Formatting Cells and Ranges

(1)

Adding borders to a cell or range

(1)

Aligning cell contents

(1)

Applying background colors and patterns

(1)

Applying a background graphic

(1)

Applying colors to text

(1)

Applying named styles

(1)

Changing column width

(1)

Changing the default font (typeface)

(1)

Changing fonts and text sizes

(1)

Changing row height

(1)

Changing text attributes

(1)

Changing text orientation (direction)

(1)

Copying formats

(1)

Creating custom number formats

(10)

Creating and modifying named styles

(1)

Formatting numbers

(1)

Formatting selected characters in a cell

(1)

Formatting based on a cell's contents

(1)

Hiding cells

(1)

Hiding columns and rows

(1)

Indenting the contents of a cell

(1)

Justifying (refitting) text across cells

(1)

Merging cells

(1)

Shrinking text to fit in a cell

(1)

Unhiding rows or columns

(1)

Using autoformats

(1)

Wrapping text within a cell

(1)

Outlining Your Worksheet

(4)

Creating an outline automatically

(1)

Creating an outline manually

(1)

Determining whether a worksheet is suitable for an outline

(1)

Expanding and contracting an outline

(1)

Hiding outline symbols

(1)

Removing an outline

(1)

Printing Your Work

(13)

Adjusting margins

(1)

Centering printed output

(1)

Changing default printing settings with a template

(1)

Changing the header or footer

(1)

Changing page orientation

(1)

Faxing from Excel

(1)

Inserting manual page breaks

(1)

Previewing and adjusting page breaks

(1)

Previewing your work

(1)

Printing cell comments

(1)

Printing colors in black and white

(1)

Printing in draft quality

(1)

Printing noncontiguous ranges

(1)

Printing or suppressing gridlines

(1)

Printing row and column headings

(1)

Printing selected pages

(1)

Removing manual page breaks

(1)

Scaling your printed output

(1)

Selecting a printer

(1)

Selecting paper size

(1)

Setting the print area

(1)

Setting print titles

(1)

Specifying the beginning page number

(1)

Specifying what to print

(1)

Spell checking

(1)

Part IV: Entering and Editing Worksheet Data

(28)

Copying Cells and Ranges

(3)

Copying a cell to another cell or a range

(1)

Copying data as a picture

(1)

Copying data to another worksheet or workbook

(1)

Copying formulas as values

(1)

Copying a range to another range

(1)

Editing a Cell's Contents

(1)

Entering Data into a Worksheet

(6)

Entering the current date or time into a cell

(1)

Entering data into a specific range

(1)

Entering dates and times

(1)

Entering formulas

(2)

Entering formulas using the formula palette

(1)

Entering fractions

(1)

Entering text into cells

(1)

Entering the same data into a range of cells

(1)

Entering values into cells

(1)

Erasing Data in Cells and Ranges

(1)

Moving Cells and Ranges

(2)

Moving by dragging

(1)

Moving data to a different worksheet or workbook

(1)

Moving data to a new location in the same worksheet

(1)

Replacing the Contents of a Cell

(1)

Searching for Data

(1)

Searching and Replacing Data

(1)

Selecting Cells and Ranges

(5)

Selecting a cell

(1)

Selecting entire rows and columns

(1)

Selecting a multisheet (3-D) range

(1)

Selecting noncontiguous ranges

(1)

Selecting a range

(1)

Special selections

(2)

Transposing a range

(1)

Undoing Changes and Mistakes

(1)

Using AutoComplete

(1)

Using AutoFill

(2)

Entering a series of incremental values or dates

(1)

Entering a series of text

(1)

Using Automatic Decimal Points

(1)

Using Cell Comments

(2)

Adding a cell comment

(1)

Editing a cell comment

100

(1)

Changing the looks of a cell comment

100

(1)

Viewing cell comments

101

(1)

Using Data Entry Forms

101

(1)

Using Excel's built-in data form

101

(1)

Validating Data Entry

102

(1)

Part V: Using Formulas and Functions

103

(26)

Consolidating Data

104

(3)

Consolidating data by matching labels

104

(1)

Consolidating data by position

105

(1)

Consolidating data by using formulas

105

(1)

Using the Consolidate dialog box

106

(1)

Using Formulas

107

(9)

Calculating subtotals

108

(1)

Changing the source of links

109

(1)

Changing when formulas are calculated

110

(1)

Converting formulas to values

111

(1)

Identifying formula errors

112

(1)

Pasting names into a formula

112

(1)

Referencing cells in other workbooks

113

(1)

Referencing cells in other worksheets

113

(1)

Servering (cutting) links

114

(1)

Updating links

114

(1)

Using absolute, relative, and mixed references

114

(1)

Using the Formula Palette

115

(1)

Using Functions in Your Formulas

116

(3)

Entering functions manually

116

(1)

Modifying a range reference used in a function

116

(1)

Using add-in functions

117

(1)

Using the Formula Palette to enter functions

118

(1)

Using Names

119

(7)

Applying names to existing cell references

120

(1)

Changing names

120

(1)

Creating names automatically

121

(1)

Creating names using the Name box

121

(1)

Creating names with the Define Name dialog box

122

(1)

Creating a table of names

122

(1)

Deleting names

123

(1)

Naming constants

123

(1)

Redefining names

124

(1)

Using multisheet names

124

(1)

Using row and column headers in formulas

124

(1)

Using sheet level names

125

(1)

Workbook Auditing

126

(3)

Handling circular references

126

(1)

Using Excel's auditing tools

127

(1)

Viewing formulas

128

(1)

Part VI: Analyzing Spreadsheet Data

129

(24)

Filtering and Sorting Lists

130

(9)

Applying database functions with lists

130

(2)

Filtering a list with autofiltering

132

(1)

Filtering a list with custom autofiltering

133

(1)

Performing advanced filtering

134

(1)

Setting up a criteria range for advanced filtering

135

(1)

Sorting a list

135

(2)

Using a custom sort order

137

(1)

Using an external database

137

(2)

Goal Seeking: Making a Formula Return a Desired Value

139

(1)

Performing What-If Analysis (Scenarios)

140

(4)

Creating a data table (one-input)

140

(1)

Creating a data table (two-input)

141

(1)

Creating a named scenario

142

(1)

Creating a scenario summary report

143

(1)

Displaying a named scenario

143

(1)

Pivot Tables

144

(7)

Creating a pivot table

144

(3)

Formatting a pivot table

147

(1)

Grouping pivot table items

147

(1)

Inserting a calculated field into a pivot table

148

(1)

Inserting a calculated item into a pivot table

149

(1)

Inserting a new field into a pivot table

150

(1)

Modifying a pivot table's structure

150

(1)

Refreshing a pivot table

150

(1)

Removing a field from a pivot table

151

(1)

Using the Analysis ToolPak Add-In

151

(2)

Using the Analysis ToolPak procedures

151

(1)

Using the Analysis ToolPak worksheet functions

152

(1)

Part VII: Charting, Mapping, and Drawing

153

(34)

Charting

154

(19)

Adding a new data series to a chart

154

(1)

Adding a trendline to a data series

154

(1)

Adding error bars to a data series

155

(1)

Adding fill effects to a chart

156

(1)

Changing a chart's data series

157

(1)

Changing a chart's scale

158

(1)

Changing a chart's gridlines

159

(1)

Changing a chart's location

160

(1)

Changing data markers

160

(1)

Changing the chart type

161

(1)

Changing the default chart type

162

(1)

Creating a custom chart type

162

(1)

Creating a default chart on a chart sheet

163

(1)

Deleting a chart element or data series

163

(1)

Displaying a data table in a chart

164

(1)

Displaying data labels in a chart

164

(1)

Handling missing data in a chart

165

(1)

Modifying a chart element

166

(1)

Moving a chart element

166

(1)

Printing charts

166

(1)

Rotating 3-D charts

167

(1)

Selecting a chart element

168

(1)

Using the Chart Wizard

169

(4)

Working with chart legends

173

(1)

Mapping

173

(6)

Activating a map

173

(1)

Adding and removing map features

173

(1)

Adding labels and text to a map

174

(1)

Adding new data to a map

175

(1)

Creating a map

175

(1)

Modifying a map legend

176

(1)

Setting the map formats(s)

177

(1)

Setting up data to be mapped

178

(1)

Updating a map

179

(1)

Drawing

179

(8)

Adding a drawing object to a worksheet

179

(1)

Adding a shadow to a drawing object

180

(1)

Aligning drawing objects

181

(1)

Changing the stack order of drawn objects

181

(1)

Controlling how objects interact with cells

181

(1)

Copying a drawing object

182

(1)

Deleting all drawing objects

183

(1)

Grouping and ungrouping objects

183

(1)

Making a drawing object three dimensional

183

(1)

Modifying drawing objects

184

(1)

Moving and resizing drawing objects

184

(1)

Rotating a drawing object

185

(1)

Selecting a group of drawing objects

185

(1)

Spacing drawing objects

185

(1)

Using graphic files

186

(1)

Part VIII: Using Excel with Other Applications

187

(10)

Copying and Pasting between Applications

188

(2)

Copying a chart or range of data from Excel to another application

188

(1)

Copying data from another application to Excel

188

(1)

Copying a graphic from another application to Excel

189

(1)

Splitting copied data into columns

190

(1)

Creating and Using Links between Applications

190

(3)

Creating a link to another document in Excel

190

(1)

Creating a link to Excel in another document

191

(1)

Deleting linked information

192

(1)

Reestablishing a link

192

(1)

Severing (ending) a link

193

(1)

Updating a link

193

(1)

Embedding Objects

193

(4)

Embedding a new object into a worksheet

194

(1)

Embedding an empty workbook into another application

195

(1)

Embedding an existing object into a worksheet

195

(1)

Embedding an existing workbook into another application

196

(1)

Glossary: Techie Talk

197

(6)

Index

203

Reader Response Card

Back of Book

About the Author John Walkenbach has been involved with computers for the past 25 years. He has written more than 250 articles and reviews for publications such as PC World, Windows, PC/Computing, and Info World. In addition, he's the best-selling author of more than a dozen books, including the Excel 97 for Windows Bible, Excel For Windows 95 Power Programming With VBA, and Excel Programming For Windows 95 For Dummies. John holds a Ph.D. in experimental psychology from the University of Montana, and has worked as an instructor, consultant, programmer, and market research manager for the largest S&L ever to fail (and he takes no responsibility for that). Currently, he heads JWalk and Associates, a small consulting firm in southern California. John also maintains "The Spreadsheet Page" on the World Wide Web (http://www.j-walk.com/ss). In his spare time, he likes to annoy his neighbors with loud blues guitar playing, and weird sounds from his synthesizers.


	Buy Textbooks Sell Textbooks College Apparel Shop by School Virtual Bookstores	Order Status Shipping Rates Return Policy Marketplace Info F.A.S.T.	Contact Us Privacy Policy Legal Notices Site Security Employment	Help Desk eCampus Blog Affiliate Program Bulk Orders College Marketing

Need Help? eService@ecampus.com Copyright© 1999-2008
.

Excel 97 For Windows® For Dummies® : Quick Reference

Excel 97 For Windows^® For Dummies^® : Quick Reference