Grover C. Office 2011 for Macintosh: The Missing Manual

Chris Grover. Office 2011 for Macintosh: The Missing Manual. O’Reilly 2010. 812 p. - ISBN:
9781449393359Office 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.The Missing Credits.Word.
Word Basics: Opening, Editing, Saving, Printing.
Document Basics Covered Quickly.
Creating New Documents.
A Quick Tour of the Document Window.
The Minimalist’s Document Window.
Creating Documents from a Template.
Opening Documents.
Your Point of View.
Basic Editing in Word.
Natural (and Un-Natural) Selection.
Selecting Text with the Keyboard.
Undo, Redo and Repeat.
Save Me.
More Saving Graces.
Reducing File Size.
Document Password Protection.
Save to Web Page.
Share Word Documents via Email.
Printing from Word.
Advanced Editing in Word.
Toolbars and the Ribbon.
The Standard Toolbar.
Introducing the Ribbon.
Space-saving Ribbon Tricks.
Lists: Bulleted and Numbered.
Making Lists with Bullets.
Making Numbered and Multi-level Lists.
Customizing Word’s Automatic Lists.
Line, Page, and Column Breaks.
Paragraph Break.
Line Break.
Page Break.
Column Break.
Section Break.
Find and Replace.
Using the Search Box.
The Find and Replace Sidebar.
The Advanced Find and Replace Window.
AutoText: Abbreviation Expanders.
Spelling and Grammar.
Check Spelling as You Type.
Checking Spelling and Grammar All at Once.
Spelling and Grammar Options.
Writing Styles.
Custom Dictionaries and Preferred Spellings.
AutoCorrect.
Adding and Formatting Tables.
Creating Tables.
Creating a Table from the Ribbon.
Using the Insert Table Box.
Drawing a Table.
Editing Your Table.
Formatting Tables.
Inserting Photos and Media.
Inserting a Photo.
Playing Audio and Video in your Word Documents.
Recording and Running Macros.
Creating a Macro.
Running a Macro.
The Macro Organizer.
Learning about Visual Basic.
Organizing Your Templates.
Setting Up Documents and Pages.
Let Word Format Your Document Automatically.
Choose a Template.
Using Templates.
Modifying, Saving, and Installing Templates. Choose a Theme.
Finding More Themes.
Saving and Sharing Custom Themes.
Choose a Quick Style.
Writing with Style.
Get a New Look with Quick Styles.
Manually Formatting Your Document.
Choosing Paper Size and Layout.
Changing Paper Size.
Setting Paper Orientation.
Setting Margins.
Selecting Preset Margins.
Setting Custom Margins.
Using the Ruler to Set Margins.
Setting Margins for Booklets.
Adding Color, Borders, and Watermarks.
Choosing Page Color.
Adding a Border.
Adding a Watermark.
Adding Page Numbers, Headers, and Footers.
Adding a Page Number.
Removing Page Numbers.
The Easy Way to Add Headers and Footers.
Manually Adding Headers and Footers.
Dividing Your Document into Sections.
Formatting Paragraphs with Styles.
Modifying an Existing Style.
Overriding a Style Setting.
Showing Style Guides.
Manual Paragraph Formatting.
Paragraph Alignment.
Indenting Paragraphs.
Spacing Between Paragraphs.
Spacing Between Lines.
Setting Tabs.
Types of Tabs.
Managing Tab Settings with the Ruler.
Managing Line and Page Breaks.
Formatting Individual Characters.
Formatting as You Type with Shortcut Keys.
Formatting with the Ribbon or the Font Box.
Changing Capitalization.
Small Caps for Headers.
Advanced Font Formatting. Printing Documents, Envelopes, and Labels.
Choosing a Printer.
Setting Your Default Printer.
Advanced Print Settings.
Exploring Printer-Specific Properties.
Printing to an Adobe PDF File.
Printing Part of Your Document.
Printing Envelopes.
Printing Labels.
Changing Your Print Preferences.
Understanding Mail Merge Basics.
Common Types of Merge Documents.
Mail Merge Lists.
The Six Phases of a Mail Merge.
Running the Mail Merge Manager.
Select Document Type.
Select Recipients List.
Insert Placeholders.
Filter Recipients.
Preview Results.
Complete Merge.
Advanced Merge Techniques.
Merging to Labels and Envelopes.
Merging to Labels.
Merging to Envelopes.
Working with Long Documents.
Switching to Outline View.
Promoting and Demoting Headings.
Controlling Subheads During Promotion or Demotion.
Moving Outline Items.
Showing Parts of Your Outline.
Expanding and Collapsing Levels.
Showing and Hiding Text.
Showing Only the First Line.
Showing Text Formatting.
Notebook: Collecting Random Thoughts.
Opening Your Notebook.
The Notebook Ribbon.
Organizing Your Notes.
Placing Notes Beside Your Notes.
Typing Less with Audio Notes.
Manipulating Notebook Sections.
Navigating a Large Document.
Understanding Sections. Creating a Table of Contents.
Updating Your Table of Contents.
TOC the Harder Way: Using Other Styles.
Formatting Your Table of Contents.
Deleting a Table of Contents.
Creating an Index.
Marking an Index Entry.
Building an Index.
Updating an Index.
Deleting an Index.
Deleting an Index Entry.
Navigating with Hyperlinks.
Inserting and Removing Bookmarks.
Cross-Referencing Your Document.
Deleting Cross-References.
Cross-Referencing Figures.
Making a Table of Figures.
Creating Footnotes and Endnotes.
Inserting Footnotes and Endnotes.
Formatting Footnotes and Endnotes.
Inserting Citations and Creating a Bibliography.
Adding a Citation.
Adding a Bibliography.
Moving Beyond Text: Publishing Layout View.
Starting with a Template: Ready-to-Use Page Designs.
Choosing and Using a Template.
Arranging the Way Objects Overlap.
Adding, Removing and Rearranging Pages.
Managing Master Pages.
Adding Text and Text Boxes.
Formatting Text.
Add Color to Your Text Box.
Flowing Text between Boxes.
Adding Photos, Clip Art and Other Graphics.
Formatting Graphics.
Aligning Objects on the Page.
Working Collaboratively.
Adding Comments.
Deleting Comments.
Highlighting Text.
Tracking Changes While Editing.
Tracking and Viewing Changes.
Printing Edits and Markup.
Accepting and Rejecting Changes. Comparing and Merging Documents.
Merging Two Documents.
Protecting Your Document from Changes.
Sharing Documents over SkyDrive or SharePoint.
Sharing with SharePoint.Outlook.
Outlook: Email and Life Management 101.
Starting Outlook the First Time.
Outlook Tour.
Sending Emails with Outlook.
Email Fancy Formatting.
Embedding a Picture in Your Email.
Getting Photos from Cameras, Scanners, and Screenshots.
Sending Attachments with Your Email.
Adding Hyperlinks to Your Email.
Creating and Using Email Signatures.
About Digitally Signed and Encrypted Email.
Receiving Email.
Downloading Pictures.
Categorize and Arrange Your Emails.
Setting Up a Schedule to Send and Receive Email.
Managing Junk Mail.
Managing Your Contacts.
Creating New Contacts.
Adding Email Senders to Your Contacts.
Editing, Adding and Deleting Contacts.
Putting Contacts on the Map.
Syncing Outlook Contacts with Your Mac Address Book.
Importing Contacts.
Importing Contacts and Other Data from Outlook for Windows.
Creating Contact Groups.
Organizing and Searching for Contacts.
Printing Contacts.
Calendar: Meetings, Tasks, and Notes.
Creating Appointments and Meetings.
Adding Appointments.
Editing and Deleting Appointments.
Creating Recurring Appointments.
Adding Meetings.
Sending Updates and Canceling Meetings.
Responding to a Meeting Invitation. Adding Holidays to Your Calendar.
Removing Holidays.
Filtering the Displayed Events.
Printing Calendars.
Be Your Own Task Master.
Taking Note.
Creating Notes.
Emailing and Forwarding Notes.
Printing Notes.
Customizing Outlook and Managing Data.
Changing the Look of Outlook.
Creating Your Own Categories.
Using Categories to Filter the View.
Using Folders and Smart Folders.
Manually Adding Folders in Notes and Email.
Creating Smart Folders.
Using Advanced Searches to Create Smart Folders.
Creating Email Rules.
Create Multiple Outlook Identities.
Using My Day as Outlook Lite.Excel.
Basic Excel.
Spreadsheet Basics.
Opening a Spreadsheet.
Data Entry.
Basic Formatting.
Kinds of Data.
Tedium Savings:
AutoComplete.
Formula AutoComplete.
AutoFill.
Selecting Cells (and Cell Ranges).
Moving Things Around.
Inserting and Removing Cells.
Find and Replace.
Erasing Cells.
Tutorial 1: Entering Data.
Formula Fundamentals.
Basic Calculations.
Functions.
Order of Calculation.
Tutorial: Yearly Totals.
Building Advanced Workbooks.
Naming Cells and Ranges.
Creating Names Quickly.
Using Names to Look Up Data.
References: Absolute and Relative.
Workbooks and Worksheets.
Working with Multiple Worksheets.
Exporting Files.
Advanced Formula Magic.
Nested Formulas.
The Formula Builder.
Circular References.
Connecting to Other Workbooks.
Auditing.
Excel Data Magic.
Excel Tables, the New List Maker.
Building Your Table.
Naming Your Table and Renaming Headers.
Adding New Records and Fields.
Rearranging Rows and Columns.
Deleting Records, Fields, and Entire Tables.
Converting and Deleting a Table.
Table Formatting Tricks.
Automatic Formatting with Table Options.
Conditional Formatting for Cells.
Sorting and Filtering Your Table.
Hide and Seek with Table Filters.
Applying Multiple Filters.
The Calculating Table.
Building a Lookup Formula for Your Table.
Working with Databases.
Fetching FileMaker Pro Data.
Grabbing Data from the Web.
Importing Data from a Text File.
Analyzing and Viewing Your Data.
Making a PivotTable.
What If Tools Analyze Your Data.
Viewing Your Data.
Flag for Follow-Up.
Adding a Comment. Excel Macros and Visual Basic.
Recording and Playing Macros.
Playing and Saving Macros.
Absolute vs. Relative Cell References.
Using Formulas in Macros.
Making Macros Always Available.
Introducing Visual Basic for Applications.
Opening a Recorded Macro in Visual Basic.
Referencing Cells the VB Way.
Changing the Contents of a Cell.
Getting More Visual Basic Help.
Formatting and Charts: Well-Dressed
Spreadsheets.
Formatting Worksheets.
Automatic Formatting with Table Styles.
The Format Painter.
Formatting Cells by Hand.
Format Cells with Borders and Fill Color.
Setting Cell Fill Colors.
Changing How Text Looks.
Adding Pictures, Movies, and Text Boxes.
Charts.
Chart Parts.
Select the Data.
Choose a Chart Style.
Check Your Results.
Design the Chart Content.
Refine the Chart’s Appearance.
Transparent Bars.
Advanced Analysis Charting.
Sparklines: Small, Intense, Simple Datawords.
Formatting Sparklines.
Moving and Removing Sparklines.
Printing and Sharing Spreadsheets.
Printing Worksheets.
Print Preview.
Print to PDF Files.
Page Setup.
Sharing a Workbook.
Protecting the Spreadsheet.
Tracking Changes.
Merging Workbooks.
PowerPoint.
Planning and Creating Great Presentations.
Planning the Presentation.
The Goals of Your Presentation.
Know Your Audience.
Tailor the Presentation to the Audience.
Outline the Presentation.
Build Your Presentation.
Practice.
Delivering the Presentation.
Welcome Your Audience.
Introduce Your Presentation.
Making the Presentation.
Review.
Evaluating the Presentation.
Presentation Hardware.
Laptops.
Projectors.
Remote Controls.
Building a PowerPoint Presentation.
Choose a Template.
The Three-Pane View.
Specify a Theme.
Add Slides and Choose Layouts.
Changing Themes in Midstream.
Writing the Outline.
Using a Word Outline.
Building the Show.
Using Masters.
View Controls.
Navigation.
Manipulating Your Slides.
How to Build a Slide.
Using Backgrounds.
Working with Text.
Adding Graphics, Charts, and Tables.
Movies and Sounds.
Other Objects. Putting On the Show.
Adding Movement.
Transitions.
Multimedia Effects.
Adding Animations.
Putting Controls on Slides.
Adding Narration.
Putting On the Show.
Setting Up.
Rehearsing Your Presentation.
Choosing a Navigation Scheme.
Presenting Onscreen.
Controlling the Show.
Using Presenter View.
Recycling Your Presentations.
Saving Presentations as QuickTime Movies.
Broadcasting Presentations on the Web.
Saving Slides as Graphics.
Printing Your Presentation.
Page Setup.
Printing Your Slides.
Notes and Handouts.Office As a Whole
Making the Most of Graphics and Media.
Inserting a Graphic or Media Clip.
The Clip Art Gallery.
Categories.
Online.
Adding Your Own Clips.
Deleting Clips.
Search.
Working with Clip Art.
AutoShapes, Lines, SmartArt, and WordArt.
AutoShapes.
Lines.
Formatting and Editing Shapes and Lines.
SmartArt Graphics.
WordArt.
Aligning Objects. Modifying Graphics with the Format Dialog Box.
Formatting Fills.
Drawing Lines.
Adding Shadows.
Glow and Soft Edges Effects.
Creating Reflections.
3-D Format.
3-D Rotation.
Adjust Picture.
Artistic Filters.
Cropping Graphics.
Formatting Text Boxes.
Size Adjustments.
Adjust Position.
Storing Favorites in the Scrapbook.
Object Linking and Embedding (OLE).
Creating Linked Objects.
Editing Linked Objects.
Repairing a Broken Link.
Overriding Automatic Updating.
Creating Embedded Objects.
Editing Embedded Objects.
Customizing Office.
Customizing the Ribbon.
Customizing Your Toolbars.
Showing Other Toolbars.
Creating Custom Toolbars.
Attaching Custom Toolbars to Documents.
Redesigning Your Menus.
Adding a Command.
Removing a Menu Command.
Adding a Menu.
Removing a Menu.
Moving Whole Menus, or Specific Commands.
Resetting Everything Back to Normal.
Reassigning Key Combinations.
AppleScripting Office.
What is AppleScript?
Why Use AppleScript?
Installing and Running Office Scripts.
Installing Applets and Droplets.
Installing Script Menu Scripts.
Running the Scripts
Appendixes:
Installation and Troubleshooting.
The Office Help System.
Office 2011, Menu by Menu.
SkyDrive and Office Web Apps.