Office for Mac 2011 Portable Genius E-Book

Dwight Spivey

• Herausgeber: John Wiley & Sons
• Kategorie: Wissenschaft und neue Technologien
• Serie: Portable Genius
• Sprache: Englisch

Seitenzahl: 358

Veröffentlichungsjahr: 2010

Beschreibung

A savvy guide to Office 2011 for Mac usersMac users, you don't have to give up one ounce of cool touse Office 2011 on your Mac. Here's the hip guide you need toget the most out of Word, Excel, PowerPoint, and Outlook. Getstarted with Office 2011, find out what features are shared betweenapps, and start creating stylish Word docs, lively PowerPointpresentations, awesome Excel reports, and totally organized Outlooklists and calendars. And you'll love the portablesize--just perfect for keeping this guide on hand while youwork.* Features facts, tips, and secrets to help you get the most ofout of Office 2011 for Mac* Provides the key tools and shortcuts you need to accomplishtasks, without bogging you down in too much detail* Covers how to get started with Office, an overview of sharedfeatures, and how to use each application in the Office 2011suite* Helps you create smart Word docs, organize your calendar andcontacts with Outlook, build compelling PowerPoint presentations,and use Excel formulas and functions to generate reports andanalyze dataZero in on the Office 2011 features you use most on your Mac,with Office 2011 for Mac Portable Genius.

Leseprobe

Microsoft® Office for Mac® 2011 Portable Genius

Table of Contents

Chapter 1: What Are the First Things I Need to Know?

Installing Office for Mac 2011

Installing using the Office Installer

How do I access my applications?

How do I install additional templates?

The Latest and Greatest: Cool New Features in Office 2011

What’s new in Office?

What’s new in Word?

What’s new in Excel?

What’s new in PowerPoint?

What’s new in Outlook?

Using Office for Mac 2011 Programs

Get to know the ribbon

The amazing Gallery

Starting from scratch: creating a new document

Saving your work within Office applications

Open existing documents

Sharing with other Office users

Chapter 2: What Can I Do with the Toolbox, Media Browser, and the Ribbon?

Understanding Elements in the Toolbox

Styles

Citations

Formula Builder

Custom Animation

Scrapbook

Reference Tools

Compatibility Report

Adding Objects with Media Browser

Photos

Music

Movies

Clip art

Symbols and shapes

Using the Ribbon

Hide, show, or disable the ribbon

Using the format tabs

Chapter 3: How Can I Set Up My New Documents in Word?

Getting Around in Word

Setting Word Preferences

Authoring and Proofing Tools

Output and Sharing

Personal Settings

Creating New Documents

Understanding Document Viewing Choices

Manipulating Text

Selecting text

Moving, copying, and cutting text

Choosing and formatting fonts

Finding text in a document

Finding and replacing text

Simple Page Formatting

Setting margins

Setting tab stops

Adding headers and footers

Using Proper Spelling and Grammar

Chapter 4: How Can I Spice Up My Documents?

Simplify Document Creation Using Templates and Wizards

Using templates in your documents

Casting a spell on the mundane with wizards

Inserting Images and Graphics Into Your Documents

Adding pictures to your document

Inserting graphics into your documents

Putting Tables to Work

Adding tables to your document

Formatting tables

AutoFormatting Can Handle the Dirty Work for You

AutoCorrect

AutoText

AutoFormat

Using Themes, Styles, and Backgrounds

Applying styles to text

Choosing a theme for your document

Choosing backgrounds and fill effects

Chapter 5: How Can I Use Word More Efficiently?

Viewing Different Sections of the Same Document

Helpful Keyboard Shortcuts

Creating Customized Toolbars

Saving Word Documents

What format to use?

Using the Save As Web Page feature

Printing Your Word Documents

Chapter 6: How Do I Create Spreadsheets with Excel?

Getting Around in Excel

Setting Excel Preferences

What Are Worksheets and Workbooks?

Using Cells, Rows, and Columns

Adding information to a cell

Moving and copying cells

Moving around within a worksheet

Finding and replacing information in cells

Editing and deleting cells, rows, and columns

Inserting additional cells, rows, and columns

Using AutoFill

Formatting cells

Printing Your Excel-lent Spreadsheets

Chapter 7: How Can I Use Excel Formulas?

What Are Formulas?

Understanding References

Getting to know the A1 reference style

Working with relative, absolute, and mixed references

Getting Familiar with Formulas

Using Operators

Arithmetic operators

Reference operators

Comparison operators

Text concatenation operator

Understanding the order of Excel calculations

Utilizing the mighty parentheses

Chapter 8: How Can I Augment My Spreadsheets?

Why Use Charts and Graphs?

Understanding Different Types of Charts

Creating a Simple Chart

Formatting Information for Charts

Enhance Your Chart’s Visual Appeal

Adding colors and textures to your chart

Adding shapes and images to your chart

Chapter 9: How Do I Create a PowerPoint Presentation?

Getting Around in PowerPoint

Setting PowerPoint’s Preferences

Creating a Simple Presentation

Starting from scratch

Creating a presentation from a template

Using Notes and Handouts with Your Presentation

Adding notes to your slides

Creating handouts from your presentation

Chapter 10: How Can I Add Some Pizzazz to My Presentations?

Enhancing Slides with Color, Images, and Graphics

Applying and customizing a theme

Adding background colors and fills

Inserting your own images

Drawing shapes

Adding charts to presentations

SmartArt graphics

Slide Transitions

Adding Sounds and Movies to Your Presentation

Chapter 11: How Do I Give a Presentation?

Delivering a Presentation

Playing a presentation

Set up a slide show

Using Presenter View

Rehearse a presentation

Record a presentation

Draw on slides during a presentation

Broadcast a live presentation

Making a PowerPoint Movie

Printing Your Presentation

Chapter 12: How Do I Begin Using Outlook?

Getting Around in Outlook

Setting Outlook’s Preferences

Creating a New E-mail Account

Supported e-mail account types

Adding an account

Backing up e-mail accounts

Managing Identities

Chapter 13: How Do I Optimize My Outlook E-mail?

Sending and Receiving E-mails

Creating new e-mail

Reading e-mail

Customize the Outlook window

Dealing with Junk E-mail

Working with E-mail Attachments

Sending attachments

Viewing and saving attachments

A Clean House Is a Happy House: Organizing E-mail

Creating folders

IMAP folder settings

Laying down the law: Using rules

Searching for Long-lost E-mails

Printing E-mail

Chapter 14: How Can I Organize Contacts and Tasks?

Getting Around in Calendar

Creating a meeting

Update or cancel meetings

Creating an appointment

Add or remove holidays

Printing calendars

Getting Around in Contacts

Adding and removing contacts

Creating groups

Printing your Address Book

Getting Around in Tasks

Adding and removing tasks

Editing, managing, and completing tasks

Printing your Tasks list

Create and Manage Notes

Keeping On Schedule with My Day

Chapter 15: How Can I Work More Efficiently?

Drag and Drop Information from App to App

View Multiple Worksheets in Excel

Using AutoComplete in Excel

Linking Excel Objects in Word

Save Documents as PDFs

Turbo-Paste: How to Use Paste Special in Excel

Chapter 16: What Other Applications Are Part of Office 2011?

Collaborating with Communicator

Chatting Using Messenger

Connect with Other Computers Using Remote Desktop Connection

Chapter 17: How Can I Get Help with Office 2011?

Using Your Application’s Help Index

Opening the Help index

Perusing the Help index

Lightning-fast Answers: Online Support

Downloads

Help and How-To

Forums

Blog

Updating Your Office Applications

Microsoft® Office for Mac® 2011 Portable Genius

by Dwight Spivey

Microsoft® Office for Mac® 2011 Portable Genius

Published by Wiley Publishing, Inc. 10475 Crosspoint Blvd. Indianapolis, IN 46256 www.wiley.com

Copyright ©2011 by Wiley Publishing, Inc., Indianapolis, Indiana

Published simultaneously in Canada

ISBN: 978-0-470-61019-0

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

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, [phone], fax [phone]. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, [phone], fax [phone], or online at http://www.wiley.com/go/permissions.

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 Web site 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 of Web site may provide or recommendations it may make. Further, readers should be aware that Internet Web sites listed in this work may have changed or disappeared between when this work was written and when it is read.

For general information on our other products and services or to obtain technical support, please contact our Customer Care Department within the U.S. at [phone], outside the U.S. at [phone] or fax [phone].

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: 2010938833

Trademarks: Wiley and the Wiley Publishing logo are trademarks or registered trademarks of John Wiley and Sons, Inc. and/or its affiliates in the United States and/or other countries, and may not be used without written permission. 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.

About the Author

Dwight Spivey is the author of several Mac books, including Mac OS X Leopard Portable Genius and Mac OS X Snow Leopard Portable Genius. He is also a software and support engineer for Konica Minolta, where he specializes in working with Mac operating systems, applications, and hardware, as well as color and monochrome laser printers. He teaches classes on Mac usage, writes training and support materials for Konica Minolta, and is a Mac OS X beta tester for Apple. Dwight lives on the Gulf Coast of Alabama with his wife Cindy and their four beautiful children, Victoria, Devyn, Emi, and Reid. He studies theology, draws comic strips, and roots for the Auburn Tigers in his ever-decreasing spare time.

Dedication

To the newest member of our family, Johnathan Reid.

God bless your every step, my sweet boy.

Love, Daddy

Author’s Acknowledgments

I must thank my family and friends for putting up with my many absences during the writing of this book. I love you all!

Many thanks to my agent, Carole Jelen McClendon. Couldn’t do this without you, Carole!

Sincere appreciation goes to my project editors for this book, Jama Carter and Chris Wolfgang, and to my acquisitions editor, Aaron Black. Thank you all for being so good to me from start to finish of this book. Jama and Chris, you have both been a joy to work with, and my work is so much better because of you. Aaron, thanks so much for bringing me into such a great project.

Special thanks and salutations to my technical editor, Julian Dolce, for his determination to keep my work accurate and honest.

To everyone else who has had a hand in getting this book from raw manuscript to the beautiful publication that it is, I cannot thank you enough. You make my work so much better than I deserve. I sincerely thank you for all of your hard work and dedication to this book.

Credits

Senior Acquisitions Editor: Aaron Black

Project Editor: Christina Wolfgang

Technical Editor: Julian Dolce

Senior Copy Editor: Kim Heusel

Editorial Director: Robyn Siesky

Vice President and Executive Group Publisher: Richard Swadley

Vice President and Executive Publisher: Barry Pruett

Business Manager: Amy Knies

Senior Marketing Manager: Sandy Smith

Project Coordinator: Sheree Montgomery

Graphics and Production Specialists: Ana Carrillo, Joyce Haughey, Jennifer Henry, Andrea Hornberger

Quality Control Technician: Lindsay Littrell

Proofreading: Melissa D. Buddendeck

Indexing: Joan Griffitts

Introduction

Every few years we Mac users are treated to something very special. While the excitement doesn’t quite reach the level of a new Mac OS X release, it is surprisingly close for some. The special something I speak of is the release of the latest version of Microsoft’s Office suite of productivity applications for the Mac.

Excitement of this level for software releases is something that is typically found only in the Mac world; most PC users simply don’t get it. “What’s all the fuss? It’s just a piece of software, for goodness sake!”

Mac users have always taken dedication to their favorite computing platform very seriously, as anyone who’s ever been in an Apple Store when a new version of Mac OS X is about to be released will attest (not to mention the mile-long lines for iPhones). Granted, sometimes this dedication has been taken to the extreme (come on, people; shaving an Apple logo into your hairdo is a bit much), but for the most part is simply due to customers being loyal to a company that has been loyal to them by consistently providing the best computing experience on the planet.

Okay, so what does this loyalty and new software release fever have to do with Microsoft?

Think about it: Mac users don’t just use their operating system; many other applications factor into their user experience. Take a guess as to which software is one of the most popular for people who work with Macs (beside the operating system): that’s right, Microsoft Office for Mac. I would venture to say that most people who own a version of Office for Mac spend the majority of their time working in one of the Office applications. It stands to reason that when these fiercely loyal Mac users hear about a new release of the third-party software they use more than any other, their interest in the matter is slightly more than mild.

And Mac users have every reason to be excited about the latest release of this iconic suite, Microsoft Office for Mac 2011! This version is easily the best in quite some time (for some, Office 2008 was a bitter disappointment), incorporating the ribbon, feature parity with the latest versions of Office for Windows (even surpassing its Windows counterparts in some features), and the long-awaited return of Outlook. Office for Mac 2011 is going to bring smiles to the faces of many Mac users.

Want another reason to jump on board the Office for Mac 2011 train? Microsoft’s Macintosh Business Unit gets it. It gets what it means to be a Mac fan, because the people in the unit are Mac fans.

This book was written for you in the same vein: by a Mac fan for Mac fans. It’s my hope that it quickly gets you on your feet and running with the newest version of Office for Mac, and that you have a little fun along the way, too.

Please note that some special symbols used in this eBook may not display properly on all eReader devices. If you have trouble determining any symbol, please call Wiley Product Technical Support at 800-762-2974. Outside of the United States, please call 317-572-3993. You can also contact Wiley Product Technical Support at www.wiley.com/techsupport.

Chapter 1: What Are the First Things I Need to Know?

There’s something in the air. It’s that time again. Time for the next release of Microsoft Office for Mac! This version offers plenty to be excited about, and that’s part of what this chapter discusses. Along with new features, I also explain how to install the latest incarnation of Office for Mac, and how to get started from the ground floor in case you’re new to Office.

Installing Office for Mac 2011

The Latest and Greatest: Cool New Features in Office 2011

Using Office for Mac 2011 Programs

Installing Office for Mac 2011

It’s time to get moving with your new copy of Office 2011 for Mac! First things first, however; you need to get those legendary Office applications installed on your trusty Mac before you can go too far into anything else. So, insert the Microsoft Office 2011 Installation DVD and get this party started.

Installing using the Office Installer

Microsoft has automated almost the entire installation process for you, so this will be a breeze. Follow these steps:

1. Insert the Microsoft Office 2011 Installation DVD into your Mac’s disc drive.

2. In the Microsoft Office 2011 window, double-click the Office Installer program.

3. Click Continue in the Welcome to the Microsoft Office for Mac 2011 Installer window.

4. Read the license agreement, click Continue, and then click Agree. If you don’t click Agree then you are at an impasse.

5. Select the destination on your Mac for your Office installation.

6. At the next window, you have to decide whether to install the entire Office suite of applications or perform a custom installation.

• To install the entire Office suite, skip to step 9.

• To install only portions of the Office suite, continue with the next step.

7. Click the Customize button at the bottom of the window.

8. In the Custom Install window, seen in Figure 1.1, determine which items you want to install:

• To install an item, select the check box to its left.