How to Do Everything With Microsoft Office 2003

, by Fuller, Laurie

Write a Review

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

ISBN: 9780072229370 | 0072229373
Cover: Paperback
Copyright: 9/25/2003

Buy New

In Stock Usually Ships in 24-48 Hours

$31.69

Summary

Author Biography

Supplemental Materials

Learn everything you need to know about Office 2003 from experienced trainer and best-selling author Laurie Ulrich. Find time-saving tips and tons of practical examples.

Acknowledgments

xix

Introduction

xxi

PART I Office 2003 Common Elements

CHAPTER 1 What's New in Office 2003

(14)

The New Office "Look"

(4)

The New Task Pane

(1)

Expanded Use of Smart Tags

(1)

Customizing the Display of Toolbars and Menus

(1)

Faxing via the Internet

(1)

Office Watson to the Rescue

(1)

The Picture Library

(1)

The XML Factor in Office 2003

(1)

What's New in Word

(2)

New and Improved in Excel

(1)

PowerPoint's Enhancements

(1)

Access Improvements

(1)

Outlook's New Features

(1)

Upgrade Considerations

(3)

CHAPTER 2 Common Office Features

(28)

Common Workspace Elements

(3)

Working with Office 2003 Toolbars

(2)

Using Toolbar Buttons

(1)

Displaying Different Toolbars

(1)

Moving Toolbars

(1)

Working with Office 2003 Menus

(1)

Making Menu Selections

(1)

Common Menu Elements

(1)

Using the Task Pane

(3)

Displaying the Various Task Panes

(1)

Turning Off the Task Pane

(1)

Working with Smart Tags Across the Office Suite

(1)

Using the Office 2003 Clipboard

(6)

Moving Content with the Cut Command

(1)

Sharing Content with the Copy Command

(1)

Pasting Clipboard Selections

(2)

Storing Multiple Clipboard Selections

(1)

Deleting Clipboard Content

(1)

Customizing the Clipboard Task Pane

(1)

Using the Paste Special Command to Insert Clipboard Content

(5)

Creating a Paste Link

(2)

Embedding Selections and Editing Tools

(2)

Working with Speech Recognition

(3)

Turning Speech On

(1)

Training the Speech Tools for Your Voice

(1)

Dictating Documents, Spreadsheets, and Presentations

(1)

Giving Commands Verbally

(1)

Getting the Office 2003 Help You Need

(3)

CHAPTER 3 Using Images in Documents, Worksheets, and Presentations

(20)

Inserting and Manipulating Graphics

(8)

Adding Images to Word Documents

(5)

Using the Picture Toolbar

(2)

Using Images in Excel Worksheets

(1)

Enhancing Presentations with Clip Art and Photos

(1)

Capturing Images Digitally

(1)

Taking a Tour of Office 2003's Picture Library

(5)

Creating Shortcuts to Your Images

(1)

Opening an Image

(1)

Renaming Images

(1)

Sharing Images via Email

(3)

Editing Your Digitally Captured Images

(5)

PART II Creating Documents with Word

CHAPTER 4 Building a Basic Document

(16)

Getting Started in Word

(4)

The Not-So-Blank Document

(2)

Starting with a Template

(2)

Typing Your Document Content

(3)

Working with Word Wrap

(1)

Working with Paragraph and Line Breaks

(2)

Navigating a Word Document

(3)

Moving Around with the Mouse

(1)

Keyboard Navigation Techniques

(2)

Selecting and Working with Text

(5)

Selecting Text via the Keyboard

(1)

Using Your Mouse to Select Text

(2)

Editing Your Text

(1)

Rearranging Words, Sentences, and Paragraphs

(3)

CHAPTER 5 Proofing, Printing, and Saving Documents

(20)

Proofing Word Documents

(3)

Handling Errors as You Type

(1)

Running the Spelling and Grammar Check

(1)

Making Automatic Corrections

(4)

Creating AutoCorrect Entries

(1)

Editing and Removing AutoCorrect Entries

(1)

Customizing the Proofing Tools

(2)

Customizing the Spell-Checking Process

(1)

Adjusting the Standards for Grammar Checking

(1)

Turning As-You-Type Proofing On and Off

(1)

Viewing Your Document's Readability Statistics

(1)

Printing Your Document

(2)

Saving Word Documents

(3)

Performing a First-Time Save

(2)

Updating a Saved File

(1)

Saving a Document with a New Name

(1)

Creating Document Templates

(4)

Building Template Content

(2)

Creating New Documents from Your Templates

(1)

Template Tips and Techniques

(2)

CHAPTER 6 Effective Document Formatting

101

(28)

Changing the Appearance of Text

102

(4)

Choosing the Right Font and Size

103

(1)

Applying Text Color

104

(1)

Applying Special Text Effects

105

(1)

Altering Text Position and Flow

106

(8)

Changing Paragraph Alignment

106

(1)

Indenting Text

107

(2)

Adjusting Line Spacing

109

(1)

Understanding Text-Flow Controls

110

(2)

Creating Lists

112

(2)

Working with Styles

114

(5)

Creating Styles

116

(2)

Locking Styles and Formatting to Prevent Changes to Your Templates

118

(1)

Customizing Page Layout

119

(3)

Setting New Page Margins

119

(1)

Adjusting Page Orientation

120

(1)

Changing Paper Size

121

(1)

Working with Tabs

122

(7)

Creating a Tabbed List

122

(1)

Using Word's Default Tabs

122

(1)

Setting Tabs from the Ruler

123

(2)

Using the Tabs Dialog Box

125

(1)

Setting Up Multiple Tabbed Lists in a Single Document

126

(1)

Editing Tab Settings

126

(1)

Adjusting Tab Positions

126

(1)

Changing Tab Stop Alignment

127

(2)

CHAPTER 7 Working with Long Documents

129

(14)

Inserting and Formatting Page Numbers

130

(1)

Working with Headers and Footers

131

(3)

Inserting Header and Footer Content

132

(2)

Creating a Table of Contents

134

(1)

Searching for and Replacing Document Content

135

(2)

Using Find to Move Through a Document

135

(1)

Replacing Text

136

(1)

Replacing Special Codes

136

(1)

Working with Columns

137

(6)

Building a Newsletter Document

138

(1)

Applying Columns to Existing Text

139

(1)

Setting Up Columns Before Typing

140

(1)

Customizing Columns

141

(1)

Setting Up Multiple Column Configurations in One Document

142

(1)

CHAPTER 8 Structuring Documents with Tables

143

(20)

Structuring Documents and Text with Tables

144

(5)

Building a Uniform Grid

144

(3)

Entering Table Content

147

(1)

Navigating a Table

148

(1)

Selecting Table Columns, Rows, and Cells

148

(1)

Formatting Tables

149

(6)

Resizing Columns and Rows

149

(2)

Adding and Deleting Columns and Rows

151

(1)

Splitting and Merging Cells

152

(1)

Applying Borders and Shading

153

(2)

Drawing a Freeform Table

155

(5)

Drawing Table Cells

155

(1)

Erasing Table Cell Walls

156

(1)

Working with the Tables and Borders Toolbar

157

(3)

Nesting Tables

160

(3)

CHAPTER 9 Creating Form Letters, Envelopes, and Labels with Mail Merge

163

(12)

Starting the Mail Merge Process

164

(1)

Creating a Form Letter

164

(3)

Creating Mailing Labels

167

(5)

Choosing the Right Label

168

(1)

Selecting Your Data Source

169

(1)

Merging Data with Your Labels

169

(3)

Printing Labels

172

(1)

Mail Merge Troubleshooting

172

(3)

PART III Crunching Numbers and Keeping Lists with Excel

CHAPTER 10 Building and Formatting Worksheets

175

(22)

Touring the Excel Interface

176

(1)

Starting a New Workbook

176

(5)

Understanding Worksheets

177

(3)

Navigating Worksheets

180

(1)

Entering Worksheet Content

181

(4)

Editing Cell Content

183

(1)

Selecting Cells, Blocks, Columns, and Rows

184

(1)

Inserting Rows and Columns

185

(1)

Saving Workbook Files

185

(3)

Saving a New Workbook

186

(1)

Saving a Workbook as a Template

186

(2)

Formatting Worksheet Content

188

(9)

Applying Numeric Formats

189

(1)

Changing Fonts and Sizes

190

(1)

Aligning Worksheet Content

191

(2)

Shading Worksheet Cells

193

(1)

Applying Borders

194

(1)

Copying Cell Formats

195

(2)

CHAPTER 11 Working with Formulas and Functions

197

(12)

Understanding Spreadsheet Calculations

198

(1)

Performing Quick Addition with AutoSum

199

(3)

Using the AutoSum Function

200

(1)

Pasting the AutoSum Function

200

(2)

Creating Simple Formulas from Scratch

202

(2)

Editing Formulas

203

(1)

Understanding Relative vs. Absolute Addressing

203

(1)

Controlling the Order of Operations

204

(2)

Using 3-D Formula References

205

(1)

Using Excel's Built-in Functions

206

(3)

CHAPTER 12 Building and Maintaining List Databases

209

(14)

Understanding Database Concepts

210

(2)

Database Terminology

210

(2)

Excel List Database Requirements

212

(1)

Building a List

212

(1)

Sorting by a Single Field

213

(1)

Sorting by Multiple Fields

213

(1)

Creating a Subtotal Report

214

(3)

Searching for Specific Records

217

(2)

Using AutoFilter to Locate and Display Records in a List

217

(1)

Setting Up Advanced Filters

218

(1)

PivotTable Basics

219

(4)

Building a PivotTable

219

(4)

CHAPTER 13 Charting Excel Data

223

(12)

Using Charts to Enhance Worksheets

224

(4)

Understanding Chart Types

224

(2)

Understanding Chart Elements

226

(2)

Building a Chart

228

(2)

Selecting Data for Charting

228

(1)

Setting Up a New Chart

228

(2)

Updating and Changing Charts

230

(5)

Changing Chart Types

232

(1)

Formatting a Chart

232

(1)

Editing Chart Text

233

(1)

Resizing and Moving Charts

233

(1)

Deleting Charts

233

(2)

CHAPTER 14 Printing and Publishing Worksheets

235

(14)

Printing Workbooks and Worksheets

236

(1)

Printing an Entire Workbook

237

(1)

Printing Individual Worksheets

238

(1)

Printing a Range of Cells

238

(1)

Controlling Page Breaks and Page Count

238

(3)

Working with Print Options

241

(1)

Setting Up Headers and Footers

242

(1)

Publishing Excel Content to the Web

243

(1)

Saving Your Worksheet as a Web Page

243

(6)

PART IV Creating Presentations with PowerPoint

CHAPTER 15 Planning and Building a Presentation

249

(18)

Planning Your Presentation

250

(1)

Organizing Your Presentation Content

251

(1)

The PowerPoint Environment

251

(1)

Deciding on a Presentation Template

252

(2)

Choosing Slide Layouts

254

(2)

Inserting New Slides

254

(1)

Deleting Slides

255

(1)

Inserting Slide Text

256

(3)

Working with Bulleted Text

256

(2)

Typing Paragraphs

258

(1)

Inserting Extra Text Boxes

259

(1)

Formatting Slide Text

259

(4)

Repositioning Text Objects

260

(1)

Aligning Text Objects

261

(1)

Resizing Text Objects

261

(2)

Saving a Presentation

263

(1)

Printing Your Slides

263

(4)

Printing Color Options

264

(1)

Creating Notes and Audience Handouts

265

(2)

CHAPTER 16 Enhancing a Presentation with Graphics and Charts

267

(14)

Using Graphics Effectively in a Presentation

268

(1)

Adding Clip Art and Photographs

268

(1)

Drawing and Manipulating Shapes and Lines

269

(2)

Drawing Shapes

270

(1)

Drawing Lines and Arrows

270

(1)

Formatting Graphic Elements

271

(2)

Applying Fills and Outlines

271

(1)

Typing in Shapes

272

(1)

Rotating Shapes and Lines

272

(1)

Aligning Graphic Objects

273

(1)

Changing the Stacking Order of Graphics and Drawn Objects

273

(1)

Grouping and Ungrouping Objects

273

(1)

Creating a PowerPoint Chart

273

(3)

Selecting a Chart Type

275

(1)

Customizing the Chart

275

(1)

Building an Organization Chart

276

(3)

Filling in the Chart Boxes

277

(1)

Adding New Boxes to the Chart

278

(1)

Formatting the Organization Chart

278

(1)

Creating a Diagram

279

(2)

CHAPTER 17 Building an Effective Multimedia Slide Show

281

(18)

Previewing Your Slide Show

282

(2)

Rearranging, Duplicating, and Deleting Slides

282

(2)

Applying Slide Transitions

284

(2)

Animating Individual Slide Elements

286

(3)

Animating Text

286

(2)

Animating a Bulleted List

288

(1)

Applying Animation to Charts and Diagrams

289

(1)

Making Pictures and AutoShapes Move

289

(1)

Setting Up a Slide Show

289

(1)

Inserting Links to Files, Presentations, and Web Content

290

(4)

Using Slide Elements as Hyperlinks

291

(1)

Working with Action Buttons

292

(2)

Publishing a Presentation for Use on the Web

294

(5)

PART V Managing Data with Access

CHAPTER 18 Getting Started with Access Databases

299

(18)

What Is a Database'?

300

(1)

Understanding Database Concepts

300

(1)

Understanding Database Objects

301

(1)

Viewing Objects in Your Database with the Database Window

301

(1)

Designing Tables to Store Your Data

301

(12)

What You Need to Know about Tables Before You Begin

303

(1)

Viewing a Table and Its Data

304

(1)

Creating a Table

305

(8)

How to Connect Tables with Relationships

313

(4)

Understanding Relationship Types

314

(1)

Creating Relationships

314

(3)

CHAPTER 19 Simplifying Data Entry with Forms

317

(14)

Creating a Form with the Form Wizard

319

(2)

How to See the Form Design and Data

319

(1)

Understanding Some Basic Form Concepts

320

(1)

Using the Form Wizard to Create a Form

320

(1)

Modifying Your Form

321

(6)

Managing the Controls on Your Form

321

(2)

Making a Pick List with the Combo Box Control

323

(2)

Adding a Title to Your Form

325

(1)

Changing the Appearance of Controls by Formatting

325

(2)

Entering Data in Your Form

327

(4)

Data-Entry Tips

327

(1)

Navigating Through Records

328

(3)

CHAPTER 20 Extracting Data with Queries

331

(12)

Understanding Query Types

332

(1)

Viewing Query Designs and Data

333

(1)

Using the Simple Query Wizard to Make a Select Query

333

(1)

Designing a Query in the QBE Grid

334

(6)

Ordering Your Records with the Sort Row

336

(2)

Writing Criteria to Select Specific Records

338

(2)

Selecting Data from Multiple Tables

340

(3)

CHAPTER 21 Documenting Your Data with Access Reports

343

(14)

Exploring Report-Development Options

344

(1)

Simplifying Report Design with the Report Wizard

344

(9)

Creating a Report with the Report Wizard

347

(5)

Changing the Margins to Fit More Data per Page

352

(1)

Printing Your Reports

353

(4)

PART VI Keeping in Touch and on Schedule with Outlook

CHAPTER 22 Communicating with Email

357

(24)

About Email Accounts

358

(2)

Touring the Outlook Interface

360

(1)

Working with Messages

361

(9)

Attaching Files to Messages

363

(1)

Working with Message Flags, Levels, and Receipts

364

(2)

Sending Your Message

366

(3)

Replying to Messages

369

(1)

Forwarding Messages

370

(1)

Formatting Email Messages

370

(3)

Setting a New Default Font

371

(1)

Choosing Stationery

371

(2)

Formatting Message Text

373

(1)

Working with Signatures

373

(3)

Creating a Signature

374

(1)

Establishing Signatures for Different Email Accounts

375

(1)

Creating Folders to Organize Email

376

(2)

Setting Up Inbox and Sent Items Folders

376

(1)

Moving Messages Between Folders

377

(1)

Deleting Messages

378

(1)

Filtering Junk Email

379

(2)

CHAPTER 23 Scheduling Tasks and Appointments

381

(14)

A Tour of the Outlook Calendar

382

(7)

Understanding Calendar Entries

384

(1)

Creating Appointments, Events, and Meetings

385

(3)

Scheduling a Meeting

388

(1)

Customizing the Calendar

389

(1)

Working with Tasks

390

(2)

Creating a New Task

390

(1)

Assigning Tasks

391

(1)

Printing Your Schedule

392

(3)

CHAPTER 24 Building a Contacts List

395

(12)

Working with Contacts

396

(6)

Entering a New Contact

397

(2)

Editing Contact Information

399

(2)

Contact Tracking

401

(1)

Printing Your Contacts List

402

(5)

PART VII Designing Web Pages with FrontPage

CHAPTER 25 Planning a Website

407

(12)

What Are Your Online Goals?

408

(2)

Personal and Family Websites

409

(1)

Sites that Advertise

409

(1)

Sites that Sell

409

(1)

Planning Your Site's Content

410

(4)

Understanding Graphic Requirements

410

(2)

Working Within Color Limitations on the Web

412

(1)

Gathering Your Graphic Images

412

(1)

Collecting Text Content

413

(1)

Building Your Website Blueprint

414

(5)

Creating a Site Map

415

(1)

Storyboarding Your Individual Page Content

416

(3)

CHAPTER 26 Building a Website

419

(20)

Getting Started with FrontPage

420

(1)

Starting a New Website

420

(4)

Adding Pages to Your Site

422

(1)

Rearranging the Site Structure

423

(1)

Applying a Theme to Your Website

424

(2)

Adding Page Banners

426

(1)

Inserting Navigation Bars

427

(2)

Adding Navigation Buttons to the Home Page

427

(2)

Adding Navigation Buttons to Subpages

429

(1)

Building Web Page Content

429

(5)

Inserting Text Content

430

(1)

Making Text Links to External Web Pages and Sites

430

(2)

Adding Images to Your Web Pages

432

(1)

Editing Images

432

(2)

Structuring Pages with Tables

434

(5)

Inserting a Table

435

(1)

Resizing Tables

436

(1)

Merging and Splitting Cells

436

(1)

Modifying Table Properties

436

(3)

CHAPTER 27 Posting Pages to the Web

439

(8)

Previewing Pages Through a Browser

440

(7)

Selecting a Preview Browser

440

(1)

Checking Your Site for Errors

441

(2)

Publishing Your Website

443

(4)

Index

447

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

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

How to Do Everything With Microsoft Office 2003

Summary

Author Biography

Table of Contents

Supplemental Materials