Microsoft Excel 2003 Fast & Easy

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9781592000791 | 1592000797
Cover: Paperback
Copyright: 10/23/2003

Rent

(Recommended)

$12.52

Term

Due

Price

Semester

Dec 13

$13.18

Quarter

Aug 16

$12.52

Short Term

Jul 17

$11.87

*This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping cart.
Buy New

Currently Available, Usually Ships in 24-48 Hours

$15.76

Relax. Learning how to use Microsoft Office Excel 2003 is now a breeze. With this book's step-by-step instructions, you'll be managing your data in effective worksheets in no time. From storing simple data to creating complex calculations, "Microsoft Office Excel 2003 Fast & Easy" gives you the step-by-step instructions you need to complete your task quickly. Simply look and learn! Filled with screen shots and easy-to-follow instructions, "Microsoft Office Excel 2003 Fast & Easy" will get users of all levels up and running quickly.

Introduction

xix

PART I BUILDING A BASIC WORKSHEET

(102)

Chapter 1 Exploring the Excel Screen

(18)

Starting Excel

(1)

Exploring the Worksheet Screen

(12)

Working with the Task Pane

(2)

Working with Menus

(3)

Using Toolbars

(5)

Moving around the Worksheet Screen

(3)

Using the Mouse

(1)

Using the Keyboard

(1)

Accessing the Go To Command

(1)

Using Excel Help

(2)

Chapter 2 Creating a Simple Worksheet

(18)

Entering Data

(5)

Entering Labels

(2)

Entering Values

(1)

Entering Dates

(2)

Saving a Worksheet File

(3)

Saving a File the First Time

(2)

Resaving a Worksheet

(1)

Closing a Worksheet

(1)

Enabling AutoRecover

(2)

Opening an Existing File

(2)

Displaying the Open Dialog Box

(2)

Opening a Recently Used Worksheet

(1)

E-Mailing a Worksheet

(2)

Starting a New Worksheet

(2)

Chapter 3 Editing a Worksheet

(22)

Editing Data

(2)

Replacing the Contents of a Cell

(1)

Editing the Contents of a Cell

(1)

Clearing Cell Contents

(1)

Learning Selection Techniques

(1)

Inserting Areas

(4)

Inserting Columns

(1)

Inserting Rows

(1)

Inserting Cells

(1)

Deleting Areas

(2)

Deleting Columns

(1)

Deleting Rows

(1)

Deleting Cells

(1)

Using Undo and Redo

(2)

Undoing the Previous Step

(1)

Redoing the Previous Step

(1)

Undoing a Series of Actions

(1)

Moving Data Around

(4)

Cutting and Pasting Data

(2)

Using Drag and Drop to Move Cells

(2)

Copying Data

(1)

Using the Office Clipboard

(2)

Using the Fill Feature

(3)

Chapter 4 Making the Worksheet Look Good

(28)

Using AutoFormat

(2)

Formatting Numbers

(7)

Formatting Numbers with the Toolbar

(4)

Formatting Numbers through the Menu

(3)

Formatting with Fonts

(4)

Selecting a Typeface

(1)

Selecting a Font Size

(1)

Adding Bold, Underline, or Italics

(1)

Working with Font Colors

(1)

Setting Font Options Using the Format Dialog Box

(1)

Adjusting Column Width

(2)

Adjusting Row Height

(1)

Setting Worksheet Alignment

(5)

Adjusting Cell Alignment

(1)

Setting Vertical Alignment

(2)

Centering Headings

(1)

Adding Cell Borders

(1)

Adding Background Color

(1)

Using Cell Patterns

(2)

Copying Cell Formatting

(2)

Chapter 5 Selecting Printing Options

(14)

Setting Up the Pages

(7)

Setting Up Margins

(1)

Setting Page Orientation and Size

(1)

Setting Other Printing Options

(2)

Creating a Header or Footer

(3)

Selecting a Print Area

(1)

Printing a Worksheet

(4)

Using Print Preview

(2)

Printing the Worksheet

100

(2)

Part I Review Questions

102

(1)

PART II WORKING WITH FORMULAS AND LARGER WORKSHEETS

103

(76)

Chapter 6 Working with Formulas

105

(14)

Creating Formulas

106

(3)

Creating a Simple Formula

106

(2)

Creating a Compound Formula

108

(1)

Editing Formulas

109

(1)

Copying Formulas

110

(4)

Copying Using the Fill Feature

111

(1)

Copying with Copy and Paste

112

(2)

Creating an Absolute Reference in a Formula

114

(2)

Viewing Formulas

116

(1)

Understanding Common Formula Error Messages

117

(2)

Chapter 7 Using Excel Functions

119

(28)

Understanding Function Syntax

120

(1)

Creating a Total with the SUM Function

120

(5)

Entering a SUM Function

121

(3)

Using the AutoSum Button

124

(1)

Using Other Functions

125

(17)

Calculating with Mathematical Functions

126

(2)

Analyzing with Statistical Functions

128

(5)

Using Date Functions

133

(4)

Figuring with Financial Functions

137

(2)

Understanding Logical Functions

139

(3)

Getting Help with Excel Functions

142

(5)

Chapter 8 Working with Larger Workbooks

147

(12)

Moving from Worksheet to Worksheet

148

(1)

Inserting Worksheets

149

(1)

Naming Worksheets

150

(1)

Hiding a Worksheet

151

(2)

Deleting Worksheets

153

(1)

Creating a Reference to Another Worksheet

154

(2)

Creating Links to Other Workbooks

156

(3)

Chapter 9 Managing Larger Worksheets

159

(20)

Modifying Worksheet Views

160

(8)

Hiding Rows and Columns

160

(3)

Splitting a Window

163

(2)

Freezing Panes

165

(2)

Using Zoom

167

(1)

Working with Ranges

168

(4)

Creating Range Names

168

(3)

Using Range Names

171

(1)

Using Find and Replace

172

(5)

Locating Data with Find

172

(3)

Replacing Entries

175

(2)

Part II Review Questions

177

(2)

PART III ADDING VISUAL INTEREST

179

(54)

Chapter 10 Working with Art Images

181

(18)

Inserting Images

182

(5)

Inserting Clip Art

182

(2)

Inserting Saved Images

184

(1)

Inserting Images from Your Camera

185

(2)

Customizing Art

187

(4)

Resizing Images

187

(1)

Moving Art

188

(2)

Cropping an Image

190

(1)

Adding WordArt

191

(3)

Making Adjustments to the WordArt

194

(4)

Editing WordArt Text

194

(1)

Changing WordArt Style

195

(2)

Reshaping WordArt

197

(1)

Deleting an Art Image

198

(1)

Chapter 11 Creating Charts from Excel Data

199

(18)

Creating a Chart

200

(3)

Modifying a Chart

203

(11)

Resizing a Chart

203

(2)

Moving a Chart

205

(1)

Changing a Chart Style

206

(1)

Editing the Series Appearance

206

(3)

Modifying Chart Text

209

(4)

Displaying the Data Table

213

(1)

Deleting a Chart

214

(3)

Removing a Chart from a Data Sheet

214

(1)

Deleting a Chart on Its Own Sheet

215

(2)

Chapter 12 Using the Drawing Toolbar

217

(16)

Drawing Shapes

218

(7)

Displaying the Drawing Toolbar

218

(1)

Creating Lines and Arrows

219

(3)

Adding Text Boxes

222

(2)

Working with AutoShapes

224

(1)

Editing the Drawing Object

225

(6)

Changing the Object Color and Fill

225

(2)

Adding Text to AutoShapes

227

(1)

Creating Shadows

228

(1)

Making Shapes 3-Dimensional

229

(2)

Part III Review Questions

231

(2)

PART IV ANALYZING DATA

233

(54)

Chapter 13 Working with Data

235

(20)

Sorting

236

(6)

Sorting with the Toolbar Buttons

236

(1)

Sorting with the Sort Dialog Box

237

(3)

Sorting by Dates

240

(2)

Using Filters

242

(6)

Working with AutoFilter

243

(2)

Creating Custom Filters

245

(3)

Data Subtotals

248

(3)

Conditional Formatting

251

(4)

Chapter 14 Discovering Tools for Speed and Quality

255

(18)

Checking the Spelling

256

(2)

Working with AutoCorrect

258

(3)

Activating AutoCorrect Features

258

(2)

Adding AutoCorrect Entries

260

(1)

Deleting AutoCorrect Entries

261

(1)

Using the Excel Research Tools

261

(5)

Navigating the Research Pane

263

(2)

Translating Words

265

(1)

Checking for Errors

266

(2)

Understanding Smart Tags

268

(5)

Chapter 15 Customizing Excel

273

(14)

Setting Preferences

274

(2)

Working with Templates

276

(10)

Using a Predefined Template

276

(3)

Saving a Template

279

(2)

Editing a Template

281

(2)

Deleting a Template

283

(3)

Part IV Review Questions

286

(1)

PART V INTEGRATING EXCEL TECHNOLOGY

287

(64)

Chapter 16 Integrating Excel with Word

289

(16)

Using Excel Worksheets in Word

290

(6)

Creating an Excel Worksheet from Within Word

290

(3)

Resizing the Excel Worksheet in Word

293

(3)

Inserting an Existing Excel Worksheet into Word

296

(4)

Inserting an Entire Workbook

296

(3)

Copying a Workbook Portion

299

(1)

Inserting Word Data into Excel

300

(5)

Inserting Paragraphs

300

(2)

Inserting Word Tables

302

(3)

Chapter 17 Using Excel with Access

305

(16)

Exporting an Access Table or Query to Excel

306

(2)

Importing Excel Data into Access

308

(9)

Beginning a Data Import from Excel to Access

308

(3)

Importing Excel Data as a New Table

311

(4)

Appending Excel Data to an Existing Table

315

(2)

Linking an Excel Worksheet to Access

317

(4)

Chapter 18 Collaborating with Others

321

(30)

Working with Comments

322

(9)

Adding a Comment

322

(1)

Editing a Comment

323

(6)

Printing Comments

329

(1)

Deleting a Comment

330

(1)

Working with Revisions

331

(6)

Tracking Revisions

331

(2)

Examining Revisions

333

(1)

Accepting or Rejecting Revisions

334

(3)

Sharing a Workbook

337

(2)

Securing a Workbook

339

(11)

Protecting a Worksheet

339

(3)

Removing Worksheet Protection

342

(1)

Unprotecting Specific Worksheet Cells

343

(2)

Preventing Others from Opening a Workbook

345

(5)

Part V Review Questions

350

(1)

Appendix A Excel Shortcut Keys

351

(8)

Learning the Basic Shortcuts

352

(2)

Working with Menus

352

(1)

Getting Help

353

(1)

Working with Workbook Files

353

(1)

Working inside Workbooks

354

(5)

Moving around a Workbook

354

(1)

Typing and Editing Cell Data

355

(1)

Selecting Ranges of Cells

356

(1)

Formatting Data

357

(1)

Miscellaneous Commands

358

(1)

Glossary

359

(6)

Index

365

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Microsoft Excel 2003 Fast & Easy

Summary

Table of Contents

Supplemental Materials