Sams Teach Yourself Microsoft Office Excel 2003 in 24 Hours

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

ISBN: 9780672325519 | 0672325519
Cover: Paperback
Copyright: 9/12/2003

Sorry, this item is currently not available.

For readers who are new to Excel 11 and want to get up and running quickly,Sams Teach Yourself Microsoft Excel 2003 in 24 Hourswill do the trick. This book includes shortcuts and ways to accomplish the most common tasks in Excel. Readers are able to work at their own pace through the easily digestible, one-hour lessons. After completing the lessons, the reader will have a solid foundation of the basics and know the most efficient way to utilize the new version of Excel.

Introduction

(2)

Conventions Used in This Book

(2)

Part 1 Excel Basics

(132)

Hour 1 Getting Started

(22)

What Is Excel?

(2)

Store Your Data in Workbooks

(1)

Planning Strategies for Excel Worksheets

(1)

Starting Excel

(2)

Other Ways to Launch Excel

(2)

Looking at the Excel Screen

(2)

Rows and Columns Bind the Worksheet Together

(1)

Working with Toolbars

(4)

Displaying Other Toolbars

(2)

Placing Toolbars Where They Work for You

(1)

Using Excel Menus and Dialog Boxes

(1)

Working with Dialog Boxes

(1)

Examining the Task Pane

(2)

Types of Task Panes

(1)

Elements of a Task Pane

(2)

Getting the Most Out of Help

(4)

Getting Assistance When You Need It

(2)

Looking Up Help with the Table of Contents

(1)

Turning to the Web for More Answers

(1)

Moving Within a Workbook

(2)

Moving Within a Worksheet

(2)

Summary

(1)

Q & A

(1)

Hour 2 Entering Data

(22)

Typing Data in a Cell

(1)

Types of Excel Data

(1)

Entering Labels

(1)

Automating Your Work

(3)

AutoComplete Speeds the Entry Process

(1)

AutoFill Produces Amazing Results

(1)

Creating a Simple Spreadsheet

(1)

Entering Values

(2)

Adding Dates and Times

(2)

Copying from Cell to Cell

(6)

Selecting the Cells to Copy or Cut

(1)

Pasting the Copied or Cut Cells

(1)

Working with the Clipboard Task Pane

(1)

Drag It and Drop It

(2)

Making Changes to the Worksheet

(1)

Editing Cell Contents

(1)

Clearing Cell Contents

(1)

Inserting and Deleting Cells

(1)

Working with Rows and Columns

(3)

Summary

(1)

Q & A

(1)

Hour 3 Organizing Your Files

(14)

Saving Your Workbook

(1)

Navigating Through Files and Folders

(1)

Saving Your Work for the First Time

(3)

Exploring the Save As Dialog Box

(1)

Saving Your Work Later

(1)

Understanding Excel Filenames

(1)

File Extensions Tell a Tale

(1)

Protecting Your Work with AutoRecover

(1)

Saving an Existing Workbook with a New Name

(1)

Other Save Options

(3)

What About Backups7

(1)

Saving Workbook Summary Information

(2)

Rearranging Your Files

(2)

Deleting a File

(1)

Excel's Other File-Organization Tools

(1)

Summary

(1)

Q & A

(1)

Hour 4 Managing Your Files and Workbooks

(22)

Creating a Blank Workbook

(2)

Creating Workbooks with the New Workbook Task Pane

(1)

Opening an Existing Workbook

(2)

Different Open Options

(1)

Making Use of the Getting Started Task Pane

(2)

Searching for the Right File

(1)

Working with Workbooks and Worksheets

(1)

Getting a View of the Workbook

(1)

Using Ranges

(3)

Assigning Range Names

(2)

Editing Range Names

(1)

Changing Worksheet Views

(5)

Arranging Open Workbooks

(1)

Comparing Workbooks Side by Side

(1)

Zooming In and Out

(1)

Changing to Full-Screen View

(1)

Keeping Row and Column Headings Visible

(1)

Workbook and Worksheet Navigation Tools

(3)

Summary

(1)

Q & A

(2)

Hour 5 Letting Excel Do the Math

(18)

Why Use Formulas?

(1)

How Formulas Work

(4)

Mathematical Operators

(2)

Order of Operations

(2)

Creating a Simple Formula

(1)

Referencing Cells

(2)

Using AutoSum

(1)

Using Range Names in Formulas

(1)

Using Relative and Absolute Addressing

(3)

Working with Simple Functions

(1)

Copying Formulas

(2)

Troubleshooting Formula Errors

100

(1)

Summary

101

(1)

Q & A

101

(2)

Hour 6 Using Excel Templates

103

(10)

What Is a Template7

104

(1)

Exploring Excel Templates

104

(4)

Opening a Template

104

(2)

Changing the Template

106

(2)

Creating Your Own Template

108

(2)

Saving a Worksheet as a Template

110

(2)

Summary

112

(1)

Q & A

112

(1)

Hour 7 Printing Your Workbook

113

(22)

The Value of Hard Copy

113

(1)

Checking Your Spelling Before You Print

114

(4)

Working with AutoCorrect

117

(1)

Setting Up Your Page

118

(1)

Changing the Orientation and Paper Size

118

(3)

Changing the Page Margins

119

(2)

Printing Gridlines

121

(1)

Adding Headers and Footers

121

(4)

Doing Excel's Preset Headers and Footers

121

(2)

Creating Your Own Headers and Footers

123

(2)

Choosing What to Print

125

(2)

Selecting a Print Area

125

(1)

Printing the Column and Row Headings

126

(1)

Fitting Your Worksheet to a Number of Page

126

(1)

Controlling Where Pages Break

127

(1)

Setting a Manual Page Break

127

(1)

Printing What You Want

128

(5)

Checking Your Printer

129

(1)

Printing Your Worksheets

130

(1)

Printing a Range

131

(1)

Printing a Selection

Printing the Entire Workbook

131

(1)

Faxing a Workbook

132

(1)

Canceling Printing

132

(1)

Summary

133

(1)

Q & A

133

(2)

Part II Dress Up Your Work

135

(56)

Hour 8 Changing the Appearance of Text

137

(24)

Formatting Your Text

138

(1)

Treating Numbers Like Text

138

(1)

Using Fonts

139

(4)

Changing the Font Style

140

(1)

Changing the Font Size

141

(2)

Changing Cell Alignment

143

(2)

Types of Alignments

144

(1)

Rotating Cell Entries

145

(1)

Centering a Heading

146

(1)

Controlling the Flow of Text

147

(3)

Using Indents

147

(2)

Breaking Text into Multiple Lines

149

(1)

Copying Formatting with the Format Painter

150

(1)

Removing Formatting

151

(1)

Adjusting Column Width

152

(1)

Altering Row Height

153

(1)

Finding Data

154

(1)

Replacing Data

155

(1)

Working with Comments

156

(3)

Adding a Comment

157

(1)

Displaying a Comment

157

(1)

Editing a Comment

157

(2)

Deleting a Comment

159

(1)

Summary

159

(1)

Q & A

159

(2)

Hour 9 Changing the Look of Values

161

(16)

What Formats Are Available?

162

(1)

Choosing a Number Style

163

(3)

Using the Toolbar to Change Number Formats

163

(1)

Using the Format Cells Dialog Box

164

(2)

Working with Decimal Places

166

(1)

Establishing a Fixed Number of Decimal Places

166

(1)

Rounding Numbers

167

(1)

Designing Custom Numeric Formats

167

(2)

Formatting Conditionally

169

(1)

Hiding Zeros

170

(2)

Working with Dates

172

(3)

Understanding Date and Time Formats

172

(1)

Changing Date Formats

173

(1)

Creating Custom Date Formats

174

(1)

Summary

175

(1)

Q & A

175

(2)

Hour 10 Adding Borders, Colors, and Fills

177

(14)

Have It Your Way

177

(1)

Changing the Color of Cell Entries

178

(2)

Adding Borders to Cells and Ranges

180

(5)

Applying a Border

181

(2)

Using the Toolbar to Apply a Border

183

(1)

Adding Borders with the Draw Border Tools

184

(1)

Working with Fills, Shading, and Color

185

(3)

Adding Background Patterns and Colors with the Format Cells Dialog Box

185

(2)

Selecting a Fill Color from the Toolbar

187

(1)

Formatting with AutoFormat

188

(1)

Summary

189

(1)

Q & A

190

(1)

Part III Interactive Data Makes Your Worksheet Come Alive

191

(62)

Hour 11 Working with Graphics Objects

193

(24)

What Is a Graphics Object?

194

(1)

Why Use Graphics?

194

(1)

Using the Drawing Toolbar

194

(6)

Drawing a Shape

196

(2)

Adding an AutoShape

198

(2)

Adding Clip Art

200

(4)

Getting Clip Art from the Clip Art Task Pane

201

(2)

Visiting the Web

203

(1)

Other Sources for Clip Art

204

(1)

Adding Special Effects with WordArt

204

(3)

Creating a WordArt Object

204

(2)

Modifying a WordArt Object

206

(1)

Manipulating Graphics Objects

207

(5)

Moving Objects

207

(1)

Resizing Objects

208

(2)

Rotating Objects

210

(1)

Flipping Objects

211

(1)

Combining Multiple Objects

212

(4)

Positioning the Objects

213

(1)

Grouping Objects

214

(1)

Modifying a Grouped Object

215

(1)

Deleting Graphics Objects

216

(1)

Summary

216

(1)

Q & A

216

(1)

Hour 12 Adding a Chart

217

(24)

Why Use a Chart?

217

(1)

Chart Elements

218

(1)

Types of Charts

219

(1)

Creating Charts with the Chart Wizard

220

(5)

Selecting the Chart Type and Subtype

221

(1)

Choosing the Data Range and Series

221

(1)

Setting Chart Options

221

(1)

Choosing a Location for the Chart

222

(3)

Working with Charts

225

(6)

Working with the Chart Toolbar

226

(1)

Labeling Data Elements in the Chart

227

(1)

Deciding on the Elements of Your Chart

228

(2)

Selecting a Different Chart Type

230

(1)

Re-ordering Chart Series

230

(1)

Chart Formatting Techniques

231

(4)

Changing Chart Colors, Lines, Patterns, and Styles

231

(2)

Formatting an Axis

233

(1)

Changing Chart Views

234

(1)

Using Rotated Text on a Chart

235

(1)

Creating a Pie Chart

235

(3)

Making the Pie Chart 3-D Style

237

(1)

Pulling a Pie Slice from a Chart

237

(1)

Summary

238

(1)

Q & A

238

(3)

Hour 13 Other Types of Charts

241

(12)

Creating Other Chart Types

241

(5)

Creating an Org Chart

242

(1)

Modifying an Org Chart

243

(1)

Formatting an Org Chart

244

(1)

Creating a Picture Chart

245

(1)

Creating an Excel Diagram

246

(6)

Creating a Diagram

247

(2)

Modifying a Diagram

249

(1)

Formatting a Diagram

250

(2)

Summary

252

(1)

Q & A

252

(1)

Part IV Advanced Excel Techniques

253

(140)

Hour 14 Working Smarter

255

(38)

Working with Multiple Workbooks

255

(7)

Arranging Workbooks

256

(3)

Moving Between Workbooks

259

(1)

Copying Data Between Workbooks

260

(2)

Working with Formulas That Reference Other Workbooks and Worksheets

262

(1)

Creating Links Between Worksheets and Workbooks

263

(6)

Referencing Another Worksheet in a Formula

263

(2)

Linking Several Worksheets

265

(2)

Linking Workbooks

267

(1)

Updating Links

268

(1)

Customizing Excel

269

(10)

Customizing Toolbars

270

(2)

Changing Startup Options

272

(1)

Designing a Custom Toolbar

273

(3)

Editing an Existing Toolbar

276

(1)

Changing Menu Animations

277

(1)

Creating a Shortcut to a Workbook

277

(2)

Protecting Your Data

279

(6)

Locking Cells

279

(2)

Protecting a Worksheet

281

(1)

Protecting the Workbook

281

(2)

Hiding and Displaying Rows and Columns

283

(2)

Protecting Your Files

285

(3)

Setting a File Password

285

(2)

Creating a Read-Only File

287

(1)

Saving Your Workspace

288

(1)

Using Excel Add-ins

289

(1)

Determining Whether an Add-in Is Installed

289

(1)

Summary

290

(1)

Q & A

290

(3)

Hour 15 Using Functions

293

(24)

Advantages of Excel Functions

294

(1)

Understanding How Functions Work

294

(1)

Using the Insert Function Dialog Box and Formula Palette

295

(1)

Financial Functions

296

(9)

DDB

296

(1)

296

(1)

IPMT

297

(1)

NPER

298

(1)

NPV

299

(1)

PMT

299

(2)

PPMT

301

(3)

RATE

304

(1)

SLN

304

(1)

SYD

304

(1)

Date and Time Functions

305

(1)

DATEVALUE

305

(2)

DAY, MONTH, and YEAR

305

(1)

NOW

306

(1)

TIMEVALUE

306

(1)

WEEKDAY

306

(1)

Logical Functions

307

(4)

307

(2)

ISBLANK

309

(1)

ISERR

309

(1)

Is It True or False?

310

(1)

AND

310

(1)

311

(1)

NOT

311

(1)

How to Use Lookup Functions

311

(5)

VLOOKUP and HLOOKUP

312

(2)

Lookup Wizard

314

(2)

Summary

316

(1)

Q & A

316

(1)

Hour 16 Auditing and Validating Your Work

317

(18)

Auditing Workbooks

318

(9)

Understanding Dependents and Precedents

318

(1)

Using the Formula Auditing Toolbar

319

(1)

Using Error Checking

320

(1)

Using Tracer Arrows

321

(4)

Tracing Errors

325

(2)

Validating Input

327

(3)

Setting Validation Rules

327

(1)

Circling Invalid Data

328

(2)

Using Named Constants and Formulas

330

(2)

Using Constants

330

(1)

Using Formulas

331

(1)

Defining Label Ranges

332

(2)

Adding Names

333

(1)

Removing Names

333

(1)

Summary

334

(1)

Q & A

334

(1)

Hour 17 Analyzing Your Data

335

(12)

Using the Scenario Manager

335

(6)

Creating Scenarios

335

(4)

Hiding and Protecting Scenarios

339

(1)

Viewing a Scenario

339

(1)

Creating a Scenario Summary Report

340

(1)

Using the Goal Seek Tool

341

(5)

How the Goal Seek Tool Works

341

(2)

Using Goal Seek on Chart Data

343

(3)

Common Goal Seek Errors

346

(1)

Summary

346

(1)

Q & A

346

(1)

Hour 18 Working with Pivot Tables

347

(14)

What Is a Pivot Table?

341

(8)

A Pivot Table Example

348

(1)

Learning the PivotTable Lingo

349

(1)

Building a Pivot Table

350

(3)

Modifying a Pivot Table

353

(3)

Working with Pivot Table Reports

356

(1)

Building a PivotChart

357

(2)

Creating a Chart from PivotTable Report Data

359

(1)

Summary

360

(1)

Q & A

360

(1)

Hour 19 Integrating Excel with Other Office Applications

361

(14)

Using Objects in Excel

362

(5)

Object Linking

362

(2)

Object Embedding

364

(3)

Inserting Objects

367

(2)

Inserting an Object from the Menu

361

(8)

Using the Clipboard Task Pane

369

(1)

Using Hyperlinks with Other Office Documents

369

(3)

Creating the Hyperlink

370

(2)

Sending Your Document Via Email with Outlook

372

(1)

Sending to One Recipient

372

(1)

Sending to a Distribution List

373

(1)

Summary

373

(1)

Q & A

374

(1)

Hour 20 Automating Tasks with Macros and Smart Tags

375

(18)

What Is a Macro?

377

Creating a Macro

376

(5)

Naming the Macro

378

(1)

Selecting a Keyboard Shortcut

378

(1)

Describing the Macro

378

(1)

Recording the Macro

378

(3)

Saving the Macro

381

(1)

Running the Macro

381

(1)

Fixing Macro Errors

382

(3)

Looking at Macro Code

382

(1)

Editing the Macro

383

(1)

Fixing a Macro with Step Mode

384

(1)

Attaching a Macro to a Toolbar

385

(2)

Using a Macro in Other Workbooks

387

(1)

Understanding Macro Viruses

388

(1)

Working with Smart Tags

389

(2)

Summary

391

(1)

Q & A

391

(2)

Part V Creating and Using Databases in Excel

393

(34)

Hour 21 Building an Excel Database

395

(16)

Basic Database Concepts

395

(2)

Starting with a Plan

397

(1)

Structuring Your Database

397

(1)

Creating a Database

398

(1)

Entering and Adding Data

399

(4)

Working with a Data Form

399

(1)

Using the Form

400

(1)

Navigating Through Records in the Form

401

(1)

Adding Data Directly to the Worksheet

402

(1)

Searching for Data

403

(6)

Entering Matching Data Criteria

403

(1)

Clearing Criteria

404

(1)

Using Comparison Operators

405

(1)

Using AutoFilter

406

(3)

Saving the Database

409

(1)

Summary

409

(1)

Q & A

409

(2)

Hour 22 Working with Your Database

411

(16)

Working with Subtotals

411

(5)

Different Subtotaling Functions

414

(1)

Collapsing and Expanding a Subtotaled Database

415

(1)

Removing Subtotals

415

(1)

Using Advanced AutoFilter Functions

416

(2)

Setting a Criteria Range

418

(2)

Retrieving Data with the Query Wizard

420

(1)

Installing Microsoft Query

420

(1)

Choosing a Data Source

420

(3)

Filtering Data

421

(1)

Sorting Data

422

(1)

Saving Data Queries

423

(1)

Reusing Queries

424

(1)

Summary

424

(1)

Q & A

425

(2)

Part VI At the Office and on the Internet/Intranet

427

Hour 23 Sharing Your Work with Your Colleagues

429

(12)

What Is a Network?

429

(1)

Sharing Workbooks

430

(1)

Setting Up a Shared Workbook

430

(2)

Defining Workbook Options

432

(1)

Opening a Shared Workbook

432

(1)

Tracking Changes in Your Worksheet

433

(5)

Accepting or Rejecting Changes

433

(2)

Tracking Changes Onscreen

435

(2)

Tracking Changes in the Printed Copy

437

(1)

Summary

438

(1)

Q & A

438

(3)

Hour 24 Worksheets and the Web

441

What Is the Internet7

441

(2)

Intranet Versus Internet

442

(1)

Using Internet Explorer 6.0

443

(1)

Searching on the Web

443

(2)

Using the Web Toolbar

443

(1)

Opening a Web Page in Excel

444

(1)

Adding a Hyperlink to a Worksheet

445

(2)

Saving Excel Documents to the Web

447

(2)

Understanding HTML Formatting

447

(1)

Saving as a Web Document

447

(1)

Previewing Your Document in Web Page Preview

448

(1)

Posting Your Worksheet to the Web

449

(2)

Summary

451

(1)

Q & A

451

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

FREE SHIPPING

Rent More, Save More! Use code: BBRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Sams Teach Yourself Microsoft Office Excel 2003 in 24 Hours

Summary

Author Biography

Table of Contents

Supplemental Materials

FREE SHIPPING

Rent More, Save More! Use code: BBRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Sams Teach Yourself Microsoft Office Excel 2003 in 24 Hours

Summary

Author Biography

Table of Contents

Supplemental Materials

Digital License