3 Review(s)

Office 2011 for Mac is easy to use, but to unleash its full power, you need to go beyond the basics. This entertaining guide not only gets you started with Word, Excel, PowerPoint, and the new Outlook for Mac, it also reveals useful lots of things you didn't know the software could do. Get crystal-clear explanations on the features you use most -- and plenty of power-user tips when you're ready for more. Take advantage of new tools. Navigate with the Ribbon, use SmartArt graphics, and work online with Office Web Apps. Create professional-looking documents. Use Word to craft beautiful reports, newsletters, brochures, and posters. Crunch numbers with ease. Assemble data, make calculations, and summarize the results with Excel. Stay organized. Set up Outlook to track your email, contacts, appointments, and tasks. Make eye-catching presentations. Build PowerPoint slideshows with video and audio clips, animations, and other features. Use the programs together. Discover how to be more productive and creative by drawing directly in Word documents, adding spreadsheets to your slides, and more. About the Author Christopher Grover has worked as a technical writer, advertising copywriter, and product publicist for more than 25 years. His freelance articles have been published in a variety of magazines from Fine Homebuilding to CD-ROM World. He's also the author of Word 2007: The Missing Manual and Flash CS5: The Missing Manual. Table of Contents hapter 1 Introduction Keeping Up with the Macs More Integrated Than Ever What’s New in Office 2011 The Very Basics About This Book About the Online Resources Safari® Books Online Word Chapter 2 Word Basics: Opening, Editing, Saving, Printing Document Basics Covered Quickly Creating New Documents Opening Documents Your Point of View Basic Editing in Word Undo, Redo and Repeat Save Me Printing from Word Chapter 3 Advanced Editing in Word Toolbars and the Ribbon Lists: Bulleted and Numbered Line, Page, and Column Breaks Find and Replace AutoText: Abbreviation Expanders Spelling and Grammar AutoCorrect Adding and Formatting Tables Inserting Photos and Media Recording and Running Macros Organizing Your Templates Chapter 4 Setting Up Documents and Pages Let Word Format Your Document Automatically Choose a Template Choose a Theme Choose a Quick Style Manually Formatting Your Document Choosing Paper Size and Layout Setting Margins Adding Color, Borders, and Watermarks Adding Page Numbers, Headers, and Footers Dividing Your Document into Sections Formatting Paragraphs with Styles Manual Paragraph Formatting Formatting Individual Characters Chapter 5 Printing Documents, Envelopes, and Labels Choosing a Printer Printing to an Adobe PDF File Printing Part of Your Document Printing Envelopes Printing Labels Changing Your Print Preferences Understanding Mail Merge Basics The Six Phases of a Mail Merge Running the Mail Merge Manager Advanced Merge Techniques Merging to Labels and Envelopes Chapter 6 Working with Long Documents Switching to Outline View Promoting and Demoting Headings Controlling Subheads During Promotion or Demotion Moving Outline Items Showing Parts of Your Outline Notebook: Collecting Random Thoughts Navigating a Large Document Creating a Table of Contents Creating an Index Navigating with Hyperlinks Cross-Referencing Your Document Creating Footnotes and Endnotes Inserting Citations and Creating a Bibliography Chapter 7 Moving Beyond Text: Publishing Layout View Starting with a Template: Ready-to-Use Page Designs Choosing and Using a Template Adding, Removing and Rearranging Pages Adding Text and Text Boxes Adding Photos, Clip Art, and Other Graphics Chapter 8 Working Collaboratively Adding Comments Tracking Changes While Editing Printing Edits and Markup Accepting and Rejecting Changes Comparing and Merging Documents Merging Two Documents Protecting Your Document from Changes Sharing Documents over SkyDrive or SharePoint Outlook Chapter 9 Outlook: Email and Life Management 101 Starting Outlook the First Time Outlook Tour Sending Emails with Outlook Receiving Email Chapter 10 Managing Your Contacts Creating New Contacts Importing Contacts Creating Contact Groups Organizing and Searching for Contacts Printing Contacts Chapter 11 Calendar: Meetings, Tasks, and Notes Creating Appointments and Meetings Adding Meetings Filtering the Displayed Events Printing Calendars Be Your Own Task Master Taking Note Chapter 12 Customizing Outlook and Managing Data Changing the Look of Outlook Creating Your Own Categories Using Folders and Smart Folders Creating Smart Folders Creating Email Rules Create Multiple Outlook Identities Using My Day As Outlook Lite Excel Chapter 13 Basic Excel Spreadsheet Basics Formula Fundamentals Chapter 14 Building Advanced Workbooks Naming Cells and Ranges References: Absolute and Relative Workbooks and Worksheets Advanced Formula Magic Chapter 15 Excel Data Magic Excel Tables, the New List Maker Building Your Table Table Formatting Tricks Sorting and Filtering Your Table The Calculating Table Working with Databases Analyzing and Viewing Your Data Chapter 16 Excel Macros and Visual Basic Recording and Playing Macros Introducing Visual Basic for Applications Chapter 17 Formatting and Charts: Well-Dressed Spreadsheets Formatting Worksheets Charts Sparklines: Small, Intense, Simple Datawords Chapter 18 Printing and Sharing Spreadsheets Printing Worksheets Sharing a Workbook PowerPoint Chapter 19 Planning and Creating Great Presentations Planning the Presentation Delivering the Presentation Presentation Hardware Chapter 20 Building a PowerPoint Presentation Step 1. Choose a Template Step 2: Specify a Theme Step 3: Add Slides and Choose Layouts Step 4: Writing the Outline Step 5: Building the Show How to Build a Slide Chapter 21 Putting On the Show Adding Movement Putting On the Show Recycling Your Presentations Printing Your Presentation Office As a Whole Chapter 22 Making the Most of Graphics and Media Inserting a Graphic or Media Clip The Clip Art Gallery AutoShapes, Lines, SmartArt, and WordArt Modifying Graphics with the Format Dialog Box Storing Favorites in the Scrapbook Object Linking and Embedding (OLE) Chapter 23 Customizing Office Customizing the Ribbon Customizing Your Toolbars Redesigning Your Menus Reassigning Key Combinations AppleScripting Office What is AppleScript? Installing and Running Office Scripts Appendixes Appendix Installation and Troubleshooting Installing Office Troubleshooting Appendix The Office Help System Office Help Help from Mac OS X Web-Based Help Appendix Office 2011, Menu by Menu Application Menu Excel Menus File Menu Edit Menu View Menu Insert Menu Format Menu Tools Menu Data Menu Chart Menu Window Menu Help Menu Scripts Menu Outlook Menus File Menu Edit Menu View Menu Message Menu Draft Meeting Contact Task Note Format Menu Tools Menu Window Menu Help Menu Scripts Menu PowerPoint Menus File Menu Edit Menu View Menu Insert Menu Format Menu Arrange Tools Menu Slide Show Menu Window Menu Help Menu AppleScript Menu Word Menus File Menu Edit Menu View Menu Insert Menu Format Menu Font Menu Tools Menu Table Menu Window Menu AppleScript Menu Help Menu Appendix SkyDrive and Office Web Apps Why Compute in the Cloud? Signing Up for SkyDrive and Office Web Apps Storing Files on SkyDrive Working with the Office Web Apps Colophon