Visit www.dummies.com/cheatsheet/office2011formac to view this books’ cheat sheet.
Table of Contents
About This BookConventions Used in This BookFoolish AssumptionsHow This Book Is OrganizedIcons Used in This BookWhere to Go from Here
The Three Faces of Office for Mac 2011Installing Office 2011Setting Up with Setup Assistant
What’s New and GoodThe suite lifeWordPowerPointExcelOutlookWhat’s New but BadTogether, They’re Better
Using Menus in Office ApplicationsToolbars, Ribbons, and Palettes: Think “Visual” MenusTraversing toolbarsReveling in the RibbonTinkering with the ToolboxCustomizing Toolbars, Menus, and Keyboard ShortcutsCreating and Saving DocumentsUsing the Gallery to open templates or recent documentsSaving a documentSaving (And Using) Documents “In the Cloud”Saving a file on a SkyDrive or SharePoint locationSharing a file you’ve saved using SkyDrive or SharePointOpening a file you’ve saved on your SkyDrive or SharePoint locationWhat’s Your Preference? Understanding Application PreferencesApplication preferences: Why?Application preferences: How?Help: It’s more than just a Beatles movie
Chapter 4: Getting to Know Microsoft WordUsing a Variety of Versatile ViewsDraft viewPrint Layout viewFull Screen viewNotebook Layout and Publishing Layout viewsOutline viewWeb Layout viewZoom, zoom, zoomGetting Around in Your DocumentA scroll new world: Navigating by using the mouseNavigating by using keyboard navigationChapter 5: Processing Documents with WordAdding Text and Graphics to Your DocumentEntering text in your documentInserting an image in your documentSelecting Text for Editing and FormattingFormatting Text, Paragraphs, and ImagesChanging the look of the fontChanging the look of paragraphsChanging the look of imagesCopying Words and Images from Other SourcesDragging and droppingCopying and pastingOther Document ElementsWorking with elements in your documentChapter 6: Refining and Editing Documents with WordMoving Text and Images in Your DocumentsMoving items easily within a documentUsing special Word features that make moving stuff easierCheck It Out: Checking Your Spelling, Grammar, and HyphenationDouble-checking your spelling and grammarCorrecting your errors automatically with AutoCorrectHypnotic hyphenationDiscovering the Word Reference ToolsThe thoroughly terrific thesaurusThe online reference toolsSaving Time with the Find and Replace FeatureFinding and replacing textUsing Find and Replace to make formatting changesUsing advanced search options to get even more done fastChapter 7: Going for the Designer Look: Using Templates and Other Design ElementsCanned Design: Working with Word TemplatesGetting started with the Document GallerySample project: Starting a custom invoice from a templateCustomizing a Word templateSaving your customized templateAdding Basic Design Elements to Your DocumentImagine that: Adding and resizing an imageMoving images around documentsCreating headers and footersAdding lines to your header or footerArranging text with some help from tabsSetting Tabs, Margins, and Other Types of IndentsSetting tabsMaking your marginsColumns and Lists and Text Boxes (Oh, My)Column creationLists made easy (and pretty)Text anywhere with text boxesWorking with TablesCreating a tableFormatting a tableChapter 8: This and That: Advanced and Collaboration FeaturesGoing in Style: Defining Styles for Easy FormattingThe easy way: Defining a style by exampleThe harder way: Defining a style by dialogCustomizing Toolbars, Menus, and Keyboard ShortcutsCustomizing toolbars and menusCustomizing keyboard shortcutsCreating a Table of Contents AutomaticallyUsing Collaboration FeaturesAddressing Envelopes and Creating LabelsCreating and printing an envelopeCreating labelsCreating Web Pages
Chapter 9: Getting to Know Microsoft PowerPointViewing Slides with the Various ViewsNormal viewSlide Sorter viewSlide Show viewNotes Page viewPresenter viewPlanning Your Presentation: A Few Tips for Making Your Slide Shows BetterUse the 10/20/30 ruleStart with an outlineChapter 10: Creating Slide ShowsGetting StartedGiving Your Presentation a Visual ThemeUsing a theme “as is”Customizing a theme’s colors or fontsUsing Labor-Saving Slide LayoutsMastering Slide MastersWorking with title and text objectsWorking with PowerPoint ObjectsFormatting tablesCreating a chartGet smart: Use SmartArtMore media: Adding images, movies, or soundsUsing Quick Styles and EffectsAligning, arranging, and distributing objectsChapter 11: Making Your Slide Shows SingUsing Transitions to Create a Polished-Looking PresentationApplying transitionsTransition optionsUsing Custom AnimationAnimating text or graphicsAnimating a chart or SmartArt graphicCreating Interactivity with Action ButtonsShare and Share AlikePrinting hard copyExporting (saving) your presentations as filesChapter 12: Presentation MasteryUsing the PowerPoint Tools for More Effective SlidesWorking with the basic PowerPoint toolsUsing hyperlinksRecording narrationMaking the Most of Your PowerPoint PresentationRehearsing and setting slide timingsUsing the presenter toolsWorking with a single display
Chapter 13: Getting to Know Microsoft ExcelInterfacing with Excel’s User InterfaceUnderstanding the Concept of Rows, Columns, and CellsUsing the ViewsNavigating within Your SpreadsheetsChapter 14: Crunching Numbers (And Data) with ExcelWorking with TemplatesChoosing a local templateWorking with online templatesEntering, Formatting, and Editing Data in CellsCopying and Pasting Data (And Formatting) Between CellsAutoFilling CellsUnderstanding Formulas and FunctionsCreating a formulaKeeping track of Excel formulas with the Formula BuilderUsing the Error Checking FeatureSorting and Filtering DataSorting dataUsing filters to narrow your data searchesFinding and Replacing DataChapter 15: Enhancing and Printing Your Excel SpreadsheetsCreating and Formatting ChartsIncluding Pictures and ShapesAdding Formatting and Special EffectsCreating and Sorting Custom ListsCreating a custom listSorting a listAdding Headers and FootersCreating a header or footerEditing a header or footerPrinting Your SpreadsheetsPreparing for printing with Page SetupReady, set, printChapter 16: Advanced SpreadsheetingCustomizing ExcelPreferencesToolbars and menusConditional FormattingNaming a Cell RangeWorking with Multiple WorksheetsHyperlinkingCollaboration and Revision Tracking (a.k.a. Change Tracking)Sharing a workbookTracking your changesAccepting and rejecting your changes
Chapter 17: Getting to Know OutlookTaking a Quick Tour of OutlookThe Mail moduleThe Contacts moduleThe Calendar moduleThe Notes and Tasks modulesChapter 18: Outlook OnlineSetting Up Outlook for E-MailSetting up your e-mail automaticallySetting up your e-mail account manuallySending, Receiving, and Managing Your E-MailCreating and sending messagesReceiving messagesDealing with junk mailManaging your e-mailChapter 19: Managing Your Affairs with OutlookManaging Your Crew with the Contacts ModuleAdding and removing contactsWorking with contactsDelving into the Home tabScheduling Events with the CalendarUnderstanding NotesTracking Progress with the Tasks ModuleChapter 20: Getting Advanced with OutlookCustomizing: It’s Not Just for Hot Rods AnymoreTweakin’ the toolbar and reducin’ the RibbonFine-Tuning Your Outlook LayoutConcentrating on columnsHiding and showing interface elementsThe fast way to start an Advanced SearchWhat’s Your Preference?Colonel Parker, meet General PreferencesRoll over, Beethoven, and catch the E-Mail preferencesEverything but the Kitchen Sync
Chapter 21: Ten Things in Office 2011 That Didn’t Fit ElsewhereMy DayMicrosoft MessengerClip GalleryFree Online Content for Clip GalleryHolidays on Your CalendarPlay Windows Media Files FreeOfficial Microsoft Web SitesThe Database Utility (For Outlook)A Multitude of FontsMicrosoft CommunicatorChapter 22: Ten Timesaving Shortcuts and Tips for Enhanced ProductivityMemorize Keyboard ShortcutsGet to Know Your PreferencesSave a Document As a PDF FileSave Time by Using the Share⇒E-Mail (As Attachment) Menu ItemSave Time and Effort with Automator Work FlowsUse the Open Recent Feature to Open Items from the DockGet HelpUse the Format PainterChoose the Notebook Layout for Lectures (Word Only)Don’t Forget Your Free SkyDriveChapter 23: Ten Ways to Customize OfficeMake Your Toolbars and Menus Work Harder for YouHide the Standard Toolbar CompletelyModify Existing ToolbarsModify Existing MenusCreate a New Toolbar for Frequently Used CommandsDeal with Frequently Used DocumentsRemove Unused Keyboard ShortcutsChange an Existing Keyboard ShortcutCreate a New Keyboard ShortcutCreate Your Own TemplatesCheat Sheet
Microsoft® Office 2011 for Mac® For Dummies®
Office 2011 for Mac® For Dummies®
Published byWiley Publishing, Inc.111 River StreetHoboken, NJ 07030-5774
www.wiley.com
Copyright © 2011 by Wiley Publishing, Inc., Indianapolis, Indiana
Published by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions.
Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything Easier, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates in the United States and other countries, and may not be used without written permission. Microsoft is a registered trademark of Microsoft Corporation. All other trademarks are the property of their respective owners. Wiley Publishing, Inc., is not associated with any product or vendor mentioned in this book.
Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with respect to the accuracy or completeness of the contents of this work and specifically disclaim all warranties, including without limitation warranties of fitness for a particular purpose. No warranty may be created or extended by sales or promotional materials. The advice and strategies contained herein may not be suitable for every situation. This work is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional services. If professional assistance is required, the services of a competent professional person should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Website is referred to in this work as a citation and/or a potential source of further information does not mean that the author or the publisher endorses the information the organization or Website may provide or recommendations it may make. Further, readers should be aware that Internet Websites listed in this work may have changed or disappeared between when this work was written and when it is read. FULFILLMENT OF EACH COUPON OFFER IS THE SOLE RESPONSIBILITY OF THE OFFEROR.
For general information on our other products and services, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002.
For technical support, please visit www.wiley.com/techsupport.
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in electronic books.
Library of Congress Control Number: 2011920765
ISBN: 978-0-470-87869-9
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
About the Author
Bob LeVitus, often referred to as “Dr. Mac,” has written nearly 60 popular computer books, including iPhone For Dummies, iPad For Dummies, Incredible iPad Apps For Dummies, and Incredible iPhone Apps For Dummies for Wiley Publishing, Inc.; Stupid Mac Tricks and Dr. Macintosh for Addison-Wesley; and The Little iTunes Book and The Little iDVD Book for Peachpit Press. His books have sold more than a million copies worldwide.
Bob has penned the popular Dr. Mac column for the Houston Chronicle for the past ten years and has been published in dozens of computer magazines over the past 16 years. His achievements have been documented in major media around the world. (Yes, that was him juggling a keyboard in USA Today a few years back!)
Bob is known for his expertise, trademark humorous style, and ability to translate techie jargon into usable and fun advice for regular folks. Bob is also a prolific public speaker, presenting more than 100 Macworld Expo training sessions in the U.S. and abroad, keynote addresses in three countries, and Macintosh training seminars in many U.S. cities. (He also won the Macworld Expo MacJeopardy World Championship three times before retiring his crown.)
Bob is considered one of the world’s leading authorities on Mac OS. From 1989 to 1997, he was a contributing editor/columnist for MacUser magazine, writing the Help Folder, Beating the System, Personal Best, and Game Room columns at various times.
In his copious spare time, Bob heads up a team of expert technical consultants who do nothing but provide technical help and training to Mac users, via telephone, e-mail, and/or our unique Internet-enabled remote control software, which allows them to see and control your Mac no matter where in the world you may be.
If you’re having problems with your Mac, you ought to give them a try. You’ll find them at www.boblevitus.com or 408-627-7577.
Prior to giving his life over to computers, LeVitus spent years at Kresser/Craig/ D.I.K. (a Los Angeles advertising agency and marketing consultancy) and its subsidiary, L & J Research. He holds a BS in Marketing from California State University.
Dedication
This book is dedicated to my wife, Lisa, who taught me almost everything I know about almost everything I know except technology. And to my awesome kids, Allison and Jacob, who love Apple technology almost as much as I love them (my kids, not my Macs, iPhones, iPads, etc.).
Author’s Acknowledgments
Special thanks to the tireless teams at Microsoft and Edelman P.R. (you know who you are), who worked overtime to help me turn this book around in record time: I couldn’t have done it without you.
Thanks also to super-agent Carole McClendon, for deal-making and moral support, yet again. You’ve been my agent for over 21 years and you’re still the best.
Big-time thanks to the gang at Wiley — all of the editors, production, graphics, marketing, sales, and other personnel who worked tirelessly to make this book a success. You guys totally rock!
I’d also like to extend extra special thanks to Mark Chambers, for revising a number of chapters when I was juggling three books in production at once.
Thanks to my family and friends, for putting up with me during my all-too lengthy absences during this book’s gestation.
And last, but certainly not least, thanks to you, gentle reader, for buying this book.
Publisher’s Acknowledgments
We’re proud of this book; please send us your comments at http://dummies.custhelp.com. For other comments, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002.
Some of the people who helped bring this book to market include the following:
Acquisitions, Editorial, and Media Development
Project Editor: Pat O’Brien
Acquisitions Editor: Bob Woerner
Copy Editor: Becky Whitney
Technical Editor: Dennis Cohen
Editorial Manager: Kevin Kirschner
Media Development Project Manager: Laura Moss-Hollister
Media Development Assistant Project Manager: Jenny Swisher
Media Development Associate Producers: Josh Frank, Marilyn Hummel, Douglas Kuhn, and Shawn Patrick
Editorial Assistant: Amanda Graham
Sr. Editorial Assistant: Cherie Case
Cartoons: Rich Tennant (www.the5thwave.com)
Composition Services
Project Coordinator: Patrick Redmond
Layout and Graphics: Joyce Haughey, S. D. Jumper
Proofreaders: Laura Bowman, Rebecca Denoncour, John Greenough
Indexer: Glassman Indexing Services
Publishing and Editorial for Technology Dummies
Richard Swadley, Vice President and Executive Group Publisher
Andy Cummings, Vice President and Publisher
Mary Bednarek, Executive Acquisitions Director
Mary C. Corder, Editorial Director
Publishing for Consumer Dummies
Diane Graves Steele, Vice President and Publisher
Composition Services
Debbie Stailey, Director of Composition Services
Introduction
You made the right choice twice: Office 2011 for Mac and this book.
Take a deep breath and get ready to have a rollicking good time. That’s right — this is a computer book, but it’s fun. What a concept! Whether you’re brand-spanking new to the Office suite or a grizzled old Office veteran, I guarantee that discovering the ins and outs of Office 2011 for Mac with this book is fun and easy.
About This Book
Why write a For Dummies book about Office 2011 for Mac? Well, Office 2011 for Mac is a big, somewhat complicated suite of productivity applications, so I made Office 2011 For Mac For Dummies a not-so-big, not-so-complicated book that shows you how to perform the most common tasks you’re likely to perform using Office 2011 for Mac, all without boring you to tears, confusing you, or poking you with sharp objects.
In fact, I think you’ll be so darned comfortable that I wanted the title to be Office 2011 For Mac without Discomfort, but the publisher wouldn’t let me. Apparently, we For Dummies authors have to follow some rules, and using For Dummies and Office 2011 For Mac in this book’s title are among them.
Speaking of dummies, remember that it’s just a word. I don’t think you’re dumb — quite the opposite! My second choice for this book’s title was Office 2011 For Mac For People Smart Enough to Know That They Need Help Using It, but you can just imagine what the Wiley folks thought of that. (“C’mon, that’s the whole point of the name!” they insisted. “Besides, it’s shorter this way.”)
Anyway, the book is chock-full of information and advice, explaining everything you need to know about Office 2011 for Mac in language you can understand — along with giving you timesaving tips, tricks, techniques, and step-by-step instructions, all served up in generous quantities.
Conventions Used in This Book
To get the most out of this book, you need to know how I do things and why. I use a few conventions in this book to make your life easier:
When I want you to open an item on a menu, I write something like “Choose File⇒Open,” which means, “Pull down the File menu and choose the Open command.”
Stuff you’re supposed to type appears in bold type, like this.
Sometimes an entire a sentence is in boldface, as you see when I present a numbered list of steps. In those cases, I leave the bold off what you’re supposed to type, like this.
Web addresses and characters that appear onscreen are shown in a special monofont typeface,
like this
.
For keyboard shortcuts, I write something like Command+A, which means to hold down the Command key (the one with the little pretzel or
symbol on it) and then press the A key on the keyboard. If you see Command+Shift+A, you hold down the Command and Shift keys while pressing the A key. Again, for absolute clarity, I never refer to the Command key with the
symbol, even though some keyboards display both symbols on that particular key.
Foolish Assumptions
Although I know what happens when you make assumptions, I’ve made a few, anyway. First, I assume that you, gentle reader, know nothing about using Office — beyond knowing what it is, that you want to use it, that you want to understand it without digesting an incomprehensible technical manual, and that you made the right choice by selecting this particular book.
And so, I do my best to explain each new concept in full and loving detail. Maybe that’s foolish, but — oh, well.
Oh, and I also assume that you can read. If you can’t, just ignore this paragraph.
How This Book Is Organized
Office 2011 for Mac For Dummies is divided into six parts. As you probably know, For Dummies books are designed to give you the information you need about a feature or task without having to read the book from cover to cover, so feel free to skip around and read the parts that interest you most. Here’s a summary of what the parts contain:
Part I: Introduction to the Microsoft Office 2011 Suite: This first part amounts to basic training. Along the way, you can find out about the three different Office editions, how to install Office, and how to ensure that the version you use is always updated in a timely fashion.
Part II: Mastering Microsoft Word: In this part, you discover everything you need to know about using spreadsheets. Just kidding. You get to know spreadsheets in Part IV, whereas in this part, I tell you lots of important stuff about processing words with Microsoft Word.
Part III: Powerful Presentations with Microsoft PowerPoint: This part is all about letting it slide. I mean slide shows, of course. Microsoft PowerPoint is the Office application you use to create presentations, also known as slide shows. So, in Part III, you get the goods on PowerPoint and how to create great slide shows.
Part IV: Crunching Data with Microsoft’s Most Excellent Excel: Microsoft Excel is the spreadsheet application of the Office suite, so of course, Part IV delves into the wonderful world of numbers — in rows, columns, formulas, and notebooks. Not only that, but this part shows you how to spiff up those numbers to make them look really pretty.
Part V: Microsoft Outlook: Miraculous Manager of Most Things: In Part V, you meet the last of the Big Four applications in the Office suite: Microsoft Outlook. This virtual smorgasbord of functionality includes an e-mail client, address book, and appointment calendar, plus notes, tasks, a to-do list, and project managers.
Part VI: The Part of Tens: Finally, “The Part of Tens” (which might have started life as a David Letterman rip-off) includes ten things you should know about that didn’t fit elsewhere in the book, plus ten timesaving shortcuts and ten ideas for customizing Office so that it works the way you want it to work.
Icons Used in This Book
Little round pictures (icons) appear to the left side of the text throughout this book. Consider these icons miniature road signs, telling you a little something extra about the subject at hand. Here’s what the different icons look like and what they all mean:
Where to Go from Here
Go to a comfortable spot (preferably not far from a Mac) and look through this book.
In the first few chapters, I describe the basic everyday topics you need to understand in order to operate your Mac effectively. If you’re new to Macs and Office 2011 for Mac, start at Chapter 1.
Even though Office 2011 for Mac is somewhat different from previous versions, the discussion in the first part of this book is so basic that if you’ve been using Office awhile, you might think you know it all — and you might know most of it. But, hey! Not-so-old-timers need a solid foundation. So read what you need and skip the rest.
You can send snail mail in care of Wiley Publishing, Inc., or send e-mail to me directly at Office2011@boblevitus.com
. I appreciate your feedback, and I try to respond to all reasonably polite e-mail within a few days.
Does this book work for you? What do you like? What don’t you like? What questions are unanswered? Do you want to know more about something? Do you want to find out less about something? Tell me! I have received more than 100 suggestions about previous editions, most of which are incorporated here. So keep up the good work!
What are you waiting for? Go — enjoy the book!
Part I
Introduction to the Microsoft Office 2011 Suite
In this part . . .
Wether you’re a longtime Office user or Office 2011 for Mac is your first experience with using an Office suite, you have to learn to crawl before you can walk (much less run).
In this part, you can start with a broad overview of the various versions of Office 2011 for Mac available for purchase and how to install and set them up. Then I briefly introduce you to the four major applications that comprise the Office suite. You can check out some features that are new or improved in the 2011 edition and take a quick look at how this quartet plays nicely together. Finally, you explore Office features that work the same way in all four applications, such as menus, toolbars, preferences, and help.
So get comfortable, roll up your sleeves, fire up your Mac if you like, and grab your Office 2011 for Mac install disc if you haven’t yet installed the software.
Chapter 1
Overview from 10,000 Feet
In This Chapter
Deciding which of the three editions of Office for Mac 2011 to buy
Installing Office 2011
Getting set up using the Setup Assistant
Removing Office 2011
Over the next several hundred pages, you can find out in detail about the applications that make up the Microsoft Office for Mac 2011 suite. But first you must decide which version of the suite you want or need (there are three of ’em), acquire a copy of it, and then install it and find out how to update it to ensure that you’re always running the latest and greatest (not to mention most stable) version.
So, without further ado, dig in!
The Three Faces of Office for Mac 2011
Microsoft Office for Mac 2011 comes in three tasty flavors:
Office for Mac Home and Student 2011
Office for Mac Home and Business 2011
Office for Mac Academic 2011
The three editions have this in common: All three have the exact same versions of the “big three” applications — Word, Excel, and PowerPoint — plus a copy of Microsoft Messenger (an instant messaging, or IM, program that you can download from the Microsoft Web site for free). The differences between the editions lie in which features you get in addition to the big three:
Microsoft Office for Mac Home and Student 2011: The retail price is $119 for a single install or $149 for a Family Pack with three installs. As the least expensive edition, it includes the big three applications and Messenger and nothing more. Of course, many (if not most) users need nothing more, so unless you can find a compelling reason to spend two or three times more money for the same three applications, this edition is the most affordable.
Note that this edition does not include Microsoft Outlook. Outlook, sometimes called the “Swiss army knife of personal communications software,” combines an e-mail client with an address book, a calendar, to-do lists, and searchable notes in a single application.
Unless you dislike the Mail, Address Book, and iCal applications that are included with Mac OS X, you probably won’t miss Outlook much. And, if you’re a student or a staff or faculty member in higher education, you may qualify for the $99 single-install Academic edition, which does include Outlook. (See the third bullet1 in this list.)
Microsoft Office for Mac Home and Business 2011: The retail price is $199 for a single install or $279 for a Multi-Pack with two installs. What do you get for the additional dough? In two words: Microsoft Outlook.
What’s that, you say? You don’t know whether you need Outlook? Well then, I suggest that you save yourself a bundle and start with the Home and Student Edition. If you later determine that you do need Microsoft Outlook, you can upgrade to the Home and Business edition online.
Microsoft Office for Mac Academic 2011: The retail price is $99 but is available only to higher-education students, staff, and faculty. This edition includes everything in the Home and Business edition (including Microsoft Outlook) at half the price. But in this case you have to prove that you’re in the field of higher education.
So there you have it — three editions for three budgets.
By the way, you don’t have to prove you’re a student (or live in a home) to purchase the Home and Student edition for $119, but you have to prove that you’re in the field of higher education to get the Academic edition for $99. The bottom line: For most users, the Home and Student edition is the most cost-effective way to acquire the big three Office applications.
Installing Office 2011
When you insert the Office 2011 DVD, you launch the Office Installer by double-clicking it.
The first screen you see is Welcome to the Microsoft Office for Mac 2011 Installer, which informs you that in order to install Microsoft Office, you need the username and password for an Administrator account on this Mac. If you have no Administrator account and password handy, it would behoove you to get one now.
This screen also recommends that you temporarily disable any virus protection applications on this computer before you continue. That’s a good idea, so if you’re running any antivirus software, disable it before you proceed or else it can interfere with your installation.
When you have both of the aforementioned ducks in a row (you have an Administrator account name and password and have disabled all antivirus software), click the Continue button.
The second screen displays the license terms. Because you must accept these terms to use the software, you should read every word before you even think about clicking the Continue button.
When you’re done reading, click the Continue button. A sheet with three buttons — Agree, Disagree, and Read License — appears. Assuming that you’ve read the agreement already, I strongly suggest that you click Agree. If you haven’t read the agreement, click the Read License button to return to the second screen, where you can read the fine print. Or, if you read it and disagree, click the Disagree button and the Installer quits. In other words, unless you specify that you agree, you can’t install the software.
The next screen, labeled Select a Destination, lets you choose the destination disk for the software installation. Click the hard disk icon in the middle of the window to select the disk you want to install the software on, and then click Continue.
The next screen is labeled Standard Install on [your hard drive’s name] at the top. The Microsoft Office 2011 folder is installed in your Applications folder by default. If you want to install the Office folder elsewhere, click the Change Install Location button and select another destination.
Before you click the Install button, click the Customize button and deselect any items you don’t want to install.
Now click the Install button to open an authentication window so that you can provide an administrator name and password. Do so and then click OK. Go get yourself some coffee or a soft drink — you have a bit of time.
When the installation is complete, the screen informs you that the installation was successful and the software was installed. D’oh. Click the Close button and the Office Setup Assistant launches itself.
Setting Up with Setup Assistant
The Welcome to Office for Mac 2011 screen appears with the following three options:
Enter Your Product Key: Click this option and then type your product key, which you can find in the box with your installation disc. When you’re done, click the Continue button to see a screen acknowledging that your copy has been activated. Your product ID number also appears on this screen with the suggestion that you store it with your records because you’ll need it in order to register or obtain technical support.
If you forget the product ID number or fail to write it down and “keep it with your records,” you can find it in the About dialog box for Excel, PowerPoint, or Word.
Try Free for 30 Days: If you have a demo version of Office for Mac 2011, click this option to use the software without a product key for as long as 30 days.
Purchase a Product Key Online: Click this option and follow the onscreen instructions to purchase a product key on the Web.
At this point, you may or may not see a screen congratulating you or encouraging you to enjoy the demo, or telling you something entirely different. Click Continue.
A screen offers to either use your existing settings (from an earlier version of Office for Mac) or create new settings. Click an option and then click Continue.
Next is the Keep Office Up to Date screen, which offers two simple yes-or-no options: Keep Office for Mac Up to Date and Join the Customer Experience Improvement Program. Respond to both and then click Continue.
Before you complete this action, though, read this tip:
The second option determines whether you want to participate in the Microsoft Customer Experience Improvement Program. Office then occasionally sends information about your hardware and how you use Office (as well as information on crashes, freezes, and unexpected shutdowns) to Microsoft via the Internet. No personal information is sent; it’s totally anonymous. Click the radio button for Yes or No, and then click the Continue button.