Microsoft Office 2003: the Complete Reference

Name: Microsoft Office 2003: the Complete Reference
Availability: OutOfStock
ISBN: 9780072229950

ISBN-10: 0072229950

ISBN-13: 9780072229950

Edition: 2nd 2003 (Revised)

Authors: Jennifer Ackerman Kettell, Guy Hart-Davis, Curt Simmons

List price: $39.99

30 day, 100% satisfaction guarantee!

Out of stock

We're sorry. This item is currently unavailable.

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

This guide details application features as well as integration options to help users get the most out of Office 2003. You'll learn how to use all of the new features in Office 2003, how to secure your files, work with XML and the Tablet PC and much more.

Book details

List price: $39.99
Edition: 2nd
Copyright year: 2003
Publisher: McGraw-Hill Osborne
Publication date: 9/25/2003
Binding: Paperback
Pages: 904
Size: 7.30" wide x 9.10" long x 1.88" tall
Weight: 3.234
Language: English

Curt Simmons , MCP, MCTS, is a technology consultant and trainer. He is the author of more than 50 computing titles, including How to Do Everything with Windows XP and MCSE Windows XP Professional Study Guide .

Acknowledgments	p. xxxv
Introduction	p. xxxvii
Common Office 2003 Elements
Getting to Know Office 2003	p. 3
The Office Suite of Programs	p. 3
Installing Office 2003	p. 12
Getting Office Help	p. 15
Customizing the Office Environment	p. 17
Customizing Toolbars and Menus	p. 17
Setting Smart Tag Options	p. 23
AutoCorrect, Spell Checking, and Grammar Checking	p. 24
Improving Accessibility	p. 34
Using Office on Tablet PCs	p. 34
Managing Files in Office	p. 37
Choosing Where to Store Your Files and Templates	p. 37
Using Office over a Network	p. 39
Using Office over the Internet	p. 42
Creating Files	p. 43
Finding Files	p. 45
Using Office's Recovery Options Effectively	p. 50
Text Tools	p. 55
Entering Text	p. 55
Formatting Text	p. 64
Cutting, Copying, and Pasting	p. 67
Selecting Text	p. 70
Applying Paragraph Formatting	p. 72
Using Find and Replace	p. 74
Drawing and Graphics Tools	p. 77
How the Office Applications Handle Pictures	p. 77
Inserting Clip Art	p. 78
Working with Shapes, AutoShapes, and WordArt	p. 82
Adding Graphics to Your Documents	p. 93
Importing Pictures from Scanners and Cameras	p. 95
Charts and Diagrams	p. 97
Word Processing
Word	p. 105
Word Task Pane	p. 105
Customizing Word Options	p. 107
Document Views	p. 112
Navigating in Word	p. 119
Printing Word Documents	p. 122
Editing Text	p. 125
Automatic Text Tools	p. 125
Undo and Redo	p. 131
Text Formatting	p. 131
Adding Special Characters	p. 135
Bullets and Numbering	p. 137
Document Formatting	p. 145
Paragraph Formatting	p. 145
Indentation	p. 149
Margins and Page Orientation	p. 153
Page and Section Breaks	p. 154
Headers and Footers	p. 157
Page Numbering	p. 159
Reusable Formatting with Styles and Templates	p. 161
AutoFormatting	p. 161
Paragraph and Character Styles	p. 164
Templates	p. 170
The Style Gallery	p. 175
Themes	p. 176
Tables and Columns	p. 181
Tables	p. 181
Creating Tables	p. 182
Manipulating Tables	p. 185
Formatting Table Content	p. 189
Columns	p. 192
Hyphenation	p. 195
Advanced Page Layout in Word	p. 197
Borders, Boxes, and Shading	p. 198
Page Fills and Backgrounds	p. 201
Text Boxes	p. 204
Automating Information with Fields	p. 207
Field Basics	p. 207
Common Fields	p. 213
Creating Forms	p. 215
Managing Long Documents	p. 221
Outlining	p. 221
Using Bookmarks in Long Documents	p. 224
Creating a Master Document	p. 225
Generating a Table of Contents	p. 228
Creating an Index	p. 230
Cross-References	p. 234
Adding Footnotes	p. 235
Mail Merge, labels, and Envelopes	p. 237
Using the Letter Wizard	p. 237
Mail Merges	p. 238
Generating Envelopes	p. 244
Creating Labels	p. 246
Spreadsheets
Excel	p. 251
Using and Hiding the Task Pane	p. 251
Customizing Excel Options	p. 252
Using Worksheets and Workbooks	p. 257
Understanding the Excel Screen	p. 258
Navigating in Workbooks and Selecting Objects	p. 258
Entering Data in Your Worksheets	p. 264
Improving Your View with Hiding, Splits, Extra Windows, Zooming, and Freezing	p. 268
Converting from Other Formats	p. 269
Printing Worksheets	p. 270
Formatting Worksheets and Restricting Data	p. 277
Adding, Deleting, and Manipulating Worksheets	p. 277
Formatting Cells and Ranges	p. 279
Restricting Data and Protecting Workbooks	p. 293
Using AutoFill	p. 300
Find and Replace	p. 302
Calculating with Formulas and Functions	p. 305
Understanding What Formulas and Functions Are	p. 305
Troubleshooting Formulas	p. 312
Entering Functions	p. 315
Monitoring Calculations with the Watch Window	p. 319
Working with Array Formulas	p. 319
Goal Seeking	p. 320
Using the Solver	p. 321
Examples of Functions in Action	p. 323
Viewing and Manipulating Data with Charts and PivotTables	p. 331
Working with Charts	p. 331
Working with PivotTables	p. 344
Working with PivotCharts	p. 352
Creating a Conventional Chart from PivotTable Data	p. 353
Creating Excel Databases	p. 357
Creating a Database	p. 357
Entering Data in Your Database	p. 359
Sorting	p. 361
Finding and Replacing Data in Databases	p. 363
Filtering	p. 363
Linking to an External Database	p. 367
Performing Web Queries	p. 373
Presentations
PowerPoint	p. 377
Exploring the PowerPoint Interface	p. 377
Starting a Presentation	p. 382
Browsing a Presentation	p. 386
Saving a Presentation	p. 387
Creating and Editing Slides	p. 389
Working with Slides	p. 389
Editing Slides	p. 391
Formatting Text	p. 392
Formatting Paragraphs	p. 394
Formatting Bullets and Numbering	p. 395
Adjusting a Placeholder Box	p. 397
Managing Placeholder Layout	p. 398
Checking Spelling and AutoCorrect Options	p. 399
Inserting a Table	p. 399
Inserting a Chart	p. 401
Inserting an Organization Chart	p. 403
Inserting a Text Box	p. 404
Inserting an Object	p. 405
Inserting a Hyperlink	p. 405
Adding Graphics, Multimedia, and Special Effects to Slides	p. 407
Insert Clip Art and Photos	p. 407
Using Draw Tools	p. 414
Create Shapes	p. 422
Inserting Multimedia Content	p. 427
Showing Your PowerPoint Presentations	p. 429
Transitions and Animation	p. 429
Getting Ready for Your Presentation	p. 432
Printing Speaker Notes and Audience Handouts	p. 436
Schedule and Contact Management
Outlook	p. 443
A First Look at Outlook	p. 443
Using Outlook's Toolbars	p. 446
Using Categories	p. 448
Data File Management	p. 448
Importing and Exporting Data	p. 450
Archiving Data	p. 451
Outlook E-mail	p. 453
Setting Up a Mail Account	p. 453
Sending and Receiving E-mail	p. 454
Configuring E-mail Options	p. 460
Managing Mail	p. 464
Outlook Calendar and Task Lists	p. 467
Outlook Calendar	p. 467
Using Tasks	p. 474
Managing Contacts and Taking Notes	p. 479
Outlook Contacts	p. 479
Taking Notes	p. 484
Scheduling and Planning with Others	p. 487
Sharing Your Calendar	p. 487
Working with Scheduled Meetings and Appointments	p. 489
Databases
Databases in Access	p. 495
Access Components	p. 495
Creating a Database	p. 497
Creating a Project	p. 499
Upsizing a Database	p. 500
Importing and Exporting Data	p. 501
Database Objects	p. 504
The Database Window	p. 506
Customizing Access	p. 508
Defining and Developing Tables	p. 513
Creating Tables	p. 514
Entering Fields	p. 517
Setting Field Properties	p. 519
Data Normalization	p. 526
Creating Queries	p. 531
Query Types	p. 531
Query Wizards	p. 540
Working in Query Design View	p. 545
SQL Queries	p. 547
Forms and Reports	p. 551
Forms	p. 551
Reports	p. 561
Building a Database Application	p. 567
Using a Database Application Wizard	p. 567
Building Applications from Scratch	p. 569
Switchboards	p. 569
Customizing the User Interface	p. 572
Making Data Available	p. 576
Web and Print Layout
Designing Pages and Sites in FrontPage	p. 581
Creating a New FrontPage Site	p. 581
Getting Around in FrontPage	p. 588
Working with Pages in FrontPage	p. 592
Creating a New Theme	p. 620
Advanced Management Features and Web Site Publishing	p. 627
Working with HTML in FrontPage	p. 627
Working with Forms and Form Input	p. 632
Managing Browser Compatibility	p. 645
Publishing Sites and Pages	p. 647
Using Reports to Manage Your Web Site	p. 652
Creating Publications in Publisher	p. 659
Creating Publications with Templates	p. 659
Creating Custom Publications	p. 661
Publishing Documents in Publisher	p. 673
Printing on Your Home or Office Printer	p. 673
Working with Professional Printers	p. 673
Publishing to the Web	p. 677
Integration and Collaboration
Using Office Applications Together	p. 681
Using the Clipboard	p. 681
Embedding and Linking Objects	p. 682
Using Office's XML Capabilities	p. 688
Using Office on the Web	p. 713
HTML and Round Tripping	p. 713
Understanding the File Formats Available	p. 714
Publishing Documents on the Web	p. 715
Using Hyperlinks in Office Documents	p. 715
Choosing Web Options	p. 716
Saving a File as a Web Page	p. 719
Collaboration Using Office Tools and SharePoint Team Services	p. 725
Review Tools	p. 725
Securing Documents	p. 736
Working with Comments	p. 738
Sending Documents in E-mail	p. 741
Using SharePoint Team Services	p. 747
Macros and Visual Basic for Applications
Creating and Using Office Macros	p. 755
Understanding Macros	p. 755
Understanding Office's Macro Virus-Protection Features	p. 756
Recording Macros	p. 760
Testing and Running Your Macros	p. 762
Storing Your Macros	p. 765
Recording the Sample Macros	p. 767
Using Visual Basic for Applications with Office	p. 771
Understanding VBA	p. 771
VBA Projects and Their Components	p. 773
Using the Visual Basic Editor	p. 774
Running Code	p. 781
Managing Your Macros, Modules, Userforms, and Classes	p. 784
Examining the Recorded Macros	p. 785
Putting VBA and Macros to Work	p. 789
Working with Variables	p. 789
Making Decisions with If and Select Case	p. 792
Using Message Boxes and Input Boxes	p. 794
Using Loops to Repeat Actions	p. 797
Calling One Procedure from Another Procedure	p. 800
Creating Dialog Boxes	p. 802
Distributing a VBA Project	p. 812
Appendixes
Keyboard Shortcuts	p. 817
XML: The Underpinnings of Office 2003	p. 829
What Is XML?	p. 829
What Is XML For?	p. 830
What Benefits Does XML Offer?	p. 830
How XML Is Implemented in Office	p. 831
XML Terms and Components	p. 832
Index	p. 837
Table of Contents provided by Ingram. All Rights Reserved.