book

Office 2011 for Macintosh: The Missing Manual

Name: Office 2011 for Macintosh: The Missing Manual
Author: Chris Grover
ISBN: 9781449393359

by Chris Grover

December 2010

Beginner

814 pages

30h 43m

English

O'Reilly Media, Inc.

Read now

Unlock full access

Office 2011 for Macintosh: The Missing Manual
A Note Regarding Supplemental Files
The Missing Credits
About the AuthorAbout the Creative TeamAcknowledgementsThe Missing Manual Series
1. Introduction
Keeping Up with the MacsMore Integrated Than EverWhat’s New in Office 2011WordOutlookExcelPowerPointOffice as a WholeThe Very BasicsAbout This BookAbout the OutlineAbout→These→ArrowsAbout the Online ResourcesMissing CDRegistrationFeedbackErrataNewsletterSafari® Books Online
1. Word
2. Word Basics: Opening, Editing, Saving, Printing
Document Basics Covered QuicklyCreating New DocumentsA Quick Tour of the Document WindowThe Minimalist’s Document WindowCreating Documents from a TemplateOpening DocumentsYour Point of ViewBasic Editing in WordNatural (and Un-Natural) SelectionSelecting Text with the KeyboardUndo, Redo and RepeatSave MeMore Saving GracesReducing File SizeDocument Password ProtectionSave to Web PageShare Word Documents via EmailPrinting from Word
3. Advanced Editing in Word
Toolbars and the RibbonThe Standard ToolbarIntroducing the RibbonSpace-saving Ribbon TricksLists: Bulleted and NumberedMaking Lists with BulletsMaking Numbered and Multi-level ListsRestart numbering at 1Managing Multi-level listsCustomizing Word’s Automatic ListsLine, Page, and Column BreaksParagraph BreakLine BreakPage BreakColumn BreakSection BreakFind and ReplaceUsing the Search BoxThe Find and Replace SidebarThe Advanced Find and Replace WindowSearch and replace special charactersFind specific formattingAutoText: Abbreviation ExpandersSpelling and GrammarCheck Spelling as You TypeChecking Spelling and Grammar All at OnceSpelling and Grammar OptionsWriting StylesCustom Dictionaries and Preferred SpellingsEditing the custom dictionaryCreating a new custom dictionaryAdding and removing custom dictionariesForeign language dictionariesChoosing custom dictionaries before spell checkingAutoCorrectAdding and Formatting TablesCreating TablesCreating a Table from the RibbonUsing the Insert Table BoxDrawing a TableEditing Your TableFormatting TablesInserting Photos and MediaInserting a PhotoPlaying Audio and Video in your Word DocumentsRecording and Running MacrosCreating a MacroRunning a MacroThe Macro OrganizerLearning about Visual BasicOrganizing Your Templates
4. Setting Up Documents and Pages
Let Word Format Your Document AutomaticallyChoose a TemplateUsing TemplatesModifying, Saving, and Installing TemplatesChoose a ThemeFinding More ThemesSaving and Sharing Custom ThemesChoose a Quick StyleWriting with StyleGet a New Look with Quick StylesManually Formatting Your DocumentChoosing Paper Size and LayoutChanging Paper SizeSetting Paper OrientationSetting MarginsSelecting Preset MarginsSetting Custom MarginsUsing the Ruler to Set MarginsSetting Margins for BookletsAdding Color, Borders, and WatermarksChoosing Page ColorAdding a BorderAdding a WatermarkAdding Page Numbers, Headers, and FootersAdding a Page NumberRemoving Page NumbersThe Easy Way to Add Headers and FootersManually Adding Headers and FootersDividing Your Document into SectionsFormatting Paragraphs with StylesModifying an Existing StyleExploring the Modify Style boxOverriding a Style SettingReverting to the original styleClearing formattingShowing Style GuidesManual Paragraph FormattingParagraph AlignmentIndenting ParagraphsUsing the ruler to indent paragraphsSpacing Between ParagraphsSpacing Between LinesSetting TabsHow tab stops workViewing tab marks in your textDeleting and editing tabsTypes of TabsTab LeadersManaging Tab Settings with the RulerSetting tab stopsAdjusting and removing tab stops with the rulerManaging Line and Page BreaksFormatting Individual CharactersFormatting as You Type with Shortcut KeysFormatting with the Ribbon or the Font BoxChanging CapitalizationSmall Caps for HeadersAdvanced Font Formatting
5. Printing Documents, Envelopes, and Labels
Choosing a PrinterSetting Your Default PrinterAdvanced Print SettingsExploring Printer-Specific PropertiesPrinting to an Adobe PDF FilePrinting Part of Your DocumentPrinting EnvelopesPrinting LabelsChanging Your Print PreferencesUnderstanding Mail Merge BasicsCommon Types of Merge DocumentsMail Merge ListsThe Six Phases of a Mail MergeRunning the Mail Merge Manager1. Select Document Type2. Select Recipients List3. Insert Placeholders4. Filter RecipientsChoosing a comparison optionSorting your recipient list5. Preview ResultsEditing before the mergeComplete MergeAdvanced Merge TechniquesMerging to Labels and EnvelopesMerging to LabelsEditing labelsYet another way to format labelsMerging to Envelopes
6. Working with Long Documents
Switching to Outline ViewPromoting and Demoting HeadingsControlling Subheads During Promotion or DemotionMoving Outline ItemsShowing Parts of Your OutlineExpanding and Collapsing LevelsShowing and Hiding TextShowing Only the First LineShowing Text FormattingNotebook: Collecting Random ThoughtsOpening Your NotebookThe Notebook RibbonUse the Home tab for daily note takingChanging your notebook’s appearanceAudio Notes tab when you don’t want to writeOrganizing Your NotesSetting text levels with the keyboard and mouseSorting headingsPlacing Notes Beside Your NotesFlagging action itemsImportant enough to track in Outlook?Typing Less with Audio NotesEntering an audio noteListening to an audio noteManipulating Notebook SectionsLabeling sectionsTo line or not to lineNumbering PagesNavigating a Large DocumentUnderstanding SectionsCreating a Table of ContentsUpdating Your Table of ContentsTOC the Harder Way: Using Other StylesFormatting Your Table of ContentsQuick formatting for tables of contentsDetailed formatting for tables of contentsDeleting a Table of ContentsCreating an IndexMarking an Index EntryBuilding an IndexUpdating an IndexDeleting an IndexDeleting an Index EntryNavigating with HyperlinksInserting and Removing BookmarksCross-Referencing Your DocumentDeleting Cross-ReferencesCross-Referencing FiguresMaking a Table of FiguresCreating Footnotes and EndnotesInserting Footnotes and EndnotesFormatting Footnotes and EndnotesDeleting footnote and endnotesInserting Citations and Creating a BibliographyAdding a CitationAdding a Bibliography

7. Moving Beyond Text: Publishing Layout View
Starting with a Template: Ready-to-Use Page DesignsChoosing and Using a TemplateArranging the Way Objects OverlapAdding, Removing and Rearranging PagesManaging Master PagesAdding Text and Text BoxesFormatting TextAdd Color to Your Text BoxFlowing Text Between BoxesAdding Photos, Clip Art, and Other GraphicsFormatting GraphicsAligning Objects on the Page
8. Working Collaboratively
Adding CommentsDeleting CommentsHighlighting TextTracking Changes While EditingTracking and Viewing ChangesShowing and hiding types of changesShowing and hiding reviewers’ markupCustomizing your markup viewPrinting Edits and MarkupAccepting and Rejecting ChangesComparing and Merging DocumentsMerging Two DocumentsProtecting Your Document from ChangesSharing Documents over SkyDrive or SharePointSharing with SharePoint
2. Outlook
9. Outlook: Email and Life Management 101
Starting Outlook the First TimeOutlook TourSending Emails with OutlookEmail Fancy FormattingEmbedding a Picture in Your EmailAdding a Background Picture or ColorGetting Photos from Cameras, Scanners, and ScreenshotsSending Attachments with Your EmailAdding Hyperlinks to Your EmailCreating and Using Email SignaturesAbout Digitally Signed and Encrypted EmailReceiving EmailDownloading PicturesCategorize and Arrange Your EmailsSetting Up a Schedule to Send and Receive EmailManaging Junk Mail
10. Managing Your Contacts
Creating New ContactsAdding Email Senders to Your ContactsAdding contact vCardsEditing, Adding and Deleting ContactsPutting Contacts on the MapSyncing Outlook Contacts with Your Mac Address BookImporting ContactsImporting Contacts and Other Data from Outlook for WindowsCreating Contact GroupsOrganizing and Searching for ContactsPrinting Contacts
11. Calendar: Meetings, Tasks, and Notes
Creating Appointments and MeetingsAdding AppointmentsEditing and Deleting AppointmentsCreating Recurring AppointmentsAdding MeetingsSending Updates and Canceling MeetingsResponding to a Meeting InvitationAdding Holidays to Your CalendarRemoving HolidaysFiltering the Displayed EventsPrinting CalendarsBe Your Own Task MasterTaking NoteCreating NotesEmailing and Forwarding NotesPrinting Notes
12. Customizing Outlook and Managing Data
Changing the Look of OutlookCreating Your Own CategoriesUsing Categories to Filter the ViewWorking with categories in E-mail viewUsing Folders and Smart FoldersManually Adding Folders in Notes and EmailCreating Smart FoldersUsing Advanced Searches to Create Smart FoldersCreating Email RulesCreate Multiple Outlook IdentitiesUsing My Day As Outlook Lite
3. Excel
13. Basic Excel
Spreadsheet BasicsOpening a SpreadsheetData EntryBasic FormattingKinds of DataNumbersTextDatesTimesTedium Savings 1: AutoCompleteTedium Savings 2: Formula AutoCompleteTedium Savings 3: AutoFillUsing the Fill handleSelecting Cells (and Cell Ranges)Moving Things AroundCutting, copying, and pastingPaste SpecialDrag-and-dropInserting and Removing CellsFind and ReplaceErasing CellsTutorial 1: Entering DataFormula FundamentalsBasic CalculationsError checkingFunctionsFunction screen tips and AutoCompleteThe AutoSum buttonLooking up functions with the Formula BuilderOrder of CalculationTutorial 2: Yearly Totals
14. Building Advanced Workbooks
Naming Cells and RangesCreating Names QuicklyUsing Names to Look Up DataReferences: Absolute and RelativeWorkbooks and WorksheetsWorking with Multiple WorksheetsExporting FilesExcel 97-2004 Workbook (.xls)Comma separated values (.csv)Tab delimited text (.txt)Excel template (.xltx)Web pageSpreadsheet propertiesAdvanced Formula MagicNested FormulasThe Formula BuilderCircular ReferencesIterationsConnecting to Other WorkbooksAuditing
15. Excel Data Magic
Excel Tables, the New List MakerBuilding Your TableNaming Your Table and Renaming HeadersAdding New Records and FieldsRearranging Rows and ColumnsDeleting Records, Fields, and Entire TablesConverting and Deleting a TableTable Formatting TricksAutomatic Formatting with Table OptionsConditional Formatting for CellsSorting and Filtering Your TableHide and Seek with Table FiltersApplying Multiple FiltersThe Calculating TableBuilding a Lookup Formula for Your TableWorking with DatabasesFetching FileMaker Pro DataStep 1: Import the databaseStep 2: Choose only the data you wantGrabbing Data from the WebImporting Data from a Text FileAnalyzing and Viewing Your DataMaking a PivotTableStep 1: Choose the data sourceStep 2: Choose the cellsStep 3: PivotStep 4: Build the tableStep 6: Massage the dataWhat If Tools Analyze Your DataData tablesGoal seekScenariosTapping the Data menuViewing Your DataCustom viewsOutliningFlag for Follow-UpAdding a Comment
16. Excel Macros and Visual Basic
Recording and Playing MacrosPlaying and Saving MacrosAbsolute vs. Relative Cell ReferencesUsing Formulas in MacrosMaking Macros Always AvailableIntroducing Visual Basic for ApplicationsOpening a Recorded Macro in Visual BasicReferencing Cells the VB WayChanging the Contents of a CellGetting More Visual Basic Help
17. Formatting and Charts: Well-Dressed Spreadsheets
Formatting WorksheetsAutomatic Formatting with Table StylesAutomatic formatting bonusThe Format PainterFormatting Cells by HandChanging cell sizeHiding and showing rows and columnsFormat Cells with Borders and Fill ColorRemoving bordersSetting Cell Fill ColorsChanging How Text LooksAdding number formatsAdd or remove decimal placesChanging fontsChanging the standard fontsAligning textMerging cellsAdding Pictures, Movies, and Text BoxesInserting by the Insert menuChartsChart PartsStep 1: Select the DataStep 2: Choose a Chart StyleStep 3: Check Your ResultsStep 4: Design the Chart ContentStep 5: Refine the Chart’s AppearanceTransparent BarsAdvanced Analysis ChartingError barsTrend linesSparklines: Small, Intense, Simple DatawordsFormatting SparklinesMoving and Removing Sparklines
18. Printing and Sharing Spreadsheets
Printing WorksheetsPrint PreviewPrint to PDF FilesPage SetupPage orientationMargins tabHeader/Footer tabSheet tabSharing a WorkbookProtecting the SpreadsheetTracking ChangesMerging Workbooks
4. PowerPoint
19. Planning and Creating Great Presentations
Planning the PresentationThe Goals of Your PresentationKnow Your AudienceTailor the Presentation to the AudienceOutline the PresentationBuild Your PresentationPracticeDelivering the PresentationWelcome Your AudienceIntroduce Your PresentationMaking the PresentationReviewEvaluating the PresentationDesigning an evaluation formPresentation HardwareLaptopsProjectorsChoosing a projectorRenting projectorsProjection screensRemote Controls
20. Building a PowerPoint Presentation
Step 1. Choose a TemplateThe Three-Pane ViewStep 2: Specify a ThemeStep 3: Add Slides and Choose LayoutsChanging Themes in MidstreamStep 4: Writing the OutlineUsing a Word OutlineStep 5: Building the ShowUsing MastersSlide masterEditing the slide masterAdding new elements to a slide masterSlide layoutsModifying slide layoutsHandout masterNotes masterView ControlsNavigationManipulating Your SlidesInserting new slidesInserting slides from other presentationsDuplicating a slideDeleting a slideMoving slides aroundHiding slidesHow to Build a SlideUsing BackgroundsChanging backgroundsWorking with TextEditing and formatting textFormatting bulletsOther characters as bulletsGraphics as bulletsAdding Graphics, Charts, and TablesGraphicsTablesChartsMovies and SoundsFormat Movie optionsFormat Audio optionsRecord your own audioOther ObjectsHyperlink
21. Putting On the Show
Adding MovementTransitionsAdd a transitionChoosing transition stylesSubtleExcitingDynamic ContentCustomizing your transitionsMultimedia EffectsAdding AnimationsPutting Controls on SlidesAdding NarrationAdding a soundtrackPutting On the ShowSetting UpRehearsing Your PresentationChoosing a Navigation SchemePresenting OnscreenControlling the ShowUsing Presenter ViewRecycling Your PresentationsSaving Presentations as QuickTime MoviesBroadcasting Presentations on the WebSaving Slides as GraphicsSend to iPhotoSave as PicturesPrinting Your PresentationPage SetupPrinting Your SlidesNotes and Handouts
5. Office As a Whole
22. Making the Most of Graphics and Media
Inserting a Graphic or Media ClipThe Clip Art GalleryCategoriesOnlineAdding Your Own ClipsDeleting ClipsSearchWorking with Clip ArtAutoShapes, Lines, SmartArt, and WordArtAutoShapesLinesFormatting and Editing Shapes and LinesSmartArt GraphicsWordArtAligning ObjectsThe Drawing gridRotating drawing objectsModifying Graphics with the Format Dialog BoxFormatting FillsFill Color: Standard paletteFill Color: More ColorsFormat fill: GradientsFormat fill: Picture or TextureFormat fill: PatternDrawing LinesAdding ShadowsGlow and Soft Edges EffectsCreating Reflections3-D Format3-D RotationAdjust PictureArtistic FiltersCropping GraphicsFormatting Text BoxesSize AdjustmentsAdjust PositionStoring Favorites in the ScrapbookObject Linking and Embedding (OLE)Creating Linked ObjectsEditing Linked ObjectsRepairing a Broken LinkOverriding Automatic UpdatingCreating Embedded ObjectsEditing Embedded Objects
23. Customizing Office
Customizing the RibbonCustomizing Your ToolbarsShowing Other ToolbarsCreating Custom ToolbarsTo move a button or delete it from a toolbarTo add a button to a toolbarTo design a new toolbar from scratchAttaching Custom Toolbars to DocumentsRedesigning Your MenusAdding a CommandRemoving a Menu CommandAdding a MenuRemoving a MenuMoving Whole Menus, or Specific CommandsResetting Everything Back to NormalReassigning Key CombinationsAppleScripting OfficeWhat is AppleScript?Why Use AppleScript?Installing and Running Office ScriptsInstalling Applets and DropletsInstalling Script Menu ScriptsRunning the Scripts
6. Appendixes
A. Installation and Troubleshooting
Installing OfficeUsing the InstallerRemoving OfficeTroubleshootingCheck for a Bad Settings or Preference FileUninstall and Reinstall OfficeResearch Your Problem Online
B. The Office Help System
Office HelpHelp from Mac OS XWeb-Based Help
C. Office 2011, Menu by Menu
Application MenuAbout [Program Name]Online RegistrationApplication Menu PreferencesWork Offline (Outlook only)Turn Off (or On) Office Reminders (Outlook only)ServicesHide [Program Name]Hide OthersShow AllQuit [Program Name]Excel MenusFile MenuNew WorkbookNew from TemplateOpenOpen URLOpen RecentCloseSaveSave AsSave as Web PageSave LayoutWeb Page PreviewPage SetupPrint AreaPrintPropertiesEdit MenuUndoRepeat/RedoCut, Copy, Copy to ScrapbookPaste, Paste from Scrapbook, Paste SpecialPaste SpecialFillClearDeleteDelete SheetMove or Copy SheetFindReplaceGo ToLinksObjectView MenuNormalPage LayoutRibbonToolbarsFormula BarStatus BarMedia BrowserToolboxFormula BuilderScrapbookReference ToolsCompatibility ReportHeader and FooterCommentsRulerCustom ViewsFull ScreenZoomSized with WindowChart WindowInsert MenuCellsRowsColumnsChartSparklinesTableSheetPage BreakFunctionNameNew CommentPhotoAudioMovieClip ArtSymbolShapeText BoxSmartArt GraphicWordArtObjectHyperlinkFormat MenuCellsRowColumnSelected Chart AreaSheetConditional FormattingStyleTools MenuSpellingThesaurusDictionaryLanguageAutoCorrectError CheckingShare WorkbookTrack ChangesMerge WorkbooksProtectionFlag for Follow UpGoal SeekScenariosAuditingMacrosAdd-InsCustomize KeyboardData MenuSortFilterClear FiltersAdvanced FilterFormSubtotalsValidationData TableText to ColumnsConsolidateGroup and OutlinePivotTable ReportGet External DataRefresh DataChart MenuChart TypeSave as TemplateMove ChartSource DataAdd DataAdd Trendline3-D RotationWindow MenuMinimizeZoom WindowBring All to FrontNew WindowArrangeHideUnhideSplitFreeze PanesWindow ListHelp MenuSearchExcel HelpWelcome to ExcelGet Started with ExcelCheck for UpdatesVisit the Product Web SiteSend Feedback about ExcelScripts MenuAbout this MenuSample Automator WorkflowsOutlook MenusFile MenuNewOpenOpen Another User’s FolderCloseSaveSave AsFolderImportExportPage SetupPrintEdit MenuUndoRedoCutCopyCopy to ScrapbookPastePaste From ScrapbookPaste and Match StyleClearSelect AllDuplicateDeleteFindSpelling and GrammarSubstitutionsTransformationsSpeechSpecial CharactersView MenuPreviousNextGo ToColumnsArrange ByView specific Menus:Reading PaneMedia BrowserToolbox – ScrapbookToolbox – Reference ToolsNavigation PaneRibbonHide/Show ToolbarCustomize ToolbarMessage MenuReplyReply to AllForwardForward SpecialForward as AttachmentMark as ReadMark as UnreadMark All as ReadAttachmentsSenderJunk MailPriorityFollow UpCategorizeRulesMoveDraftSendHTML FormatCheck Names.AttachmentsSignaturesSecurityPriorityFollow UpCategorizeMeetingInvite AttendeesRecurrenceTime ZoneSignaturesShow AsPrivateCategorizeContactNew E-Mail Message ToNew Meeting WithNew IM ContactForward as vCardMap AddressUpdate from DirectoryThis Contact is MeFollow UpCategorizeMoveTaskMark as CompleteReplyReply AllForwardRecurrencePriorityFollow UpCategorizeMoveNoteForward as EmailForward as AttachmentCategorizeMoveFormat MenuFontStyleSizeColorHighlightText EncodingIncrease Font SizeDecrease Font SizeAlignmentNumbered ListBulleted ListIncrease IndentDecrease IndentHyperlinkTools MenuRun ScheduleSend & ReceiveIMAP FoldersOut of Office (used with Exchange)Public Folders (used with Exchange)RulesJunk E-Mail ProtectionAccountsWindow MenuMinimizeZoom WindowProgressError LogMy DayContact SearchWindow ListHelp MenuSearchOutlook HelpWelcome to OutlookGet Started with OutlookCheck for UpdatesVisit the Product Web SiteSend Feedback about OutlookScripts MenuAbout this MenuPowerPoint MenusFile MenuNew, New from Template, Open, Open URL, Open Recent, Close, Save, Save AsSave as PicturesSave as MovieShareReduce File SizeRestrict PermissionsPage Setup, PrintPropertiesEdit MenuUndo, Repeat/Redo, Cut, Copy, Copy to ScrapbookPaste, Paste from ScrapbookPaste SpecialClearSelect AllDuplicateDelete SlideFindSpecial CharactersObjectView MenuNormal, Slide Sorter, Notes Page, Presenter View, Slide ShowMasterRibbonToolbarsMessage BarMedia BrowserToolboxCustom AnimationScrapbookReference ToolsCompatibility ReportHeader and FooterCommentsRulerGuidesZoomInsert MenuNew SlideDuplicate SlideSlides FromSectionText BoxWordArtHeader and FooterDate and TimeSlide NumberTableChartSmartArt GraphicPhoto, Audio, Movie, Clip Art, Symbol, Shape, Object, and HyperlinkFormat MenuFontParagraphBullets and NumberingColumnsAlignmentText DirectionChange CaseReplace FontsTheme ColorsSlide BackgroundShapeArrangeReorder ObjectsReorder Overlapping ObjectsBring to FrontSend to BackBring ForwardSend BackwardGroupUngroupRegroupRotate or FlipAlign or DistributeTools MenuSpelling, Thesaurus, Dictionary, Language, AutoCorrect, Flag for Follow UpMacrosAdd-InsSlide Show MenuPlay from StartPlay from Current SlideBroadcast Slide ShowCustom ShowsPresenter ViewRehearseRecord Slide ShowAction ButtonsAction SettingsCustom AnimationTransitionsHide SlideSet Up ShowWindow MenuMinimize Window, Zoom Window, New Window, Arrange All, Bring All to FrontCascadeNext PaneWindow ListHelp MenuAppleScript MenuWord MenusFile MenuNew Blank Document, New from Template, Open, Open URL, Open Recent, Close, Save, Save AsSave as Web PageShareWeb Page PreviewRestrict PermissionsReduce File SizePage Setup, PrintPropertiesEdit MenuUndo, Repeat/Redo, Cut, Copy, Copy to ScrapbookPaste, Paste SpecialPaste and Match FormattingClearSelect AllLinksObjectView MenuDraft, Web Layout, Outline, Print Layout, Notebook Layout, Publishing Layout, Full ScreenRibbonToolbarsSidebarMessage BarToolboxStylesCitationsScrapbookReference ToolsCompatibility ReportRulerHeader and FooterFootnotesMaster DocumentMarkupReveal FormattingZoomInsert MenuBreakPage NumbersDate and TimeAutoTextFieldNew CommentCaptionCross-referenceIndex and TablesWatermarkTablesChartSmartArt GraphicPhoto, Audio, Movie, Clip Art, Symbol, Shape,Text BoxWordArtEquationFileObjectHTML ObjectBookmarkHyperlinkFormat MenuFontParagraphDocumentBullets and NumberingBorders and ShadingColumnsTabsDrop CapText DirectionChange CaseAutoFormatStyle[Object]Font MenuTools MenuSpelling and GrammarThesaurusHyphenationDictionaryLanguageWord CountAutoCorrectTrack ChangesMerge DocumentsProtect DocumentBlock AuthorsUnblock All My Blocked AreasProtect DocumentsFlag for Follow UpMail Merge ManagerEnvelopesLabelsLetter WizardContactsMacrosTemplates and Add-InsCustomize KeyboardTable MenuDraw TableInsertDeleteSelectMerge CellsSplit CellsSplit TableAutoFit and DistributeHeading Rows RepeatConvertSortFormulaGridlinesTable PropertiesWindow MenuZoom Window, Minimize Window, Bring All to FrontNew WindowArrange AllSplitWindow ListAppleScript MenuHelp Menu
D. SkyDrive and Office Web Apps
Why Compute in the Cloud?Signing Up for SkyDrive and Office Web AppsStoring Files on SkyDriveUsing the Document Connection to SkyDriveCreating SkyDrive and Sharing FoldersManaging Your SkyDrive FoldersWorking with the Office Web AppsMoving Documents Between Web Apps and Office 2011 Programs
Index
About the Author
Colophon
Copyright

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Office 2008 for Macintosh: The Missing Manual

Publisher Resources

ISBN: 9781449398965Errata Page

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills