Book description
Office for Mac remains the leading productivity suite for Mac, with Apple's iWork and the free OpenOffice.org trailing far behind. And now it's being updated with a cleaner interface and more compatibility with Exchange and SharePoint.
Beginning Office 2011 for Mac OS X offers a practical, hands-on approach to using Office 2011 applications to create and edit documents and get work done efficiently. You'll learn how to customize Office, design, create, and share documents, manipulate data in a spreadsheet, and create lively presentations. You'll also discover how to organize your email, contacts, and tasks with the new Outlook for Mac. Conveying information quickly and concisely, the book brings you from beginner or intermediate to an experienced and confident user.
This book provides the best combination of accessible and focused coverage of the Office 2011 applications. Rather than cover every little-used feature, the book covers real-world usage, putting emphasis on practical tasks and troubleshooting common problems, such as sharing documents with Windows users and older versions of Office.
Table of contents
- Copyright
- About the Authors
- About the Technical Reviewer
- Acknowledgments
- Introduction
-
I. Building Essential Office Skills
- 1. Getting Up to Speed with the Office Applications
-
2. Learning Common Tools Across the Office Suite
- 2.1. Using the Menus, the Toolbars, and the Ribbon
- 2.2. Using the Toolbox
- 2.3. Sharing a Document with Other People
- 2.4. Saving Time and Effort with AutoCorrect
- 2.5. Checking Spelling and Grammar
- 2.6. Printing Documents
- 2.7. Summary
-
3. Working with Text
- 3.1. Entering Text in Your Documents
- 3.2. Navigating with the Keyboard and Selecting Objects
- 3.3. Applying Direct Formatting to Text and Objects
- 3.4. Using Cut, Copy, and Paste
- 3.5. Using Find and Replace
- 3.6. Creating Tables
- 3.7. Creating Hyperlinks
- 3.8. Summary
-
4. Using Pictures and Shapes in Your Documents
- 4.1. Understanding How You Position Graphical Objects
- 4.2. Choosing Where to Insert a Graphical Object
- 4.3. Inserting Clip Art
- 4.4. Inserting Pictures in Your Documents
- 4.5. Adding and Formatting a Shape
- 4.6. Rotating a Graphical Object
- 4.7. Positioning a Graphical Object
- 4.8. Choosing Text Wrapping in Word
- 4.9. Making a Picture Look the Way You Want It
- 4.10. Inserting SmartArt
- 4.11. Arranging Graphical Objects to Control Which Is Visible
- 4.12. Summary
-
5. Customizing Office to Suit You
- 5.1. Choosing Which Toolbars to Display and How to Display Them
-
5.2. Customizing the Toolbars and Menus in Word, Excel, and PowerPoint
- 5.2.1. Preparing to Customize the Toolbars, Menu Bars, or Menus
- 5.2.2. Finding the Commands to Add to the Toolbars or Menus
- 5.2.3. Customizing a Toolbar
- 5.2.4. Customizing a Menu
- 5.2.5. Customizing the Menu Bar
- 5.2.6. Customizing the Context Menus in PowerPoint
- 5.2.7. Creating Custom Toolbars Containing the Commands You Need
- 5.2.8. Resetting a Toolbar to Its Default Buttons
- 5.3. Customizing the Ribbon in Word, Excel, and PowerPoint
- 5.4. Customizing the Toolbar in Outlook
- 5.5. Creating Custom Keyboard Shortcuts in Word and Excel
-
5.6. Choosing Essential Preferences in Word, Excel, and PowerPoint
- 5.6.1. Opening the Preferences Dialog Box or Preferences Window
- 5.6.2. Setting Your User Name, Initials, and Address
- 5.6.3. Choosing Whether to Display the Gallery Dialog Box When the Application Opens
- 5.6.4. Choosing Whether to Receive Feedback with Sound
- 5.6.5. Choosing Whether to Confirm Launching Other Applications
- 5.6.6. Changing the Number of Recent Documents the Application Tracks
- 5.6.7. Choosing the Default Format for Saving Documents
- 5.6.8. Setting AutoRecover to Keep Backups of Your Documents for Safety
- 5.6.9. Setting the Default Folders for Saving Your Documents and Presentations
- 5.7. Summary
-
II. Creating Documents with Microsoft Word
-
6. Entering Text and Using Views
- 6.1. Entering Text in Your Word Documents
- 6.2. Selecting Text in Word-Specific Ways
- 6.3. Moving with Keyboard Shortcuts and the Browse Object
- 6.4. Telling Word Where to Find Your Templates
- 6.5. Creating Backup Documents and Recovering from Disaster
-
6.6. Using Views and Windows to See What You Need
-
6.6.1. Picking the Right View for What You're Doing
- 6.6.1.1. Using Print Layout View to See How a Document Will Look When Printed
- 6.6.1.2. Using Full Screen View to See More of a Document
- 6.6.1.3. Using Web Layout View to Get a Preview of Web Pages
- 6.6.1.4. Developing a Document in Outline View
- 6.6.1.5. Using Draft View
- 6.6.1.6. Taking Notes in Notebook Layout View
- 6.6.1.7. Laying Out a Document in Publishing Layout View
- 6.6.2. Opening Extra Windows
- 6.6.3. Splitting the Document Window into Two Panes
-
6.6.1. Picking the Right View for What You're Doing
- 6.7. Summary
-
7. Adding Style: Formatting Your Documents
- 7.1. Understanding Word's Many Types of Formatting
- 7.2. Formatting Your Documents the Best Way
-
7.3. Applying Styles to a Document
- 7.3.1. Applying Styles from the Quick Styles Box on the Ribbon
- 7.3.2. Applying Styles with the Styles Pop-Up Menu on the Formatting Toolbar
- 7.3.3. Applying Styles with the Styles Pane
- 7.3.4. Applying Styles Using the Style Dialog Box
- 7.3.5. Applying Different Quick Styles to a Document
- 7.3.6. Changing the Styles in the Quick Style Gallery
- 7.3.7. Applying Styles Using the Keyboard
- 7.3.8. See Which Styles a Document Uses
- 7.4. Creating Custom Styles
- 7.5. Applying Direct Formatting on Top of Styles
-
7.6. Navigating Quickly Around Your Documents
- 7.6.1. Using the Sidebar
-
7.6.2. Using Find and Replace
- 7.6.2.1. Highlighting All Instances of a Search Term
- 7.6.2.2. Searching Only Part of the Document
- 7.6.2.3. Changing the Search Direction
- 7.6.2.4. Finding Search Terms That Match the Case You Type
- 7.6.2.5. Restricting the Search to Whole Words
- 7.6.2.6. Using Wildcards to Find Variable Text
- 7.6.2.7. Finding Words That Sound Like Other Words
- 7.6.2.8. Finding All Forms of a Word
- 7.6.2.9. Searching for Special Characters
- 7.6.2.10. Searching Only at the Start or End of a Word
- 7.6.2.11. Finding Formatting
- 7.6.3. Replacing Text, Formatting, and Styles
- 7.6.4. Navigating with Go To
- 7.7. Summary
-
8. Creating Complex Documents and Layouts
- 8.1. Working with Word's Extra Table Features
- 8.2. Creating Complex Documents with Multiple Sections
- 8.3. Adding Headers, Footers, and Page Numbers
- 8.4. Creating Newspaper-Style Columns of Text
- 8.5. Using Bookmarks, Fields, and References
- 8.6. Creating Long Documents with Outline View
- 8.7. Adding Footnotes and Endnotes
- 8.8. Summary
-
9. Creating Business Documents with Mail Merge
- 9.1. Understanding How Mail Merge Works
- 9.2. Creating the Main Document for the Mail Merge
- 9.3. Selecting the Recipients for the Mail Merge
- 9.4. Inserting Placeholders in Your Main Document
- 9.5. Filtering the Recipients of the Merge Document
- 9.6. Previewing the Results of the Mail Merge
- 9.7. Completing the Mail Merge
- 9.8. Restoring a Mail Merge Main Document to a Normal Document
- 9.9. Summary
-
10. Revising and Reviewing Documents
- 10.1. Understanding How You Can Work on Documents with Your Colleagues
- 10.2. Editing a Document Simultaneously with Your Colleagues
- 10.3. Sharing Documents with Your Colleagues on a Network
-
10.4. Tracking the Changes in a Document
- 10.4.1. Choosing Which Changes to Track
- 10.4.2. Turning On Track Changes for a Document
- 10.4.3. Ensuring Your Colleagues Use the Track Changes Feature
- 10.4.4. Working in a Document with Track Changes On
- 10.4.5. Choosing How to View the Document's Changes and Markup
- 10.4.6. Controlling Which Changes Word Displays
- 10.4.7. Integrating Tracked Changes into a Document
- 10.4.8. Using Track Changes in Full Screen View
- 10.5. Adding Comments to a Document
- 10.6. Comparing or Combining Different Versions of the Same Document
- 10.7. Summary
- 11. Printing, Securing, and Sharing Documents
-
6. Entering Text and Using Views
-
III. Analyzing Data with Microsoft Excel
-
12. Creating Workbooks and Entering Data
- 12.1. Creating and Saving a New Workbook
- 12.2. Navigating the Excel Interface, Worksheets, and Workbooks
- 12.3. Moving the Active Cell
- 12.4. Enter Data in Your Worksheets
- 12.5. inserting, deleting, and rearranging worksheets
-
12.6. Making Excel Display Worksheets the Way You Need
- 12.6.1. Understanding Excel's Views
- 12.6.2. Splitting the Window to View Separate Parts of a Worksheet
- 12.6.3. Opening Extra Windows to Show Other Parts of a Workbook
- 12.6.4. Changing the Window and Arranging Open Windows
- 12.6.5. Zooming to Show the Data You Need to See
- 12.6.6. Freezing Rows and Columns So That They Stay On-Screen
- 12.7. Summary
-
13. Formatting Your Worksheets
- 13.1. Working with Rows and Columns
-
13.2. Formatting Cells and Ranges
- 13.2.1. Understanding the Three Main Tools for Applying Formatting
- 13.2.2. Controlling How Data Appears by Applying Number Formatting
- 13.2.3. Setting the Workbook's Overall Look by Applying a Theme
- 13.2.4. Setting Alignment
- 13.2.5. Choosing Font Formatting
- 13.2.6. Applying Borders and Fills
- 13.2.7. Applying Protection to Cells
- 13.3. Applying Conditional Formatting to Identify Particular Values
- 13.4. Using Data Validation to Check for Invalid Entries
- 13.5. Formatting Quickly with Table Formatting and Styles
- 13.6. Adding Headers and Footers to Your Worksheets
- 13.7. Printing Your Excel Worksheets and Workbooks
- 13.8. Sharing Your Workbooks with Your Colleagues
- 13.9. Summary
-
14. Creating Powerful and Persuasive Charts
- 14.1. Learning the Essentials of Charts in Excel
-
14.2. Creating, Laying Out, and Formatting a Chart
- 14.2.1. Creating a Chart
- 14.2.2. Changing a Chart from an Embedded Chart to a Chart Sheet
- 14.2.3. Changing the Chart Type
- 14.2.4. Switching the Rows and Columns in a Chart
- 14.2.5. Changing the Source Data for a Chart
- 14.2.6. Choosing the Layout for the Chart
- 14.2.7. Adding a Separate Data Series to a Chart
- 14.2.8. Applying a Style to a Chart
- 14.2.9. Adding a Title to a Chart
- 14.2.10. Adding Axis Titles to the Chart
- 14.2.11. Changing the Scale or Numbering of an Axis
- 14.2.12. Adding a Legend to a Chart
- 14.2.13. Adding Axis Labels from a Range Separate from the Chart Data
- 14.2.14. Adding Data Labels to the Chart
- 14.2.15. Choosing Which Gridlines to Display
- 14.2.16. Formatting a Chart Wall and Chart Floor
- 14.2.17. Formatting Individual Chart Elements
- 14.3. Copying Chart Formatting
- 14.4. Reusing Your Own Designs by Creating Custom Chart Types
- 14.5. Adding Sparklines to Your Worksheets
- 14.6. Summary
-
15. Crunching Numbers with Formulas and Functions
- 15.1. Understanding the Difference Between Formulas and Functions
- 15.2. Referring to Cells and Ranges in Formulas and Functions
-
15.3. Performing Custom Calculations by Creating Formulas
- 15.3.1. Meeting Excel's Calculation Operators
- 15.3.2. Using the Calculation Operators
- 15.3.3. Understanding the Order in Which Excel Evaluates Operators
- 15.3.4. Nesting Parts of Formulas to Control Operator Precedence
- 15.3.5. Entering Formulas Quickly by Copying and Using AutoFill
- 15.3.6. Troubleshooting Common Problems with Formulas
- 15.4. Performing Standard Calculations by Inserting Functions
- 15.5. Summary
-
16. Creating Simple Databases and Solving Business Problems
-
16.1. Creating Databases in Excel
- 16.1.1. Understanding What You Can and Can't Do with Excel Database Tables
- 16.1.2. Creating a Database Table and Returning Data
- 16.1.3. Resizing a Database Table
- 16.1.4. Sorting a Database Table by One or More Fields
- 16.1.5. Identifying and Removing Duplicate Records in a Database Table
- 16.1.6. Filtering a Database Table
-
16.2. Solving Business Problems with Scenarios and Goal Seek
-
16.2.1. Examining Different Scenarios in a Worksheet
- 16.2.1.1. Creating the Worksheet for Your Scenarios
- 16.2.1.2. Opening the Scenario Manager Dialog Box
- 16.2.1.3. Creating Scenarios
- 16.2.1.4. Applying Protection to Your Scenarios
- 16.2.1.5. Editing and Deleting Scenarios
- 16.2.1.6. Switching Among Your Scenarios
- 16.2.1.7. Merging Scenarios into a Single Worksheet
- 16.2.1.8. Creating Reports from Your Scenarios
- 16.2.2. Using Goal Seek
-
16.2.1. Examining Different Scenarios in a Worksheet
- 16.3. Summary
-
16.1. Creating Databases in Excel
-
17. Manipulating Data with PivotTables
- 17.1. Understanding What PivotTables Are and What You Can Do with Them
- 17.2. Creating and Laying Out a PivotTable
- 17.3. Controlling the Design of a PivotTable
- 17.4. Formatting a PivotTable
- 17.5. Naming a PivotTable and Setting Options for It
- 17.6. Sorting and Filtering a PivotTable
- 17.7. Summary
-
12. Creating Workbooks and Entering Data
-
IV. Creating Presentations with Microsoft PowerPoint
-
18. Starting to Build a Presentation in PowerPoint
- 18.1. Creating a Presentation
- 18.2. Changing a Presentation's Theme, Fonts, or Colors
- 18.3. Changing the Slide Size or Orientation
- 18.4. Navigating the PowerPoint Window
- 18.5. Add Content to a Slide
- 18.6. Adding, Deleting, and Rearranging Slides
- 18.7. Using Views to Work on Your Presentation
- 18.8. Creating the Outline of a Presentation
- 18.9. Organizing Your Slides into Sections
- 18.10. Collaborating on a Presentation with Your Colleagues
- 18.11. Summary
-
19. Creating Clear and Compelling Slides
- 19.1. Planning the Slides in Your Presentation
- 19.2. Choosing Slide Layouts to Suit the Contents
- 19.3. Formatting Text on Your Slides
- 19.4. Adding Tables, SmartArt, Charts, and Hyperlinks to Slides
- 19.5. Summary
-
20. Adding Life and Interest to a Presentation
- 20.1. Adding Pictures to a Presentation
- 20.2. Adding Movies and Sounds to a Presentation
- 20.3. Adding Transitions to Slides
- 20.4. Adding Animations to Slides
- 20.5. Keeping Extra Information Up Your Sleeve with Hidden Slides
- 20.6. Creating Custom Slide Shows Within a Presentation
- 20.7. Summary
- 21. Delivering a Presentation Live or Online
-
18. Starting to Build a Presentation in PowerPoint
-
V. E-mailing and Organizing with Outlook
-
22. Using E-mail Effectively
- 22.1. Setting Up Outlook
- 22.2. Meeting the Outlook Interface
- 22.3. Sending and Receiving Messages
- 22.4. Sending and Receiving Attachments
- 22.5. Replying to and Forwarding Messages
- 22.6. Deleting, Storing, and Organizing Messages
- 22.7. Adding Consistent Closings to Your Messages with Signatures
- 22.8. Dealing with Spam
- 22.9. Summary
-
23. Keeping Your Contacts in Order
-
23.1. Creating Contacts
- 23.1.1. Creating a Contact from Scratch
-
23.1.2. Importing Contacts from Other Address Books
- 23.1.2.1. Importing Contacts from Address Book and MobileMe with Sync Services
- 23.1.2.2. Creating and Importing vCard Files from Address Book
- 23.1.2.3. Creating and Importing vCard Files from Yahoo! Address Book
- 23.1.2.4. Creating and Importing vCard Files from Google Contacts
- 23.1.2.5. Importing Contacts from Entourage
- 23.1.2.6. Importing Contacts from a CSV File
- 23.1.2.7. Importing Contacts from vCard Files
- 23.1.2.8. Importing Contacts from an Excel Worksheet
- 23.2. Working with Contacts
- 23.3. Summary
-
23.1. Creating Contacts
- 24. Managing Your Calendar
- 25. Working with Tasks and Notes
-
22. Using E-mail Effectively
Product information
- Title: Learn Office 2011 for Mac OS X
- Author(s):
- Release date: December 2010
- Publisher(s): Apress
- ISBN: 9781430233336
You might also like
book
Office 2011 for Macintosh: The Missing Manual
Office 2011 for Mac is easy to use, but to unleash its full power, you need …
book
Learn Excel 2011 for Mac
Microsoft Excel 2011 for Mac OS X is a powerful application, but many of its most …
video
Apple Pro Video Training: Aperture 3
With more than 200 new features, Aperture 3 gives photographers what they want in a workflow …
book
The iPad Pocket Guide
Quickly master all the features and functions of the iPad with this handy well-crafted pocket guide. …