Office 2011 for Macintosh: The Missing Manual
Publisher: O'Reilly Media
Final Release Date: December 2010
Pages: 816

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.
Table of Contents
Product Details
About the Author
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
O'Reilly MediaOffice 2011 for Macintosh: The Missing Manual
 
4.6

(based on 8 reviews)

Ratings Distribution

  • 5 Stars

     

    (5)

  • 4 Stars

     

    (3)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

100%

of respondents would recommend this to a friend.

Pros

  • Accurate (7)
  • Easy to understand (7)
  • Helpful examples (7)
  • Well-written (6)
  • Concise (3)

Cons

    Best Uses

    • Intermediate (6)
    • Novice (6)
    • Expert (4)
    • Student (3)
      • Reviewer Profile:
      • Developer (3)

    Reviewed by 8 customers

    Sort by

    Displaying reviews 1-8

    Back to top

     
    5.0

    Keeps up the MM tradition

    By dwr

    from Milan, Italy

    About Me User

    Verified Buyer

    Pros

    • Accurate
    • Concise
    • Easy to understand
    • Helpful examples
    • Well-written

    Cons

      Best Uses

      • Intermediate

      Comments about O'Reilly Media Office 2011 for Macintosh: The Missing Manual:

      useful guide round an always increasingly complex package

      (2 of 2 customers found this review helpful)

       
      4.0

      A Really Solid Manual

      By RogB

      from Sunshine Coast, Qld, Australia

      About Me Educator

      Verified Reviewer

      Pros

      • Accurate
      • Easy to understand
      • Helpful examples
      • Well-written

      Cons

        Best Uses

        • Expert
        • Intermediate
        • Novice
        • Student

        Comments about O'Reilly Media Office 2011 for Macintosh: The Missing Manual:

        Office 2011 is out and it is said to have major upgrades and changes from the previous version, Office 2008. So this means it is time to look for a manual!

        O'Reilly has provided me with a review copy of the definitive manual, Office 2011 for Macintosh – The Missing Manual, by Chris Glover. Physically this is a serious book and easily passes the weight test at 1.1 kilograms. It has 789 pages, including a 37 page index, plus a 13 page table of contents.

        The book has separate Parts for Word, Outlook, Excel, PowerPoint and Using Office as a Whole. There are also Appendices for installation, troubleshooting, help, menus and SkyDrive and web apps.

        Most people, including me, are not going to sit down and read this manual from cover to cover. It's more a case of pick a subject and read up on it. Initially the subject might be 'installation' or 'getting started'. Then it might be one of the 'basics' chapters on Word or one of the other components. Later as need arises the more advanced chapters might be approached.

        Of course the large, comprehensive index is a dead giveaway that this is a good reference book. So if you get stuck in using Office, it's easy to check out the item in the index. I went searching for some of my favourite tricky subjects and found myself directed to them easily.

        The manual gives a good coverage of Office. It clearly separates the basic and advanced material, making it easy to follow. There is a good depth for those needing to know more on the power behind the scenes. There are plenty of graphics and the layout includes lots of headings.

        I was disappointed in one aspect of the manual. I have been an Entourage (the mail/ address/ calendar program in earlier Mac Office versions) user for some years. It has been replaced in Office 2011 by Outlook to be consistent with the PC version. Nowhere in the manual could I find a reference to converting my Entourage data to Outlook. Maybe it just happens when you install Office 2011, I don't know.

        I have heard it said that most users will only use 20% or less of the power of Office, but one person's 20% will not be the same as the next person's. And then there are the power users who will need to know all there is about certain functions in Word or Excel – or maybe even add a few themselves using the built in programming language. One way or another this manual seems to cater for all users.

        A typical 20% user with no interest in learning more might think that a manual would be of no use. I disagree – sometimes I will browse a manual for an application that I know well and almost always will discover something I didn't know. It might be an easier way of doing things or an explanation of some behaviour I hadn't understood. All good for frustration reduction! Of course you can always accept that there is something new to learn that could enrich your using experience.

        If you feel that you don't need the solid book version you could consider the eBook version. It's cheaper and easier to search using the power of electronics, but perhaps not as convenient to read or browse.

        So, do I recommend it? Of course!

        (3 of 3 customers found this review helpful)

         
        5.0

        Easy to Read and Easy to Understand

        By DHMcLaughlin

        from Florida

        Pros

        • Accurate
        • Concise
        • Easy to understand
        • Helpful examples
        • Well-written

        Cons

          Best Uses

          • Expert
          • Intermediate
          • Novice

          Comments about O'Reilly Media Office 2011 for Macintosh: The Missing Manual:

          The Missing Manual series of computer books has always been a favorite of mine. Office 2011 for Macintosh: The Missing Manual is no exception. It is a comprehensive guide that is easy to read and easy to understand.

          Chris Grover provides detailed explanations and instructions on nearly every aspect of this feature rich, and often complicated, program (I say "nearly" to be cautious, although I cannot identify any aspect that he's missed). And, he does so with a very light touch of humor that is entertaining, but not distracting.

          Both thorough and clear, the descriptive explanations in the book are easy to follow. Reading the book from cover to cover is not necessary. It is just as useful if you want to skip around because each section stands on its own, and, when appropriate, points to additional, related material.

          If you like tutorial-style computer guides, which I do, you will enjoy the many instructions provided in step-by-step example form. Even the annotations on the illustrations aid in comprehending the program.

          One of my favorite aspects of the book is the way the author anticipates my questions, including questions of which I was not yet aware.

          I recommend this book highly to anyone who wants to delve into the depths of Office 2011 for Macintosh.

          Original review can be found here: http://dhmclaughlin.wordpress.com/2011/02/17/book-review-office-2011-for-macintosh-the-missing-manual-by-chris-grover/

          (4 of 4 customers found this review helpful)

           
          5.0

          thorough resource

          By garyinalaska

          from anchorage, ak

          About Me Educator

          Verified Reviewer

          Pros

          • Accurate
          • Easy to understand
          • Helpful examples
          • Well-written

          Cons

            Best Uses

            • Intermediate
            • Novice

            Comments about O'Reilly Media Office 2011 for Macintosh: The Missing Manual:

            Wading into the new Office 2011 is a journey, not a walk, and with this new version Microsoft bestowed a monumental amount of learning necessary but doesn't provide the learning tools to make it easy, so enter in a book that should have come with the software. Office 2011: the missing manual. Author and techie Chris Grover is skilled in his words used so as to not scare readers away who aren't as well versed as he is, and yet, invites us to learn, try out new features of the software, and know we can return to this book, as a resource, that alone is high praise from me, a book I'll return to. and since it's over 800 pages, there's plenty in-depth writing to savor or ponder.

            Ok, now what's in the book, and why should we buy it. I've used Office since the 2004 version, moved onto 2008, and now 2011, each time, it's amazing that additional features are offered, veiled in simplicity, so says Microsoft, and yet, we all want this suite to cover it all, from word processing with Word, spreadsheets with Excel, new to Office is Outlook for email, presentations with Power Point, all covered well. The table of contents alone must have taken so much time to write down, it's 13 pages, so easy to find what you want, then he also covers What's new in this version of Office. He's written many books, and knows his audience, we want it now and to the point, he does that well. A direct tone about the book, and detail. I liked his included 'Tips' too, that make reading easier yet. Author Chris also has a sense of humor. Yea.

            Let's take Chapter 9. Outlook: Email and Life Management 101.

            After you install Office, there's a big "O" for Outlook sitting in the dock. One click and you get a view of Outlook's somewhat busy window. The first thing Outlook encourages you to do is to set up an email account. If you had issues setting up an email account in the past, you're in for a pleasant surprise. In the new Outlook, the process is fairly simple, especially if your email is handled through one of the major providers such as MobileMe, Gmail, Yahoo, AOL, or Hotmail. In those cases, Outlook can handle most of the complicated details. You provide your email address and password, and Outlook can identify the service and automatically set up your account. If you have an email account through your company or some less famous provider, you may have a couple of extra steps.
            Make sure that you're connected to the Internet, and then follow these steps to set up an email account:
            1. Launch Outlook.
            If this is the very first time you launched Outlook, you're automatically prompted to set your email account.
            2. If this isn't your first time starting Outlook, go to Tools‚Accounts to open the Accounts window. Then, click the + button in the lower-left corner and choose E-Mail.
            When you click the + button, a menu with three options appears: Exchange (for offices that use Microsoft Exchange), E-mail (for regular old email accounts), and Directory Service (for network-based contact lists). After you choose Email, a box opens where you provide your email address and password as shown in Figure 8-2.
            Note: If you ever need to delete an email account, you do it in this same window: just select the account name and click the minus (-) button.

            He then offers an illustration of a Outlook contact from it's database that includes notes, to do list, and photo of the person. well done. It's always easier to see what an author wants to show us in my mind. I think the challenge is showing all of what Office or in this particular case, Outlook, does, it's huge. So the author goes through each task, how it's done, and what to watch for, that I liked and appreciated. His mind is easy to follow.. Another feature I liked was his " Starting Outlook, the First Time" with a graphic showing what the user actually sees, that's helpful, and I could follow easily. Illustrations are the bread crumbs on the path, leading us along, and Grover is excellent at showing us what to do, and how to do it. After getting us set up, he offers a tour, a good general look at Outlook's features, for there are many. and with illustrations. In Outlook's case, we're covering Mail, Calendar, Contacts, Tasks and Notes, each is explained. and another screen shot of what you'll see and do. I liked his Frequently Asked Question box at this point, shown here. Right on task, and helpful.

            The book continues for Excel, PowerPoint, and Word, same approach, useful, illustrated, easy to follow narrative. Part 5 is a chance to see it all come together, it's called Office as a Whole, and integrates, or tells the reader about using graphics and media, for Office 2011′s SmartArt graphics, the Clip Art Browser, AutoShapes, WordArt, and more built right in and shared among Word, Excel, and PowerPoint. He then shows how to insert a graphic or media clip, has an illustration, so the previous Word, or other components are integrated in a way that makes sense. He uses color, that helps in his illustrations/screen shots. Easy to follow. He moves on to Customizing Office, and begins with the biggest feature addition – The Ribbon, which Microsoft made to change with each component, Word, Excel, etc, and be dynamic, but the author says one can modify it. I like the way he gives the pro's and con's of change, and how it will affect the user. Here's some of his explanation, "Customizable toolbars are great for power-users, but average mortals usually only "customize" their toolbars by accident. So, the tools on a given tab on the ribbon stay put.
            That said, there are a few things you can do to show and hide elements of the ribbon, and you can rearrange the order of the tabs. In most cases, the process is similar in Word, Excel, and PowerPoint‚ this chapter lets you know where and when. Outlook doesn't let you customize ribbon features at all. The ribbon settings are specific for each application, so, for example, if you want to hide the ribbon entirely, you need to do that for each application."

            All in all, this book hits it's goals, targets, with the direct approach, easy to follow explanations, illustrations and screen shots that are easily readable, and most importantly, I find it a resource, meaning that I can return to it and find what I want, there is also in Part 6, an appendix that covers Help system, Installation and troubleshooting, SkyDrive and WebApps. He could offer a more detailed Table of Contents. The electronic version and printed version are the same, and I found either easy to switch between. I like the eVersion for it's quickness, and portability, using it on my iMac, iPad, or iPhone, all worked excellent. O'Reilly is a leader is thinking of what the reader will want, encouraging it's authors, and giving us what we want. Thanks.

             
            4.0

            simply, clearly, nicely explained

            By Michal Owsiak

            from Poland

            About Me Developer

            Verified Reviewer

            Pros

            • Accurate
            • Easy to understand
            • Helpful examples

            Cons

            • Too basic

            Best Uses

            • Novice
            • Student

            Comments about O'Reilly Media Office 2011 for Macintosh: The Missing Manual:

            Microsoft Office 2011 is a big leap in Mac world. It is faster, more stable and filled with lots of new features. It has a new look and feel as well. If you are like me, you'd rather stay with old good interface you have gotten used to. On the other hand, world will not wait and you have to follow the trend. This is the place were Office 2011 for Macintosh comes in handy. It helps you adapt to new circumstances, to completely redesigned user interface. I will not discuss the whole book here, because I don't use Outlook and Power Point at all - I simply don't belong to target group for these two products. However, when it comes to Word and Excel I can tell that Chris have done really good job. You will get basic information related to creating documents, templates, manipulating ribbon (quite useful), using style (believe me, I know people who format documents using Enter and space). Book discusses topics related to references and references management. This is really great feature that Pages '09 miss and makes Office better suited for scientific papers (unless you can not imagine anything else than LaTeX). Huge advantage of 2011 version is Visual Basic that was not available in 2008 edition for Mac. This is really, really huge step forward for Microsoft Office in Mac world. It makes this suite even more interesting. Chris touches slightly this topic, however you will be left unfulfilled. I'd recommend here Microsoft Office Excel 2007 Visual Basic for Applications Step by Step instead - if you are interested in Visual Basic programming. However, it's nice of Chris that he touches this topic as it is definitely worth mentioning. What I have found really interesting was explanation of pivot tables. Pivot tables are the endless topic of miss understanding. Lots of people can not get used to use them. Chris explains this topic very clearly and covers it with lots of examples. After reading this chapter you should not say that you don't understand pivot tables any more. I really enjoyed reading this book. I like the way material is presented - nicely formatted content, lots of examples, simple language. Keep in mind, however, that book addresses beginners and it doesn't cover all the aspects of Microsoft Office 2011.

            (4 of 4 customers found this review helpful)

             
            5.0

            As an eBook this is pure win.

            By Leo of BORG

            from Central Valley, California

            About Me Developer, Sys Admin

            Verified Reviewer

            Pros

            • Accurate
            • Concise
            • Easy to understand
            • Helpful examples
            • Well-written

            Cons

              Best Uses

              • Expert
              • Intermediate
              • Novice
              • Reference
              • Student

              Comments about O'Reilly Media Office 2011 for Macintosh: The Missing Manual:

              Upshot: I never was crazy about the phonebooks, but if you need a REAL help reference, in eFormat this is pure win. Minor issue: Since it's so big, TOC may bog down iBooks.

              Over the years, I've owned a couple of these 'Missing Manuals', and 'in real life' they're mini-phonebooks -- nuggets of the good stuff supported by an index that seems to be a quarter of the book. Jumping around one of these old books used to be a pain. Not now!

              Office 2011 for Macintosh: The Missing Manual may be no exception on the surface, but as an ebook; on iPad iBooks or with the Firefox ePub plugin --it's pure win.

              As with other Missing Manuals there's a lot of detail and steps to get you where you need to go, but instead of jumping around in paper and getting befuddled there's NO break of narrative as you read steps, jump to the figure and then (in iBooks at least) use the 'jump back' link -- usually found in the lower left bottom of the page when you have page status visible.

              I didn't have enough time to read the entire ePub, so I went for the sections that I needed a refresher in; Word and Excel. I had no problem going thru familiar features that Microsoft moved around (to the ribbon, mostly), catching up with new workflows that differed from Office:Mac 2004.

              For apps like Outlook & PowerPoint, that I don't intend to use, there's more than enough illustrations and walk-through to familiarize yourself with the 'rest of Office.'

              So. Is there any downside to this ePub? Not really, except that iBooks can get overwhelmed by the sheer size of this book. In the table of contents, every section down to single pages is listed -- this lead to massive scrolling slowdowns. Searching can also take more than a few seconds. But this does not detract from reading or jumping around.

              However, I think this is more an issue with iBooks 1.2 -- and actually I'll be emailing my contacts at Apple that they should use this book (as well as _Atlas Shrugged_ and maybe _Programming Python_) for their "big doc" testing.

              Verdict? As a Non-DRM ePub available from O'Reilly? Highly recommended.

              (1 of 1 customers found this review helpful)

               
              5.0

              A huge update for Mac Users

              By Doron Katz

              from Sydney, Australia

              Comments about O'Reilly Media Office 2011 for Macintosh: The Missing Manual:

              A huge update for Mac Users who have been trying to keep their enterprise-applications on-par with their Windows counterparts, and with Microsoft's great leap, Office 2011 for Mac is definitely the 'missing manual' for users like me. Well I must admit, I have used Windows' Office a few years ago but have been stuck on iWorks for the past 3 years. With Outlook replacing exchange and having the other Office tools become more in-sync with the Windows version, I decided to make the leap myself. Reviewing Chris Grover's book, whilst being extremely thick, it provides the most comprehensive and detailed User Guide for a user who may know how to use the Office products at an novice-to-intermediary level, but this reference book bridges the gap towards becoming an advanced user.Grover starts off with the basics of course, with the rudimentary navigation around each of the products, and adds some hints, some shortcuts that will make work easier, as well as drop in some reminders of things you can do that you would have thought of previously, such as numbering and how to restart numbering, something that I always have to fiddle with. AdvancedSearching Techniques, such as searching for Writing Styles and by Fonts is an amazingly powerful thing that I would not have known, but thanks to Office 2011 for Mac, the Missing Manual, I am able to find such enjoyable 'easter-egg' goodness throughout the book. There are no real cons to this book, it is quite thick and large and perhaps some people would be seeking a Cookbook, but for me, to have the logical ordered chapters, explaining the simple, the more advanced topics is exactly what I need. I can refer to a chapter, a product when I use it, learn a thing or two new each time and keep the book at hand, which is what a manual is all about, not something you read once and throw away.

               
              4.0

              Office goodness thanks to a real Guide!

              By Dozza

              from Sydney, Australia

              About Me Designer, Developer

              Verified Reviewer

              Pros

              • Accurate
              • Comprehensive
              • Easy to understand
              • Helpful examples
              • Well-written

              Cons

                Best Uses

                • Expert
                • Intermediate
                • Novice

                Comments about O'Reilly Media Office 2011 for Macintosh: The Missing Manual:

                A huge update for Mac Users who have been trying to keep their enterprise-applications on-par with their Windows counterparts, and with Microsoft's great leap, Office 2011 for Mac is definitely the 'missing manual' for users like me. Well I must admit, I have used Windows' Office a few years ago but have been stuck on iWorks for the past 3 years.

                With Outlook replacing exchange and having the other Office tools become more in-sync with the Windows version, I decided to make the leap myself. Reviewing Chris Grover's book, whilst being extremely thick, it provides the most comprehensive and detailed User Guide for a user who may know how to use the Office products at an novice-to-intermediary level, but this reference book bridges the gap towards becoming an advanced user.

                Grover starts off with the basics of course, with the rudimentary navigation around each of the products, and adds some hints, some shortcuts that will make work easier, as well as drop in some reminders of things you can do that you would have thought of previously, such as numbering and how to restart numbering, something that I always have to fiddle with. Advanced Searching Techniques, such as searching for Writing Styles and by Fonts is an amazingly powerful thing that

                I would not have known, but thanks to Office 2011 for Mac, the Missing Manual, I am able to find such enjoyable 'easter-egg' goodness throughout the book.

                There are no real cons to this book, it is quite thick and large and perhaps some people would be seeking a Cookbook, but for me, to have the logical ordered chapters, explaining the simple, the more advanced topics is exactly what I need. I can refer to a chapter, a product when I use it, learn a thing or two new each time and keep the book at hand, which is what a manual is all about, not something you read once and throw away.

                Displaying reviews 1-8

                Back to top

                 
                Buy 2 Get 1 Free Free Shipping Guarantee
                Buying Options
                Immediate Access - Go Digital what's this?
                Ebook: $27.99
                Formats:  APK, DAISY, ePub, Mobi, PDF
                Print & Ebook: $38.49
                Print: $34.99