Home Page Icon
Home Page
Table of Contents for
Cover Page
Close
Cover Page
by Steve Perspection, Inc. Johnson
Office 2008 for the Mac on Demand
Title Page
Copyright Page
Contents
Acknowledgements
Perspection, Inc.
Acknowledgements
About The Author
We Want To Hear From You!
Introduction
How This Book Works
What’s New
Keyboard Shortcuts
Step-by-Step Instructions
Real World Examples
Workshop
Get More On The Web
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
Opening a Web Page
Previewing a Web Page
Creating a Hyperlink
Adding Hyperlinks to Slide Objects
Changing Web Page Options
Saving a Web Page
Saving Slides as Web Graphics
Creating a PDF Document
Sending a Document Using E-Mail
17. Customizing and Expanding Office
Customizing Toolbars
Changing Menus
Changing Shortcut Keys
Working with Macros
Opening a Document with Macros
Saving a Document with Macros
Installing and Running Office Scripts
Working with an Automator Workflow
Using Ready-Made AppleScripts
Writing and Recording AppleScripts
Removing Office
18. Using the Project Center
Creating a Project
Using the Project Center
Adding and Removing Project Contacts
Adding and Removing E-mail Messages
Adding Notes, Tasks, Events, or Clippings
Adding Document Files
Working with Projects in Office
Backing Up a Project
New! Features
Microsoft Office 2008
On Demand Online Workshop
Here are Some of the Workshops You’ll Find
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title Page
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset