Office 2011 for Macintosh: The Missing Manual

by Chris Grover

Overview

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.

Product Details

ISBN-13:	9781449302719
Publisher:	O'Reilly Media, Incorporated
Publication date:	12/17/2010
Series:	Missing Manual Series
Sold by:	Barnes & Noble
Format:	eBook
Pages:	816
File size:	30 MB
Note:	This product may take a few minutes to download.

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

The Missing Credits;
About the Author;
About the Creative Team;
Acknowledgements;
The Missing Manual Series;
Chapter 1: Introduction;
1.1 Keeping Up with the Macs;
1.2 More Integrated Than Ever;
1.3 What’s New in Office 2011;
1.4 The Very Basics;
1.5 About This Book;
1.6 About the Online Resources;
1.7 Safari® Books Online;
Part 1: Word;
Chapter 2: Word Basics: Opening, Editing, Saving, Printing;
2.1 Document Basics Covered Quickly;
2.2 Creating New Documents;
2.3 Opening Documents;
2.4 Your Point of View;
2.5 Basic Editing in Word;
2.6 Undo, Redo and Repeat;
2.7 Save Me;
2.8 Printing from Word;
Chapter 3: Advanced Editing in Word;
3.1 Toolbars and the Ribbon;
3.2 Lists: Bulleted and Numbered;
3.3 Line, Page, and Column Breaks;
3.4 Find and Replace;
3.5 AutoText: Abbreviation Expanders;
3.6 Spelling and Grammar;
3.7 AutoCorrect;
3.8 Adding and Formatting Tables;
3.9 Inserting Photos and Media;
3.10 Recording and Running Macros;
3.11 Organizing Your Templates;
Chapter 4: Setting Up Documents and Pages;
4.1 Let Word Format Your Document Automatically;
4.2 Choose a Template;
4.3 Choose a Theme;
4.4 Choose a Quick Style;
4.5 Manually Formatting Your Document;
4.6 Choosing Paper Size and Layout;
4.7 Setting Margins;
4.8 Adding Color, Borders, and Watermarks;
4.9 Adding Page Numbers, Headers, and Footers;
4.10 Dividing Your Document into Sections;
4.11 Formatting Paragraphs with Styles;
4.12 Manual Paragraph Formatting;
4.13 Formatting Individual Characters;
Chapter 5: Printing Documents, Envelopes, and Labels;
5.1 Choosing a Printer;
5.2 Printing to an Adobe PDF File;
5.3 Printing Part of Your Document;
5.4 Printing Envelopes;
5.5 Printing Labels;
5.6 Changing Your Print Preferences;
5.7 Understanding Mail Merge Basics;
5.8 The Six Phases of a Mail Merge;
5.9 Running the Mail Merge Manager;
5.10 Advanced Merge Techniques;
5.11 Merging to Labels and Envelopes;
Chapter 6: Working with Long Documents;
6.1 Switching to Outline View;
6.2 Promoting and Demoting Headings;
6.3 Controlling Subheads During Promotion or Demotion;
6.4 Moving Outline Items;
6.5 Showing Parts of Your Outline;
6.6 Notebook: Collecting Random Thoughts;
6.7 Navigating a Large Document;
6.8 Creating a Table of Contents;
6.9 Creating an Index;
6.10 Navigating with Hyperlinks;
6.11 Cross-Referencing Your Document;
6.12 Creating Footnotes and Endnotes;
6.13 Inserting Citations and Creating a Bibliography;
Chapter 7: Moving Beyond Text: Publishing Layout View;
7.1 Starting with a Template: Ready-to-Use Page Designs;
7.2 Choosing and Using a Template;
7.3 Adding, Removing and Rearranging Pages;
7.4 Adding Text and Text Boxes;
7.5 Adding Photos, Clip Art, and Other Graphics;
Chapter 8: Working Collaboratively;
8.1 Adding Comments;
8.2 Tracking Changes While Editing;
8.3 Printing Edits and Markup;
8.4 Accepting and Rejecting Changes;
8.5 Comparing and Merging Documents;
8.6 Merging Two Documents;
8.7 Protecting Your Document from Changes;
8.8 Sharing Documents over SkyDrive or SharePoint;
Part 2: Outlook;
Chapter 9: Outlook: Email and Life Management 101;
9.1 Starting Outlook the First Time;
9.2 Outlook Tour;
9.3 Sending Emails with Outlook;
9.4 Receiving Email;
Chapter 10: Managing Your Contacts;
10.1 Creating New Contacts;
10.2 Importing Contacts;
10.3 Creating Contact Groups;
10.4 Organizing and Searching for Contacts;
10.5 Printing Contacts;
Chapter 11: Calendar: Meetings, Tasks, and Notes;
11.1 Creating Appointments and Meetings;
11.2 Adding Meetings;
11.3 Filtering the Displayed Events;
11.4 Printing Calendars;
11.5 Be Your Own Task Master;
11.6 Taking Note;
Chapter 12: Customizing Outlook and Managing Data;
12.1 Changing the Look of Outlook;
12.2 Creating Your Own Categories;
12.3 Using Folders and Smart Folders;
12.4 Creating Smart Folders;
12.5 Creating Email Rules;
12.6 Create Multiple Outlook Identities;
12.7 Using My Day As Outlook Lite;
Part 3: Excel;
Chapter 13: Basic Excel;
13.1 Spreadsheet Basics;
13.2 Formula Fundamentals;
Chapter 14: Building Advanced Workbooks;
14.1 Naming Cells and Ranges;
14.2 References: Absolute and Relative;
14.3 Workbooks and Worksheets;
14.4 Advanced Formula Magic;
Chapter 15: Excel Data Magic;
15.1 Excel Tables, the New List Maker;
15.2 Building Your Table;
15.3 Table Formatting Tricks;
15.4 Sorting and Filtering Your Table;
15.5 The Calculating Table;
15.6 Working with Databases;
15.7 Analyzing and Viewing Your Data;
Chapter 16: Excel Macros and Visual Basic;
16.1 Recording and Playing Macros;
16.2 Introducing Visual Basic for Applications;
Chapter 17: Formatting and Charts: Well-Dressed Spreadsheets;
17.1 Formatting Worksheets;
17.2 Charts;
17.3 Sparklines: Small, Intense, Simple Datawords;
Chapter 18: Printing and Sharing Spreadsheets;
18.1 Printing Worksheets;
18.2 Sharing a Workbook;
Part 4: PowerPoint;
Chapter 19: Planning and Creating Great Presentations;
19.1 Planning the Presentation;
19.2 Delivering the Presentation;
19.3 Presentation Hardware;
Chapter 20: Building a PowerPoint Presentation;
20.1 Step 1. Choose a Template;
20.2 Step 2: Specify a Theme;
20.3 Step 3: Add Slides and Choose Layouts;
20.4 Step 4: Writing the Outline;
20.5 Step 5: Building the Show;
20.6 How to Build a Slide;
Chapter 21: Putting On the Show;
21.1 Adding Movement;
21.2 Putting On the Show;
21.3 Recycling Your Presentations;
21.4 Printing Your Presentation;
Part 5: Office As a Whole;
Chapter 22: Making the Most of Graphics and Media;
22.1 Inserting a Graphic or Media Clip;
22.2 The Clip Art Gallery;
22.3 AutoShapes, Lines, SmartArt, and WordArt;
22.4 Modifying Graphics with the Format Dialog Box;
22.5 Storing Favorites in the Scrapbook;
22.6 Object Linking and Embedding (OLE);
Chapter 23: Customizing Office;
23.1 Customizing the Ribbon;
23.2 Customizing Your Toolbars;
23.3 Redesigning Your Menus;
23.4 Reassigning Key Combinations;
23.5 AppleScripting Office;
23.6 What is AppleScript?;
23.7 Installing and Running Office Scripts;
Part 6: Appendixes;
Installation and Troubleshooting;
Installing Office;
Troubleshooting;
The Office Help System;
Office Help;
Help from Mac OS X;
Web-Based Help;
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;
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;