- 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
How You’ll Learn
What’s New
Keyboard Shortcuts
Step-by-Step Instructions
Real World Examples
Workshop
Get More On The Web
Welcome to Office 2008 for the Mac On Demand, a visual quick reference book that shows you how to work efficiently with Microsoft Office. This book provides complete coverage of basic to advanced Office skills.
You don’t have to read this book in any particular order. We’ve designed the book so that you can jump in, get the information you need, and jump out. However, the book does follow a logical progression from simple tasks to more complex ones. Each task is presented on no more than two facing pages, which lets you focus on a single task without having to turn the page. To find the information that you need, just look up the task in the table of contents or index, and turn to the page listed. Read the task introduction, follow the step-by-step instructions in the left column along with screen illustrations in the right column, and you’re done.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.