Show Me Microsoft Office 2003
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 418
Pages: 418
Authors: Steve Johnson, Perspection Inc.
- Main Page
- Table of content
- Copyright
- Acknowledgements
- Perspection, Inc.
- Acknowledgements
- About The Author
- We Want To Hear From You
- Introduction
- Find the Best Place to Start
- What s New
- How This Book Works
- Step-by-Step Instructions
- Real World Examples
- Troubleshooting Guide
- Show Me Live Software
- Microsoft Office Specialist
- Chapter 1. Getting Started with Office
- Introduction
- Starting an Office Program
- Using Task Panes
- Choosing Menu and Dialog Box Options
- Working with Toolbars
- Creating a New File
- Saving a File
- Saving a File with Different Formats
- Opening an Existing File
- Finding a File or Text in a File
- Arranging Windows
- Getting Help in an Office Program
- Getting Help from the Office Assistant
- Closing a File
- Getting Office Updates on the Web
- Repairing and Recovering Office Programs
- Quitting an Office Program
- Chapter 2. Using Shared Office Tools
- Introduction
- Editing Text
- Working with the Clipboard
- Finding and Replacing Text
- Using Multiple Languages
- Correcting Text Automatically
- Inserting Information the Smart Way
- Making Corrections
- Inserting Comments
- Using Track Changes
- Comparing and Merging Documents
- Inserting Research Material
- Controlling Programs with Your Voice
- Executing Voice Commands
- Dictating Text
- Recognizing Handwriting
- Automating Your Work with Macros
- Modifying a Macro
- Chapter 3. Adding Art to Office Documents
- Introduction
- Selecting, Moving, and Resizing Objects
- Drawing and Enhancing Objects
- Adding WordArt
- Inserting Clip Art
- Inserting a Picture
- Inserting a Picture from a Scanner or Camera
- Modifying Pictures
- Creating an Organization Chart
- Creating a Diagram
- Creating a Graph Chart
- Modifying a Graph Chart
- Managing Pictures
- Sharing Pictures Using E-Mail
- Chapter 4. Creating a Document with Word
- Introduction
- Viewing the Word Window
- Creating a Document
- Changing Document Views
- Reading a Document
- Working with Multiple Documents
- Moving Around in a Document
- Setting Up the Page
- Setting Up the Page Margins
- Creating an Outline
- Selecting Text
- Inserting Symbols and AutoText
- Checking Spelling and Grammar
- Finding the Right Words
- Previewing a Document
- Printing a Document
- Chapter 5. Formatting a Document with Word
- Introduction
- Formatting Text for Emphasis
- Formatting Text with Special Effects
- Revealing Formatting
- Finding and Replacing Formatting
- Changing Paragraph Alignment
- Changing Line Spacing
- Displaying Rulers
- Setting Paragraph Tabs
- Setting Paragraph Indents
- Changing Character Spacing
- Applying a Style
- Creating and Modifying Styles
- Creating Bulleted and Numbered Lists
- Inserting New Pages and Sections
- Adding Headers and Footers
- Inserting Page Numbers and the Date and Time
- Working with Templates
- Hiding Text
- Chapter 6. Enhancing a Document with Word
- Introduction
- Adding Desktop Publishing Effects
- Arranging Text in Columns
- Creating a Table
- Entering Text in a Table
- Modifying a Table
- Adjusting Table Cells
- Formatting a Table
- Creating a Form Letter
- Creating Labels
- Addressing Envelopes and Labels
- Inserting a Table of Contents
- Creating Multiple Document Versions
- Modifying the Document Summary
- Protecting a Document
- Chapter 7. Creating a Worksheet with Excel
- Introduction
- Viewing the Excel Window
- Selecting Cells
- Moving Around Cells
- Entering Text and Numbers
- Making Label Entries
- Editing Cell Contents
- Clearing Cell Contents
- Inserting and Deleting Cells
- Selecting a Column or Row
- Inserting and Deleting Columns or Rows
- Hiding and Unhiding a Column or Row
- Adjusting Column Width and Row Height
- Selecting and Naming a Worksheet
- Inserting and Deleting a Worksheet
- Moving and Copying a Worksheet
- Hiding and Unhiding Worksheets and Workbooks
- Splitting a Worksheet in Panes
- Freezing Panes
- Chapter 8. Building a Worksheet with Excel
- Introduction
- Creating a Simple Formula
- Editing and Copying a Formula
- Naming a Range
- Simplifying a Formula with Ranges
- Understanding Cell Referencing
- Using Absolute Cell References
- Performing Calculations Using Functions
- Calculating Results
- Correcting Calculation Errors
- Creating a Chart
- Selecting and Editing a Chart
- Changing a Chart Type
- Adding and Deleting a Data Series
- Enhancing a Data Series
- Formatting a Chart
- Enhancing a Chart
- Understanding Lists
- Creating a List
- Sorting Data in a List
- Working with Lists
- Chapter 9. Designing a Worksheet with Excel
- Introduction
- Formatting Text and Numbers
- Changing Data Alignment
- Changing Data Font and Color
- Designing Conditional Formatting
- Adding Color and Patterns to Cells
- Adding Borders to Cells
- Formatting Data with AutoFormat
- Creating and Applying Styles to Cells
- Formatting Tabs and the Background
- Inserting Page Breaks
- Setting Up the Page
- Adding Headers and Footers
- Customizing Worksheet Printing
- Setting the Print Area
- Previewing a Worksheet
- Printing a Worksheet
- Chapter 10. Creating a Presentation with PowerPoint
- Introduction
- Creating a Presentation Using the AutoContent Wizard
- Applying a Design Template
- Viewing the PowerPoint Window
- Understanding the PowerPoint Views
- Creating Consistent Slides
- Entering and Deleting Text
- Aligning and Spacing Text
- Modifying Page Setup
- Developing an Outline
- Rearranging Slides
- Controlling Slide Appearance with Masters
- Working with Color Schemes
- Applying Color and Effects to an Object
- Working with Objects
- Aligning and Arranging Objects
- Creating a Text Box
- Inserting Slides from Other Presentations
- Inserting a Table
- Inserting and Playing Media
- Checking Style and Spelling
- Chapter 11. Delivering a Presentation with PowerPoint
- Introduction
- Adding Action Buttons
- Creating Slide Transitions
- Adding Animation
- Using Specialized Animations
- Timing a Presentation
- Setting Up a Slide Show
- Creating a Custom Slide Show
- Starting a Slide Show
- Navigating a Slide Show
- Annotating a Slide Show
- Adding a Header and Footer
- Preparing Speaker Notes and Handouts
- Previewing and Printing a Presentation
- Broadcasting a Presentation
- Packaging a Presentation on CD
- Chapter 12. Creating a Database with Access
- Introduction
- Understanding How Databases Store Data
- Creating a Database
- Stepping Through a Database Wizard
- Viewing the Access Window
- Viewing Database Objects
- Working with Database Objects
- Planning Tables
- Creating a Table by Entering Data
- Creating a Table Using a Wizard
- Working with a Table
- Importing Data into Tables
- Working with a Table in Design View
- Specifying Data Types and Field Properties
- Changing Field Properties
- Creating Input Masks
- Creating a Lookup Field
- Planning Table Relationships
- Defining Table Relationships
- Ensuring Referential Integrity
- Chapter 13. Locating and Managing Data with Access
- Introduction
- Sorting Records
- Filtering Out Records
- Creating Complex Filters Using Forms
- Understanding the Different Types of Queries
- Creating a Query Using a Wizard
- Creating a Query in Design View
- Getting Information with a Query
- Modifying a Query in Design View
- Performing Calculations in Queries
- Summarizing Values with a Crosstab Query
- Creating a Parameter Query
- Finding Duplicate Fields
- Identifying Object Dependencies
- Backing Up a Database
- Compacting and Repairing a Database
- Chapter 14. Presenting Data with Access
- Introduction
- Creating a Form Using a Wizard
- Working with a Form in Design View
- Entering and Editing Data in a Form
- Modifying a Form in Design View
- Creating a Report Using a Wizard
- Modifying a Report in Design View
- Performing Calculations in Reports
- Formatting a Form or Report
- Aligning and Grouping Controls
- Creating a Data Access Page Using a Wizard
- Working with a Data Access Page in Design View
- Formatting a Datasheet
- Changing the Page Setup
- Previewing and Printing Information
- Creating Mailing Labels
- Chapter 15. Communicating with Outlook
- Introduction
- Preparing for Outlook
- Using Outlook for the First Time
- Viewing the Outlook Window
- Using Outlook Today
- Using the Navigation Pane
- Viewing Items and Folders
- Creating a Contact
- Sorting Contacts
- Creating a Distribution List
- Creating and Addressing an E-Mail Message
- Formatting Message Text
- Attaching a File or Item to a Message
- Using Stationery
- Creating a Signature
- Working with a Signature
- Sending Messages
- Receiving and Reading Messages
- Flagging Messages
- Replying to and Forwarding a Message
- Finding and Filtering Messages
- Organizing Messages in Folders
- Managing Messages with Color and Rules
- Using Search Folders
- Reducing Junk E-Mail and Spam
- Archiving Messages
- Setting Up Instant Messaging
- Starting Windows Messenger
- Adding Contacts
- Enabling Instant Messaging
- Sending and Receiving Instant Messages
- Sending a File During an Instant Message
- Chapter 16. Managing Information with Outlook
- Introduction
- Viewing the Calendar
- Customizing the Calendar
- Scheduling an Appointment and Event
- Scheduling Meetings
- Scheduling Meeting Resources
- Responding to Meeting Requests
- Updating and Canceling Meeting Requests
- Scheduling Online Meetings
- Creating and Updating Tasks
- Organizing Tasks
- Assigning Tasks to Others
- Monitoring Task Progress
- Managing Tasks
- Tracking Activities with Contacts
- Recording Items in the Journal
- Opening and Modifying Journal Entries
- Organizing Items by Categories
- Customizing How You View Items
- Creating and Modifying Notes
- Previewing Items from Outlook
- Printing Items from Outlook
- Chapter 17. Creating a Publication with Publisher
- Introduction
- Viewing the Publisher Window
- Creating a Quick Publication
- Creating a New Publication
- Creating a Blank Publication
- Changing Your View
- Inserting and Deleting Pages
- Inserting and Editing Text
- Creating a Web Site
- Adding a Hot Spot Hyperlink
- Applying Color
- Adding Design Gallery Elements
- Checking Your Design
- Setting Up the Page
- Using Commercial Printing Tools
- Printing Publications
- Chapter 18. Designing a Publication with Publisher
- Introduction
- Setting Up Layout Guides
- Creating a Frame
- Working with Text
- Connecting Text Frames
- Creating a Consistent Look
- Creating Tables
- Working with Pictures and Shapes
- Wrapping Text Around an Object
- Layering Objects
- Grouping Objects Together
- Aligning with Precision
- Rotating and Flipping Objects
- Chapter 19. Creating Web Pages with Office Programs
- Introduction
- Designing Web Pages
- Opening Web Pages
- Inserting Hyperlinks
- Using and Removing Hyperlinks
- Enhancing Web Pages
- Previewing Web Pages
- Saving Documents as Web Pages
- Saving Documents as Single File Web Pages
- Saving Slides as Web Graphics
- Publishing Web Pages
- Holding an Online Meeting
- Sending Documents by E-Mail
- Getting Documents from the Web
- Chapter 20. Working Together on Office Documents
- Introduction
- Viewing SharePoint Team Services
- Administering SharePoint Team Services
- Storing Documents in the Library
- Viewing Team Members
- Setting Up Alerts
- Assigning Project Tasks
- Creating an Event
- Creating Contacts
- Holding Web Discussions
- Working with Shared Workspace
- Installing Windows 2003 and SharePoint Server 2003
- Chapter 21. Sharing Information Between Programs
- Introduction
- Sharing Information Between Programs
- Exporting and Importing Files
- Embedding and Linking Information
- Creating an XML Document
- Creating a Word Document with Excel Data
- Copying a Web Table to an Excel Worksheet
- Analyzing Access Data in an Excel Workbook
- Creating a Presentation with Word Text
- Using an Access Database to Create Word Documents
- Creating a Word Outline from a Presentation
- Microsoft Office Specialist
- About the Microsoft Office Specialist Program
- What Does This Logo Mean?
- Preparing for a Microsoft Office Specialist Exam
- Taking a Microsoft Office Specialist Exam
- Getting More Information
- Troubleshooting
- Office
- Access
- Excel
- Outlook
- PowerPoint
- Publisher
- Word
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 418
Pages: 418
Authors: Steve Johnson, Perspection Inc.