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;