book

Office 2010: The Missing Manual

by Nancy Conner, Matthew MacDonald

July 2010

Beginner

956 pages

39h 22m

English

O'Reilly Media, Inc.

Read now

Unlock full access

Office 2010: The Missing Manual
A Note Regarding Supplemental Files
The Missing Credits
About the AuthorsAbout the Creative TeamAcknowledgementsThe Missing Manual Series
Introduction
What Is Office 2010?What’s New in Office 2010About This BookThe Very BasicsAbout→These→ArrowsAbout MissingManuals.comSafari® Books Online
One. Word
1. Basic Word Processing
Opening WordThe Word 2010 ScreenUsing Keyboard ShortcutsCreating a New DocumentCreating a New Blank DocumentCreating a New Document from a TemplateCreating a New Document from an Existing DocumentTyping in Some TextSaving a DocumentSaving a Document Using Your MouseSaving a Document Using Keyboard ShortcutsUsing the Save As Dialog BoxClosing a DocumentOpening an Existing DocumentDifferent Ways to View Your WorkViewing a Document in the Navigation PaneOutline view in the Navigation panePage view in the Navigation paneZooming In and OutUsing the Zoom sliderUsing the Zoom dialog boxWorking with Multiple Windows
2. Editing and Formatting
Selecting and Moving TextFour Ways to Move TextOption 1: Use the Ctrl keyOption 2: Right-click your mouseOption 3: Use the Home tabOption 4: Use the Clipboard paneFinding and Replacing TextSearching with the Navigation PaneSetting Search OptionsSearching with the Traditional Find and Replace Dialog BoxReplacing TextText Formatting: Font, Size, and StyleThe Home Tab’s Control CenterCopy Formatting with Format PainterQuick Formatting with the Mini ToolbarFormatting Power with StylesApplying styles using style setsCreating your own style setParagraph Formatting: Aligning, Indenting, SpacingAligning TextIndenting ParagraphsIndenting the first line of a paragraphIndenting an entire paragraphCreating a hanging indentSpacing Within a ParagraphSpacing Between ParagraphsWorking with ListsCreating a ListFormatting a ListFormatting a bulleted listFormatting a numbered listFormatting a multilevel listFormatting a DocumentUsing the Page Setup SectionUsing the Page Background SectionAdding a watermarkCustomizing a watermark with textCustomizing a watermark with an imageEditing or deleting a watermarkAdding color to page backgroundsAdding patterns to page backgroundsGiving pages a borderInserting Headers, Footers, and Page NumbersInserting a header or footerEditing a header or footerInserting the date and time into a header or footerInserting an image into a header or footerRemoving a header or footerInserting page numbersFormatting page numbersRemoving page numbers
3. Tables, Graphics, and Charts
Creating a TableCreating a Table from ScratchInserting a tableInserting a preformatted tableDrawing a tableCreating a Table from TextAdding Information to a TableEditing a TableSelecting Part or All of a TableUsing your mouseUsing the ribbonInserting Rows and ColumnsMoving Rows and ColumnsMerging and Splitting CellsDeleting All or Part of a TableFormatting a TableSave Time with Ready-to-Use Table StylesApplying Shading and BordersShading a TableWorking with BordersInserting ImagesInserting a PictureInserting Clip ArtInserting a ScreenshotEditing an ImageChanging an Image’s SizeCropping an ImageRemoving a Picture’s BackgroundMoving and Rotating ImagesMoving an imageRotating an imageAdjusting an Image’s AppearanceUsing Picture StylesWrapping Text Around an ImageSearching for ImagesFun with Fonts and Art That’s SmartCreating WordArtEditing WordArt TextInserting SmartArt into Word DocumentsAdding Charts and Diagrams
4. Proofing and Research Tools
Checking Spelling and GrammarCatching Spelling MistakesUsing contextual spellingChecking spelling in an entire documentWord’s Grammar CheckerGetting Things Right with AutoCorrectUndoing an AutoCorrect ChangeSetting AutoCorrect OptionsMaking an exceptionAdding custom correctionsDeleting an AutoCorrect correctionAutoFormatting in WordWord’s Built-in Research ToolsLooking Up a Word in the DictionaryUsing the ThesaurusGetting Information about a SubjectTranslating TextGetting a quick translation with the Mini TranslatorUsing the Research pane for translationsTranslating an entire document
5. Printing Documents
Getting Started with PrintingPreviewing a Document Before You Print ItPrinting a DocumentSelecting Print Options and SettingsChoosing a PrinterSpecifying SettingsSending a FaxCreating a Cover PageSending a FaxPrinting EnvelopesFormatting Envelope AddressesSelecting a Feed MethodAdding Electronic PostagePrinting LabelsMerging Names and Addresses with DocumentsStep 1: Select Document TypeStep 2: Select Starting DocumentStep 3: Select RecipientsStep 4: Write Your LetterStep 5: Preview Your LettersStep 6: Complete the MergeDo-It-Yourself Mail Merge with the Mailings Tab’s Buttons

6. Reports and Long Documents
Inserting Page BreaksBreaking a Document into SectionsKinds of Section BreaksInserting a Section BreakChanging the Orientation of a New SectionChanging the Page Numbering of a New SectionFootnotes and EndnotesInserting a FootnoteInserting an EndnoteEditing a NoteNavigating NotesChanging the Position of Footnotes or EndnotesConverting Footnotes to Endnotes (or Vice Versa)Changing Footnote or Endnote MarkersDeleting a NoteCitations and BibliographiesCreating and Inserting a CitationInserting an Existing CitationInserting a PlaceholderEditing a Citation or Its SourceDeleting a CitationDeleting a SourceBuilding a BibliographyUpdating a BibliographyHelping Readers Navigate Your DocumentInserting Bookmarks and Cross-ReferencesCreating a bookmarkJumping to a bookmarkDeleting a bookmarkCreating cross-referencesCreating a Table of ContentsCreating an IndexMarking index entriesGenerating an indexUpdating an indexEditing index entriesDeleting an index entryDeleting an index
7. Customizing Your Documents with Themes, Templates, and Macros
Themes: The Way to Better DesignsChoosing a ThemeCustomizing a ThemeSaving a ThemeFinding a Saved ThemeTemplates: Reusable Document BlueprintsChoosing a TemplateCreating Your Own TemplateCreating a template from scratchCreating a template from a documentCreating a template from an existing templateCustomizing a TemplateChanging an existing style within a templateCreating a new style for a templateCopying a style from one template to anotherDeleting a style from a templateSave Time with MacrosRecording a MacroRunning a MacroCopying a Macro Between TemplatesDeleting a Macro
8. Desktop and Web Publishing
Newsletters and BrochuresLaying Out Text in ColumnsFormatting ColumnsInserting a Text BoxImages and Text WrappingInserting an image into a document with columnsInserting an image into a document with text boxesWeb Page DesignSaving a Word Document as a Web PageCreating a Web Page from ScratchCreating your site’s home pageStep 1: Set up a tableStep 2: Create a headerStep 3: Add a navigation barStep 4: Add a footerStep 5: Save the page as a templateStep 6: Adding text and imagesCreating More Pages for Your Site
9. Sharing and Collaborating on Documents
Sharing a DocumentEmailing a DocumentEmailing a document as an attachmentEmailing a link to a documentSaving a Document to SkyDriveSaving a Document to SharePointAdding CommentsInserting a CommentViewing CommentsEditing a CommentDeleting a CommentTracking ChangesSelecting Which Changes to ViewAccepting or Rejecting ChangesSetting Track Changes OptionsComparing DocumentsCombining DocumentsProtecting Your DocumentsRemoving Hidden Data and Personal InformationRestricting Formatting and EditingRestricting PermissionsCoauthoring and Simultaneous Editing
Two. Outlook
10. Getting Started with Outlook
Setting Up OutlookTaking a Quick Look AroundMailCalendarContactsTasksNotesComposing and Sending EmailSending an Email to More Than One RecipientProofreading a MessageAttaching a File to an Email MessageInserting a Picture into an Email MessageAdding a SignatureCreating a signatureEditing a signatureChoosing a signature to addDeleting a signatureAdding a Theme or StationerySetting a Message’s Priority and ConfidentialityMaking Sure They Got the MessageSetting a Delivery TimeDirecting Replies to Another AddressAdding Voting ButtonsWorking OfflineReceiving EmailReplying to or Forwarding an EmailOpening an AttachmentGetting NotifiedDeleting a MessageMarking a Message as UnreadFlagging a MessageFlagging a message you’ve receivedFlagging an outgoing messageFinding flagged messagesOrganizing MessagesRouting Incoming MessagesTranslating a MessagePrinting a MessageFighting SpamWhat If It’s Not Spam?Setting Up a Safe Senders ListManaging Junk EmailSaving Time with Quick StepsApplying a Quick StepCustomizing a Quick StepCreating Your Own Quick StepDeleting a Quick StepManaging Multiple Email AccountsAdding Another Email AccountKeeping Accounts StraightChoosing Which Account to Send From
11. Outlook’s Address Book
Adding and Editing ContactsAdding ContactsCreating a new contact from scratchCreating a new contact from an email messageImporting Email Addresses from Another ProgramImporting from Outlook Express, Windows Mail, or EudoraImporting from another email programEditing a Contact’s InformationEditing all fieldsCreating a new fieldAdding detailsEditing business cardsDeleting a contactFinding a ContactViewing ContactsSorting and Grouping ContactsSorting contactsGrouping contactsCustomizing a ViewSaving a ViewDeleting a ViewThe People PaneCommunicating with a ContactGathering Contacts into a GroupCreating a Contact GroupSending Email to a Contact GroupManaging a Contact GroupPrinting Your Contacts
12. Getting Organized with Folders
Finding Folders in the Navigation PaneCreating a New FolderFilling Up and Managing FoldersCopying a FolderMoving a FolderRenaming a FolderDeleting a FolderCategorizing ItemsAssigning a CategoryCreating a New CategoryViewing Items by CategoryClearing CategoriesRenaming a CategoryCustomizing ViewsCustomizing the Navigation PaneCustomizing the Reading PaneCustomizing the To-Do BarSearching FoldersSearching the Current FolderRepeating a SearchExpanding Your SearchRefining Your SearchDoing an Advanced SearchChanging Search SettingsCleaning Out FoldersArchiving Old DataSetting up AutoArchiveAdjusting AutoArchive settings for a specific folderArchiving manuallyCleaning up Your Mailbox
13. Getting Organized with Outlook’s Calendar, Tasks, and Notes
Your Schedule, Your CalendarCreating an Appointment or MeetingScheduling an AppointmentSetting up a MeetingAccepting an Invitation to a MeetingAdding or Removing AttendeesKeeping Track of Who’s AttendingCanceling a MeetingEditing EventsTurning an Appointment into a MeetingMaking an Event RecurGetting RemindersDeleting an AppointmentViewing Your ScheduleTasksAdding a TaskCreating a TaskCreating a recurring taskAssigning a taskAccepting a TaskManaging TasksEditing a TaskFlagging TasksMarking a Task as CompletedViewing TasksTaking Notes in OutlookAdding a NoteWorking with NotesViewing NotesIcon viewNotes List viewLast 7 Days view
Three. Excel
14. Creating Your First Spreadsheet
Creating a Basic WorksheetStarting a New WorkbookAdding the Column TitlesAdding DataEditing DataMoving Around the GridShortcut KeysThe Go To FeatureA Tour of the Excel WindowThe Tabs of the RibbonThe Formula BarThe Status BarGoing BackstageExcel OptionsSaving FilesThe Excel File FormatPreparing Your Spreadsheet for Excel 2007Saving Your Spreadsheet for Excel 2003Saving a Spreadsheet in Other FormatsSaving Your Spreadsheet As a PDFSaving Your Spreadsheet with a PasswordDisaster RecoveryAutoRecover settingsOpening FilesOpening Recent DocumentsProtected ViewOpening Files—with a TwistOpening Multiple Spreadsheets at OnceAdding Different Types of DataHow Excel Identifies TextHow Excel Identifies NumbersHow Excel Identifies Dates and TimesRegional DatingPrintingHow to Print an Excel FilePage Layout View: A Better Print PreviewCreating Headers and FootersControlling PaginationPage BreaksScalingPage Break Preview: A Bird’s-Eye View of Your Worksheet
15. Moving Data and Managing Worksheets
Selecting CellsMaking Continuous Range SelectionsMaking Noncontiguous SelectionsAutomatically Selecting Your DataMaking Selections with the KeyboardMoving Cells AroundA Simple Cut-and-Paste or Copy-and-PasteA Quicker Cut-and-Paste or Copy-and-PasteFancy Pasting TricksPaste SpecialAdding and Moving Columns or RowsInserting ColumnsInserting RowsInserting Copied or Cut CellsDeleting Columns and RowsWorksheets and WorkbooksAdding and Removing WorksheetsHiding WorksheetsNaming and Rearranging WorksheetsMoving Worksheets from one Workbook to Another
16. Formatting Cells
Formatting Cell ValuesChanging the Cell Value FormatFormatting NumbersGeneralNumberCurrencyAccountingPercentageFractionScientificTextFormatting Dates and TimesSpecial Formats for Special NumbersFormatting Cell AppearanceAlignment and OrientationFonts and ColorSpecial charactersBorders and Fills
17. Building Basic Formulas
Creating a Basic FormulaExcel’s Order of OperationsCell ReferencesHow Excel Formats Cells That Contain Cell ReferencesFunctionsUsing a Function in a FormulaUsing Cell References with a FunctionUsing Cell Ranges with a FunctionExcel Compatibility FunctionsFormula ErrorsLogical OperatorsFormula ShortcutsPoint-and-Click Formula CreationPoint-and-Click Formula EditingThe Formulas TabUsing the Insert Function ButtonCopying FormulasAbsolute Cell ReferencesPartially Fixed ReferencesReferring to Other Worksheets
18. A Function Sampler and Formula Troubleshooting
Rounding NumbersROUND(), ROUNDDOWN(), ROUNDUP(): Rounding NumbersManipulating TextCONCATENATE(): Joining Strings of Text TogetherLEFT(), MID(), and RIGHT(): Copying Portions of a Text StringTRIM() and CLEAN(): Removing Unwanted Spaces and Non-Printing CharactersSUBSTITUTE(): Replacing One Sequence of Characters with AnotherSolving Formula ErrorsStep-by-Step EvaluationTracing Precedents and DependentsError Checking
19. Creating Charts
Charting 101Embedded and Standalone ChartsCreating a Chart with the RibbonThe Chart Tools Ribbon TabsBasic Tasks with ChartsMoving and Resizing a ChartCreating a Standalone ChartEditing and Adding to Chart DataChanging the Chart TypePrinting ChartsEmbedded chartsStandalone chartsPractical ChartingCharts with Multiple Series of NumbersControlling the Data Excel Plots on the X-AxisData That Uses a Date or Time ScaleNon-Contiguous Chart RangesChanging the Order of Your Data SeriesChanging the Way Excel Plots Blank ValuesChart TypesColumnBarLinePieAreaChart Styles and LayoutsChart StylesChart LayoutsAdding Chart ElementsAdding TitlesAdding a LegendAdding Data Labels to a SeriesAdding Individual Data Labels
Four. PowerPoint
20. Creating a Presentation
Creating a New PresentationCreating a New Presentation from a TemplateChoosing a ThemeAdding Text to a SlideCreating a New SlideAdding ContentDeleting ContentSaving a PresentationOpening an Existing PresentationOpen a Recent Presentation from the Windows Start MenuOpen a Recent Presentation in PowerPointOpen Any Saved Presentation in PowerPointAdding NotesViewing a PresentationNormal ViewSlide Sorter ViewReading ViewNotes Page ViewSlide Show ViewZooming In and OutPrinting a Presentation
21. Editing Slides
Editing TextFormatting TextAdjusting Character SpacingPositioning TextFormatting a Text BoxCreating ListsLinking Text to a Web PageChecking Your SpellingTurning Text into WordArtEmbedding Other Files in SlidesEmbedding an Existing File in a SlideUpdating LinksCreating a New Embedded FileAdding Tables to SlidesInserting a TableInserting a table when you add a new slideInserting a table on an existing slideInsert a table using an Excel-style spreadsheetDrawing a tableAdding Information to a TableEditing a TableSelecting all or part of a tableResizing a tableMoving a tableChanging a table’s styleAdding Images to SlidesCreating a Photo AlbumSetting up a photo albumEditing a photo albumWorking with ShapesInserting a shapeChanging a shape’s size or positionAdding text to a shapeFormatting a shapeWorking with SmartArtInserting SmartArtConverting text to SmartArtAdding a shapeReordering shapesApplying a different layoutAdjusting a SmartArt graphic’s styleFormatting shapes within a SmartArt graphicRotating a SmartArt graphicResizing a SmartArt graphicWorking with Charts and DiagramsCreating a chart or diagram using ExcelCreating a diagram using shapesArranging Objects on a SlideAligning Objects on a SlideOrdering ObjectsGrouping Objects
22. Editing a Presentation
Copying, Rearranging, and Deleting SlidesCopying a SlideDuplicating a SlideInserting a Slide from a Different PresentationRearranging Slides in a PresentationDeleting a SlideHiding SlidesHeaders and FootersTime-Stamping Your SlidesAdding a Footer to Your SlidesNumbering SlidesAdding a Header and Footer to Notes and HandoutsOrganizing Your Presentation with SectionsCreating a SectionNaming a SectionCollapsing and Expanding SectionsMoving a Section Within a PresentationHiding All Slides Within a SectionRemoving a Section from a PresentationNavigating with Links and Action ButtonsInserting a Hyperlink to Another SlideCreating a Table of Contents for Your PresentationLinking to a Hidden SlideInserting an Action ButtonOpening an Inserted FileSlide Masters: Powerful Slide BlueprintsChanging the Look of All Slides in Your PresentationChanging the Layout for a Particular Type of SlideCreating a New LayoutWorking with Masters for Handouts and NotesModifying the handout masterModifying the notes masterCollaborating with OthersAdding and Reading CommentsInserting a commentReading commentsEditing a commentHiding commentsDeleting commentsComparing Versions of a Presentation
23. Adding Multimedia and Movement
Putting Media Clips in a PresentationAdding Video from Your Hard DriveAdding Video from a WebsiteAdding Animated Clip ArtAdding Sound from Your Hard DriveAdding Clip Art AudioRecording AudioFormatting Video ClipsAdjust brightness and contrastAdd a frame or borderAdd effectsCrop the playerFormatting Audio ClipsEditing Media ClipsUsing bookmarksTrimming a media clipFading in and fading outHide a clip until you want it to playOther media clip settingsAnimating ObjectsAnimating an ObjectChanging an AnimationAdjusting Effect OptionsAdding sound to an animationDimming textAnimating paragraphs and wordsAdding More AnimationCreating a Motion PathTriggering an AnimationTiming AnimationsReordering AnimationsRemoving an AnimationUsing the Animation PaneAnimating ListsAdjusting animation for individual list itemsGiving subitems their own animationAnimating a list as a single block of textStacking ObjectsAnimating SmartArt GraphicsCreating Transitions Between SlidesAdding a TransitionTweaking Transition EffectsAdding Sound to a TransitionTiming Transitions
24. It’s Showtime! Giving a Presentation
Start, Navigate, End: Tips and ShortcutsStarting a SlideshowMoving From Slide to SlideEnding a SlideshowBefore the Show: Prep WorkAdding Narration to Your PresentationRecording a narrationPlaying back a narrated slideshowTurning off narrationCreating a Custom SlideshowCreating a HandoutSetting Up Your ShowFollowing your notes in Presenter viewAt the EventSettings to CheckLaunching a SlideshowDuring the ShowHiding or showing the pointerMarking up slidesChanging markup colorErasing markupMaking the mouse pointer a laser pointerMaking the screen go blankSwitching to another program (and back)Ending the ShowOther Presentation OptionsBroadcasting a SlideshowCreating a Slideshow that Runs by ItselfCreating an Interactive SlideshowTurning Your Presentation into a VideoSharing Your PresentationPackaging Your Presentation on a CD or DVD
Five. Access
25. Creating Your First Database
Understanding Access DatabasesGetting Started with Your First DatabaseUnderstanding TablesCreating a Simple TableEditing a TableEdit modeDatasheet shortcut keysCut, copy, and pasteSaving DatabasesMaking BackupsSaving a Database with a Different Name or FormatOpening DatabasesDesignating a Database as TrustedOpening Recent DatabasesOpening More Than One Database at OnceThe Navigation PaneBrowsing Tables with the Navigation PaneManaging Database Objects
26. Building Smarter Tables
Understanding Data TypesDesign ViewOrganizing and Describing Your FieldsHow Updates Work in Design ViewAccess Data TypesTextText lengthMemoFormatted textNumberNumber sizeNumber formattingCurrencyDate/TimeCustom date formatsYes/NoHyperlinkAttachmentAutoNumberUsing AutoNumbers without revealing the size of your tableUsing replication IDsCalculatedThe Primary KeyCreating Your Own Primary Key FieldSix Principles of Database Design1. Choose Good Field Names2. Break Down Your Information3. Include All the Details in One Place4. Avoid Duplicating Information5. Avoid Redundant Information6. Include an ID FieldBlocking Bad DataData Integrity BasicsPreventing Blank FieldsBlank values and empty textSetting Default ValuesPreventing Duplicate Values with IndexesMultifield indexesLookupsCreating a Simple Lookup with Fixed ValuesAdding New Values to Your Lookup List
27. Mastering the Datasheet: Sorting, Searching, Filtering, and More
Datasheet CustomizationFormatting the DatasheetRearranging ColumnsResizing Rows and ColumnsHiding ColumnsFreezing ColumnsDatasheet NavigationSortingSorting on multiple fieldsFilteringQuick filtersFilter by selectionFilter by conditionSearchingPrinting the DatasheetPrint PreviewMoving around the print previewChanging the page layoutFine-Tuning a Printout
28. Linking Tables with Relationships
Relationship BasicsRedundant Data vs. Related DataMatching Fields: The Relationship LinkLinking with the ID ColumnThe Parent-Child RelationshipUsing a RelationshipDefining a RelationshipEditing RelationshipsReferential IntegrityBlank values for unlinked recordsCascading deletesCascading updatesNavigating a RelationshipLookups with Related TablesMore Exotic RelationshipsOne-to-One RelationshipsMany-to-Many RelationshipsJunction tablesMulti-value fields
Six. Other Office Tools
29. Publisher
Creating a New PublicationCreating a Publication from a TemplateCreating a Publication from ScratchViewing the PageEntering TextInserting an ImageAdding PagesNavigating PagesSaving a PublicationAdding TextEditing and Formatting TextAligning text within a text boxFitting text to a text boxAdjusting hyphenationWorking with character spacingFormatting textAdding some style to your textInserting Your Business InformationFlowing Text from One Box to AnotherFlowing text manuallyConnecting text boxes to autoflow textFlowing Text Around an ObjectAdding Pictures, Shapes, and Other ObjectsFormatting ObjectsFormatting picturesFormatting shapes and WordArtStacking and Grouping ObjectsDesigning and Laying Out PagesSetting up Your PagesChoosing a Color SchemeChoosing a Font SchemeUsing Layout GuidesSnapping an Object to a GuideReviewing Your DesignPrinting a PublicationPreparing a Publication for a Commercial Printer
30. OneNote
What is OneNote?Getting Familiar with the OneNote WorkspaceCreating and Filling up a NotebookAdding Notes to a PageTyping a notePasting in a noteDrawing a noteInserting a screen clippingRecording audio and video notesOrganizing a NotebookWorking with Sections and PagesMoving a sectionMerging sectionsMoving a pageChanging a page’s levelDeleting Notebooks, Sections, and PagesManaging Individual NotesWriting Side NotesLinking a Note to its SourceTagging a NoteCreating a custom tagFinding tagged notesRemoving a tagFinding a NoteSearching a pageChanging the scope of your searchViewing Your NotebooksSharing NotesFinding Changes Others Have MadeEmailing a PageUsing OneNote with Other Office ProgramsUsing Linked NotesViewing note linksRemoving links from linked notesTurning off linked notesGetting Office Files into OneNoteAttaching a file to a noteInserting a copy of a file into OneNote
31. Office Web Apps
Introducing Office on the WebSetting Up Office Web AppsSigning into SkyDriveCreating and Editing FilesSaving a Web Apps FileWorking with Folders in SkyDriveCreating a FolderViewing Files in a FolderRenaming a FolderDeleting a FolderManaging Files in SkyDriveOpening a FileUploading Files to SkyDrive from Your ComputerStarting point: your SkyDrive pageStarting point: a SkyDrive folderStarting point: an Office programDownloading Files from SkyDrive to Your ComputerMove, Rename, Delete: File Management TipsSharing FilesSetting PermissionsMaking a shared folder privateSharing a private folder or changing a shared folder’s permissionsLeaving CommentsSimultaneous Editing in ExcelDocs.com: Office Web Apps for FacebookAdding DocsCreating a doc from scratchUploading a file from your computerViewing Your DocsEditing a DocSharing a DocViewing Friends’ Docs
Seven. Appendix
A. Customizing Office 2010 Applications
Customizing the Quick Access ToolbarCustomizing the RibbonCustomizing the Status Bar
Index
About the Authors
Colophon
Copyright

Overview

Microsoft Office is the most widely used software suite in the world. The half-dozen programs in Office 2010 are packed with amazing features, but most people just know the basics. This entertaining guide not only gets you started with Office, it reveals all kinds of useful things you didn't know the software could do -- with plenty of power-user tips and tricks when you're ready for more.

Create professional-looking documents. Learn everything you need to know to craft beautiful Word documents.
Stay organized. Keep track of your email, calendar, and contacts with Outlook.
Crunch numbers with ease. Assemble data, make calculations, and summarize the results with Excel.
Make eye-catching presentations. Build PowerPoint slideshows with video and audio clips, animations, and more.
Build Access databases quickly. Make your data easy to find, sort, and manage.
Manage your files more efficiently. Use the new Backstage view to quickly work with your Office files.
Get to know the whole suite. Learn to use other handy Office tools: Publisher, OneNote, and Office Web Apps.

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

Publisher Resources

ISBN: 9781449382414Errata Page

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills