- Title Page
- Copyright Page
- Contents
- Acknowledgements
- Introduction
- 1. Getting Started with Office
- Starting an Office Program
- Using the Project Gallery
- Viewing an Office Program Window
- Choosing Commands
- Working with Toolbars
- Working with the Elements Gallery
- Creating a Blank Office Document
- Creating a Document Using a Template
- Opening an Existing Office Document
- Managing Windows
- Switching Views
- Using the Toolbox
- Checking Compatibility
- Saving an Office Document
- Saving an Office Document with Different Formats
- Creating a Template
- Recovering an Office Document
- Getting Updates on the Web
- Getting Help While You Work
- Closing a Document and Quitting Office
- 2. Using Shared Office Tools
- Editing Text
- Formatting Text
- Copying and Moving Text
- Using the Scrapbook
- Finding and Replacing Text
- Correcting Text Automatically
- Checking Spelling
- Changing Spelling Options
- Finding the Right Words
- Researching Words
- Translating Text to Another Language
- Using Multiple Languages
- Inserting Symbols
- Undoing and Redoing an Action
- Zooming the View In and Out
- Using the Format Painter
- Adding Custom Colors
- Understanding Themes
- Viewing and Applying a Theme
- Applying and Creating Theme Colors
- Applying Theme Fonts
- Creating a Custom Theme
- Applying a Custom Theme
- Previewing a Document
- Printing a Document
- Protecting a Document
- Modifying Document Properties
- 3. Adding Art to Office Documents
- Locating and Inserting Clip Art
- Inserting a Picture
- Adding a Quick Style to a Picture
- Applying a Shape to a Picture
- Applying Picture Effects
- Applying a Border to a Picture
- Modifying Picture Brightness and Contrast
- Recoloring a Picture
- Modifying Picture Size
- Cropping and Rotating a Picture
- Creating WordArt Text
- Formatting WordArt Text
- Modifying WordArt Text Position
- Creating SmartArt Graphics
- Formatting a SmartArt Graphic
- Modifying a SmartArt Graphic
- Creating an Organization Chart
- Modifying an Organization Chart
- Inserting and Creating a Chart
- Changing a Chart Type
- Changing a Chart Layout Style
- Changing Chart Titles
- Changing Chart Labels
- Editing Chart Data
- Sharing Information Between Programs
- Linking and Embedding Objects
- Flagging Documents for Follow Up
- 4. Adding Shapes to Office Documents
- Drawing and Resizing Shapes
- Creating and Editing Freeforms
- Adding Text to a Shape
- Adding a Quick Style to a Shape
- Adding a Quick Style to Shape Text
- Adding Other Effects to a Shape
- Applying Color Fills
- Applying Picture or Texture Fills
- Applying Gradient Fills
- Aligning and Distributing Objects
- Aligning Objects to Grids and Guides
- Changing Stacking Order
- Rotating and Flipping Objects
- Grouping and Ungrouping Objects
- Creating a Text Box
- 5. Creating a Document with Word
- Viewing the Word Window
- Creating a New Word Document
- Moving Around in a Document
- Navigating a Document
- Changing Document Views
- Creating a Notebook
- Creating a Publication
- Adding to a Publication
- Creating an Outline
- Setting Up the Page
- Setting Up the Page Margins
- Selecting Text
- Showing Characters
- Checking Spelling and Grammar
- Using Custom Dictionaries
- Setting Hyphenation
- Inserting AutoText
- Inserting New Pages
- Controlling the Way Pages Break
- Inserting New Sections
- Arranging Text in Columns
- Adding Headers and Footers
- Inserting Page Numbers and the Date and Time
- Inserting Symbols and Special Characters
- 6. Formatting a Document with Word
- Formatting Text for Emphasis
- Using Automatic Formatting
- Finding and Replacing Formatting
- Changing Paragraph Alignment
- Changing Line Spacing
- Displaying Rulers
- Setting Paragraph Tabs
- Setting Paragraph Indents
- Creating Bulleted and Numbered Lists
- Changing Character Spacing
- Changing Text Direction
- Applying a Style
- Revealing Formatting Styles
- Creating and Modifying Styles
- Hiding Text
- 7. Enhancing a Document with Word
- Adding a Drop Cap
- Adding a Watermark
- Adding Page Backgrounds
- Wrapping Text Around an Object
- Working with Text Boxes
- Creating a Table
- Entering Text in a Table
- Modifying a Table
- Adjusting Table Cells
- Formatting a Table
- Adding a Quick Style to a Table
- Calculating a Value in a Table
- Creating a Form Letter
- Creating Labels
- Inserting a Table of Contents
- Creating an Index
- Creating Captions
- Creating Footnotes or Endnotes
- Creating a Bookmark
- Comparing Documents
- Using Track Changes
- Addressing Envelopes and Labels
- Using Print Preview
- Adding a Cover Page
- 8. Creating a Worksheet with Excel
- Viewing the Excel Window
- Selecting Cells
- Moving Around the Workbook
- Entering Labels on a Worksheet
- Entering Values on a Worksheet
- Entering Values Quickly with AutoFill
- Editing Cell Contents
- Clearing Cell Contents
- Inserting and Deleting Cell Contents
- Selecting Rows, Columns, and Special Ranges
- Selecting and Naming a Worksheet
- Inserting and Deleting a Worksheet
- Inserting a Worksheet from the Elements Gallery
- Moving and Copying a Worksheet
- Hiding or Unhiding a Worksheet
- Hiding and Unhiding a Column or Row
- Inserting a Column or Row
- Deleting a Column or Row
- Adjusting Column Width and Row Height
- Splitting a Worksheet into Panes
- Freezing and Unfreezing a Column or Row
- Showing and Hiding Workbook Elements
- 9. Building a Worksheet with Excel
- Understanding Formulas
- Understanding Cell Referencing
- Creating a Simple Formula
- Creating a Formula Using Formula AutoComplete
- Editing a Formula
- Naming Cells and Ranges
- Entering Named Cells and Ranges
- Simplifying a Formula with Ranges
- Using the Calculator
- Using the Formula Builder
- Using Nested Functions
- Calculating Multiple Results
- Using Lookup and Reference Functions
- Using Text Functions
- Summarizing Data Using Subtotals
- Summarizing Data Using Functions
- Calculating Totals with AutoSum
- Calculating a Conditional Sum
- Auditing a Worksheet
- Correcting Calculation Errors
- Correcting Formulas
- Creating a List
- Entering and Editing Data in a List
- Formatting a List
- Working with Lists
- Sorting Data in a List
- Displaying Parts of a List with AutoFilter
- Creating Custom Searches
- Creating Calculations in a List
- Converting Text to Columns
- Creating Groups and Outlines
- Adding Data Validation to a Worksheet
- Creating a Drop-Down List
- 10. Designing a Worksheet with Excel
- Formatting Numbers
- Designing Conditional Formatting
- Controlling Text Flow
- Changing Data Alignment
- Changing Data Color
- Adding Color and Patterns to Cells
- Adding Borders to Cells
- Formatting Data with AutoFormat
- Creating and Applying Styles
- Formatting a Background
- Inserting Page Breaks
- Setting Up the Page
- Adding Headers and Footers
- Setting the Print Area
- Customizing Worksheet Printing
- 11. Sharing a Worksheet with Excel
- Locking or Unlocking Worksheet Cells
- Protecting Worksheets and Workbooks
- Sharing Workbooks
- Creating and Reading a Cell Comment
- Editing and Deleting a Cell Comment
- Tracking Changes
- Comparing and Merging Workbooks
- Asking “What If” with Goal Seek
- Creating Scenarios
- Exporting Data
- Analyzing Data Using a PivotTable
- Consolidating Data
- Linking Data
- Getting Query Data from a Database
- Getting Query Data from the Web
- Getting Data from a FileMaker Pro Database
- Getting Text Data
- 12. Creating a Presentation with PowerPoint
- Viewing the PowerPoint Window
- Browsing a Presentation
- Understanding PowerPoint Views
- Creating New and Consistent Slides
- Working with Objects
- Entering and Editing Text
- Resizing Text While Typing
- Changing Character Direction
- Inserting and Developing an Outline
- Moving and Indenting Text
- Modifying a Bulleted and Numbered List
- Creating Text Columns
- Changing Text Spacing
- Rearranging Slides
- Using Slides from Other Presentations
- Making Your Presentation Look Consistent
- Controlling Slide Appearance with Masters
- Controlling a Slide Layout with Masters
- Modifying Placeholders
- Controlling a Slide Background with Masters
- Adding a Background Style
- Inserting a Table
- Adding a Quick Style to a Table
- Modifying a Table
- Formatting a Table
- Inserting Special Characters
- Creating a Text Box
- 13. Delivering a Presentation with PowerPoint
- Changing Page Setup Options
- Adding Animation
- Using Specialized Animations
- Coordinating Multiple Animations
- Adding Slide Timings
- Creating Slide Transitions
- Recording a Narration
- Inserting Movies and Sounds
- Setting Movie and Sound Play Options
- Setting Up a Slide Show
- Creating a Custom Slide Show
- Starting and Navigating a Slide Show
- Annotating a Slide Show
- Using Presenter Tools
- Saving a Presentation as a Movie
- Saving a Presentation as a Slide Show
- Preparing Handouts
- Preparing Speaker Notes
- Adding Comments to a Presentation
- Adding a Header and Footer
- Inserting the Date and Time
- Inserting Slide Numbers
- Printing a Presentation
- 14. Communicating with Entourage
- Viewing the Entourage Window
- Preparing for Entourage
- Setting Up an Account
- Changing Views
- Viewing Items and Folders
- Creating a Contact
- Sorting Contacts
- Creating a Contact Group
- Creating and Addressing an E-Mail Message
- Formatting Message Text
- Attaching a File to a Message
- Creating a Signature
- Setting Message Delivery Priorities
- Sending Messages
- Receiving and Reading Messages
- Flagging Messages
- Categorizing Messages By Color
- Replying To and Forwarding a Message
- Organizing Messages in Folders
- Managing Messages with Rules
- Searching with Spotlight
- Finding and Filtering Messages
- Using Search Folders
- Creating a Mailing List
- Deleting Messages
- Reducing Junk E-Mail
- Archiving Messages
- Sending and Receiving Instant Messages
- Creating a News Server Account
- Reading and Posting a News Message
- Customizing Toolbars in Entourage
- 15. Managing Information with Entourage
- Viewing the Calendar
- Customizing the Calendar
- Scheduling an Appointment and Event
- Modifying or Deleting an Event
- Responding to Reminders
- Inviting Others to an Event
- Responding to Event Requests
- Updating and Canceling Event Requests
- Creating and Updating Tasks
- Creating a To Do List Item
- Viewing Tasks and To Do List Items
- Managing Tasks and To Do List Items
- Creating and Modifying Notes
- Using My Day
- Viewing the My Day Window
- Synchronizing Entourage with an iPod
- Printing Items from Entourage
- 16. Publishing Office Documents on the Web
- 17. Customizing and Expanding Office
- 18. Using the Project Center
- New! Features
- On Demand Online Workshop
- Index
If you’re searching for what’s new in Office 2008, just look for the icon: New!. The new icon appears in the table of contents and throughout this book so you can quickly and easily identify a new or improved feature in Office 2008. A complete description of each new feature appears in the New Features guide in the back of this book.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.