• Author:
  • Kinkoph, Sherry Willard
• Subject:
  Business Applications
• Published by:
  John Wiley & Sons Inc (US)
• Published:
  16/12/2005
• Price:
  $44.99
• <  Buy this book  >

Are you new to computers? Does new technology make you nervous? Relax! You're holding in your hands the easiest guide ever to Office 2003 - a book that skips the long-winded explanations and shows you how things work. All you have to do is open the book, follow Chip, your friendly guide - and discover just how easy it is to get up to speed.

"The Simplified series is very accessible to beginners and provides useful information for more experienced users. For visual learners (like myself), the illustrations are a great help. It's challenging to take a complex subject and express it simply, clearly, concisely, and comprehensively. This book meets the challenge."
-John Kelly (Anchorage, AK)
* "Simplify It" sidebars offer real-world advice
* A friendly character called Chip introduces each task
* Full-color screen shots walk you through step by step
* Self-contained, two-page lessons make learning a snap

Sherry Willard Kinkoph has written and edited over 70 books over the past 10 years covering a variety of computer topics ranging from hardware to software, from Microsoft Office programs to the Internet. Her recent titles include Master VISUALLY eBay Business Kit, Teach Yourself VISUALLY Photoshop Elements 3.0, and Teach Yourself VISUALLY Office 2003. Sherry’s ongoing quest is to help users of all levels master the ever-changing computer technologies. No matter how many times they — the software manufacturers and hardware conglomerates — throw out a new version or upgrade, Sherry vows to be there to make sense of it all and help computer users get the most out of their machines.

Part I: Office Features.

1. Office Basics.

Start and Exit Office Applications.

Navigate the Program Windows.

Work with Task Panes.

Work with Menus and Toolbars.

Display and Hide Toolbars.

Customize Toolbars.

Find Help with Office.

2. Working with Files.

Start a New File.

Save a File.

Open an Existing File.

Close a File.

Find a File.

Preview a File.

Print a File.

Cut, Copy, and Paste Data.

Link and Embed Data.

Assign a Password to a File.

Part II: Word.

3. Adding Text.

Change Word’s Views.

Type and Edit Text.

Select Text.

Move and Copy Text.

Save Time with AutoText.

Insert Symbols.

4. Formatting Text.

Add Basic Formatting.

Change the Font.

Change the Font Size.

Add Color to Text.

Copy Formatting.

Align Text.

Indent Text.

Set Tabs.

Create Bulleted or Numbered Lists.

Set Margins.

Set the Line Spacing.

Format with Styles.

5. Working with Tables.

Insert a Table.

Draw a Table.

Select Table Cells.

Adjust the Column Width or Row Height.

Add Columns and Rows.

Delete Columns and Rows.

Merge Table Cells.

Split Table Cells.

Apply Table Formatting.

Reposition a Table.

Resize a Table.

6. Adding Extra Touches.

Add Borders and Shading to Text.

Create Columns.

Add Headers and Footers.

Insert Comments.

Insert Footnotes and Endnotes.

Insert Page Numbers and Page Breaks.

7. Previewing and Printing Documents.

Find and Replace Text.

Check Spelling and Grammar.

Work with AutoCorrect.

Track and Review Document Changes.

E-mail a Document.

Change Paper Size.

Print an Envelope.

Part III: Excel.

8. Building Spreadsheets.

Enter Cell Data.

Select Cells.

Faster Data Entry with AutoFill.

Add Columns and Rows.

Delete Columns and Rows.

Resize Columns and Rows.

Turn On Text Wrapping.

Center Data Across Columns.

Freeze a Column or Row.

Remove Data or Cells.

9. Worksheet Basics.

Assign Worksheet Names.

Delete a Worksheet.

Add a Worksheet.

Move a Worksheet.

Copy a Worksheet.

Format the Worksheet Tab Color.

Find and Replace Data.

Sort Data.

Filter Data with AutoFilter.

Insert a Comment.

Track and Review Workbook Changes.

10. Working with Formulas and Functions.

Understanding Formulas.

Create Formulas.

Define a Range Name.

Reference Ranges in Formulas.

Reference Cells from Other Worksheets.

Apply Absolute and Relative Cell References.

Understanding Functions.

Apply a Function.

Total Cells with AutoSum.

Audit a Worksheet for Errors.

11. Formatting Worksheets.

Change Number Formats.

Change the Font and Size.

Increase or Decrease Decimals.

Change Data Color.

Adjust the Cell Alignment.

Control Text Wrap.

Copy Cell Formatting.

Add Borders.

Format Data with AutoFormat.

12. Working with Charts.

Create a Chart with Chart Wizard.

Move and Resize Charts.

Change the Chart Type.

Change the Axes Titles.

Format Chart Objects.

Add Chart Objects.

Change the Chart Data.

Part IV: PowerPoint.

13. Presentation Basics.

Create a Presentation with the AutoContent Wizard.

Start a Presentation with a Design Template.

Build a Blank Presentation.

Change PowerPoint Views.

14. Creating Slides.

Understanding Slide Elements.

Add and Edit Slide Text.

Change the Font and Size.

Change the Text Color.

Change the Text Style.

Change the Text Alignment.

Set Line Spacing.

Insert Symbols.

Change the Slide Layout.

Add a New Text Object.

Add Clip Art to a Slide.

Add a Chart to a Slide.

Add a Table to a Slide.

Move a Slide Object.

Resize a Slide Object.

Change the Slide Background Color.

Add a New Slide.

Delete a Slide.

15. Assembling a Slide Show.

Insert and Delete Slides.

Reorganize Slides.

Create a Summary Slide.

Define Slide Transitions.

Add Animation Effects.

Animate Individual Slide Elements.

16. Presenting a Slide Show.

Rehearse a Presentation.

Run a Slide Show.

Create Speaker Notes.

Package Your Presentation on a CD.

Part V: Access.

17. Database Basics.

Understanding Database Basics.

Create a Blank Database.

Create a Database Based on a Template.

18. Adding Data Using Tables.

Create a Table.

Create a Table with a Wizard.

Change Table Views.

Add a Field.

Delete a Field.

Hide a Field.

Move a Field.

Add a Record.

Delete a Record.

19. Adding Data Using Forms.

Create a Form Using a Wizard.

Add a Record.

Navigate Records.

Delete a Record.

Change Form Views.

Move a Field.

Delete a Field.

Add a Field.

20. Finding and Querying Data.

Sort Records.

Filter Records.

Perform a Simple Query.

Create a Report.

Part VI: Outlook.

21. Organizing with Outlook.

View Outlook Components.

Schedule an Appointment.

Schedule a Recurring Appointment.

Schedule an Event.

Plan a Meeting.

Create a New Contact.

Create a New Task.

Add a Note.

Organize Outlook Items.

22. E-mailing with Outlook.

Compose and Send a Message.

Read an Incoming Message.

Turn Off the Reading Pane.

Reply to or Forward a Message.

Add a Sender to Your Address Book.

Delete a Message.

Attach a File to a Message.

Screen Junk E-mail.

Create a Message Rule.

Part VII: Publisher.

23. Publisher Basics.

Create a Publication.

Create a Blank Publication.

Zoom In and Out.

Add Text.

Add a New Text Box.

Add a Picture to a Publication.

Add Clip Art to a Publication.

24. Fine-Tuning a Publication.

Change the Text Font and Size.

Change the Text Style.

Change Text Alignment.

Change Text Color.

Control Text Wrap.

Add a Border.

Move a Publication Object.

Resize a Publication Object.

Connect Text Boxes.

Edit the Background Page.

Part VIII: Internet and Graphics.

25. Using the Office Internet Tools.

Create an HTML File.

Preview a File as a Web Page.

Set Alternative Text for an Object.

Add a Hyperlink.

Use the Web Toolbar.

26. Using the Office Graphics Tools.

Draw AutoShapes.

Insert Clip Art.

View Clip Art with the Clip Organizer.

Download Clip Art from the Web.

Insert an Image File.

Insert a WordArt Object.

Move and Resize an Object.

Rotate and Flip Objects.

Crop a Picture.

Format an Object.