book

Microsoft® Office 2010 Inside Out

Name: Microsoft® Office 2010 Inside Out
Author: Ed Bott and Carl Siechert
ISBN: 9780735647817

by Ed Bott and Carl Siechert

September 2010

Intermediate to advanced

960 pages

31h 34m

English

Microsoft Press

Read now

Unlock full access

Microsoft® Office 2010 Inside Out
Dedication
Acknowledgments
Book Support and Resources
Additional ResourcesYour Companion eBookErrata and Book SupportWe Want to Hear from YouStay in Touch
Conventions and Features Used in This Book
Text ConventionsDesign Conventions
1. Office Fundamentals
1. Inside Office 2010
What’s New? What’s Changed?A Field Guide to Office 2010 EditionsWord 2010Excel 2010OneNote 2010PowerPoint 2010Outlook 2010Sharing and Collaborating on Office Files
2. Installing and Updating Microsoft Office 2010
Choosing an Office EditionSystem Requirements for Office 2010Choosing Between 32-Bit and 64-Bit VersionsSetting Up OfficeInstalling from Retail MediaInstalling from the Web with Click-to-RunUpgrading from Office 2010 Starter EditionUpgrading from an Earlier Office VersionUsing Office Anytime UpgradeCustomizing Your Office InstallationValidating and Activating Your Copy of OfficeKeeping Office Up to DateSaving and Restoring Settings and Data
3. Using and Customizing the Office Interface
Managing Programs and Documents in Office Backstage ViewBackstage View in Word, Excel, and PowerPointSave, Save As, Open, CloseInfoRecentNewPrintSave & SendHelpBackstage View in OneNote and OutlookUsing and Customizing the RibbonUsing the RibbonGalleries and Live PreviewsPersonalizing the RibbonCustomizing the Quick Access ToolbarSaving and Reusing Custom Ribbon and Toolbar SettingsUsing and Customizing the Status BarAdjusting Program OptionsFinding Help and Support OptionsUsing Keyboard ShortcutsArranging and Switching Between Document Windows
4. Managing Office Files
Which File Formats Does Office 2010 Support?Understanding the Office 2010 Default Formats: Office Open XMLSetting a Default File FormatUsing Office 2010 Formats with Earlier Office VersionsChecking for Compatibility with Earlier Office VersionsOpening and Saving DocumentsSharing Your Work in PDF and Other FormatsUsing Templates to Streamline Document CreationOrganizing Office Documents Using File Properties and DetailsFinding Office FilesBackup and Recovery OptionsRestoring Previous Versions Saved by AutoRecoverRestoring Discarded Documents Saved by Autosave

5. Entering, Editing, and Formatting Text
Entering and Selecting TextEntering Symbols and Other Special CharactersEntering Characters with Insert SymbolEntering Characters with AutoCorrectEntering Characters with Character CodesExpert Text Editing TechniquesUsing Undo, Redo, and RepeatEntering Boilerplate and Other Oft-Used TextEntering HyperlinksEntering Mathematical EquationsApplying Text FormattingApplying Character FormattingApplying Paragraph FormattingUsing and Managing FontsCopying FormattingUsing the Clipboard with Office ProgramsUsing Paste OptionsSetting Default Paste OptionsManaging Multiple Clippings with the Office ClipboardFinding and Replacing Text and FormattingChecking SpellingCorrecting a Single WordCorrecting Spelling Throughout a DocumentSetting Options for Spelling CorrectionUsing Custom DictionariesUsing the Thesaurus and Other ReferencesSetting Language and Regional OptionsTranslating Text to Another Language
6. Working with Graphics and Pictures
Working with Drawing Layers in Office DocumentsSelecting Graphics and PicturesSelecting Text Boxes and WordArtWorking with Multiple Graphics and PicturesPositioning ObjectsAligning and Evenly Distributing ObjectsChanging the Z-Order of Stacked ObjectsResizing and Rotating Graphics and PicturesGrouping ObjectsInserting Pictures into Office DocumentsMaking Your Pictures Look GreatCropping PicturesAdjusting Colors and Applying Artistic EffectsApplying Picture StylesRemoving the Picture BackgroundUndoing Picture EditsFinding and Using Clip ArtCapturing and Inserting ScreenshotsAdding Shapes and Text BoxesDisplaying Data Graphically with ChartsAdding SmartArt to DocumentsApplying Text Effects with WordArtDrawing with InkUsing Office Themes
2. Word
7. Inside Word 2010
What’s in a Word Document?Working in an Appropriate Document ViewFull Screen Reading ViewWeb Layout ViewOutline ViewDraft ViewSwitching Views and ZoomingCreating and Editing DocumentsUsing TabsInserting Special CharactersChanging CaseControlling Line Breaks and HyphenationInserting the Date, Time, and Document PropertiesNavigating in Word DocumentsNavigating Within a DocumentWorking with Multiple Document WindowsSearching Within a DocumentSearching for Nonstandard CharactersIncluding Formatting in Your Search CriteriaRepeating a SearchSearching and ReplacingMaking Your Documents Look GoodFormatting TextFormatting ParagraphsSetting Page Layout OptionsAdding Headers, Footers, and Page NumbersGiving Your Documents a Consistent AppearanceApplying StylesMaking Global Changes to Your DocumentTools for Working with StylesCreating a New StyleApplying a Template to an Existing DocumentSaving and Modifying TemplatesAdding Pictures and GraphicsWorking with Bulleted and Numbered ListsChecking Grammar and Spelling
8. Working with Complex Documents
Using Outlines to Plan, Organize, and Edit DocumentsNavigating in Long DocumentsFormatting Columns and SectionsCreating a Multicolumn LayoutWorking with TablesCreating a TableUsing the Insert Table CommandDrawing a TableConverting Text to a TableUsing Quick TablesWorking with Table DataSelecting Table DataSorting Table DataUsing Formulas in TablesFormatting a TableAligning TextRotating TextAdding Borders and ShadingApplying StylesChanging the Table LayoutAdjusting Column Widths and Row HeightsAdding and Removing Rows and ColumnsMerging and Splitting Table CellsPositioning a TableWorking with Tables That Span a Page BreakDeleting a TableInserting References to Other Parts of a DocumentDefining Reference TargetsCreating Captions for Equations, Figures, and TablesInserting a ReferenceCreating Tables of Contents and IndexesInserting a Table of ContentsPreparing and Inserting an IndexMarking Index EntriesGenerating the Index
9. Reviewing and Sharing Documents
Using Review Comments in a DocumentInserting a CommentReviewing CommentsPrinting CommentsTracking and Highlighting Changes Made to a DocumentChanging View OptionsReviewing Tracked ChangesSetting Options for Tracking ChangesWorking Together with Other AuthorsPreparing a Document for DistributionChecking a DocumentProtecting a DocumentSaving a Document in a Shared LocationCreating and Working with FormsCreating a Form TemplateAdding Form FieldsProtecting and Using the Form
10. Word 2010 Inside Out
Applying Advanced Text-Formatting CapabilitiesApplying Shadows, Reflections, and Other Text EffectsUsing Ligatures and Other Fine Typography EffectsBeginning a Paragraph with a Drop CapUnderstanding Linked StylesUsing Word to Create and Edit Blog PostsManaging Blog AccountsWorking with Blog PostsCombining Documents and Data with Mail MergeUsing the Mail Merge WizardWorking with Data FilesInserting Data Fields in a DocumentPreviewing the Merged OutputCompleting the MergePrinting a DocumentUsing Building BlocksUsing AutoTextCreating Other Types of Building BlocksUsing Fields to Automate DocumentsWorking with Field CodesInserting a FieldOur Favorite Word Tweaks and TipsApplying Styles from the Quick Access ToolbarCustomizing the Quick Access Toolbar and the Status BarCustomizing Backstage ViewResetting Word OptionsReading Document Text AloudPrinting BookletsGenerating “Greek” Text
3. Excel
11. Inside Excel 2010
What’s in an Excel Workbook?Navigating in Worksheets and WorkbooksUsing Cell Addresses and Range NamesUsing Keyboard ShortcutsEntering and Filling in Data and SeriesUsing Formulas and FunctionsCreating and Editing FormulasMaking ComparisonsConcatenating TextRelative, Absolute, and Mixed ReferencesControlling the Order of Calculation in a FormulaAdding Functions to a FormulaMastering Excel’s Built-in FunctionsFinancial FunctionsDate and Time FunctionsText FunctionsLogical FunctionsStatistical FunctionsMath and Trigonometry FunctionsEngineering FunctionsInformation FunctionsLookup and Reference/Database/Cube FunctionsFormatting Cells and RangesNumberCurrency and AccountingDate and TimePercentageFractionScientificTextSpecial
12. Managing Lists and Data
Sorting Out Your Data Management OptionsTablesPivotTable ReportsExternal Database ConnectionsFormatting and Using TablesFormatting Tables with Table StylesExpanding (or Shrinking) a TableAdding Totals and Formulas to a TableSorting, Filtering, and Outlining DataSorting a Range, Region, or TableFiltering Data in a TableOutlining DataUsing PivotTablesCreating a PivotTableCustomizing a PivotTable LayoutChanging the Format of a PivotTableImporting, Exporting, and Connecting to Data Sources
13. Charts and Data Analysis
Using Charts to Visualize DataTurning Data into a ChartChoosing the Right Chart TypeColumn ChartsLine ChartsPie ChartsBar ChartsArea ChartsScatter (XY) ChartsStock ChartsOther Chart TypesLinking Worksheet Data to Chart ElementsAdvanced Chart Formatting OptionsHighlighting Trends and Variations in DataUsing Conditional Formatting to Highlight Cells Based on Their ContentUsing Sparklines to Visualize Trends Within a Range
14. Excel 2010 Inside Out
Customizing the Worksheet ViewHiding Rows and ColumnsArranging Worksheet WindowsSplitting, Freezing, and Locking PanesAdvanced Worksheet FormattingCreating Custom Cell FormatsNumber Format CodesDate/Time Format CodesText Format CodesConditionsCreating Custom Cell StylesFinding, Editing, Moving, and Copying DataUsing the Clipboard to Transform DataPasting Text and Formats into Multiple WorksheetsManipulating Text with FunctionsPrinting a WorksheetAdjusting Print SettingsDefining a Print AreaAdjusting Page BreaksUsing Data Validation to Control Data EntryOur Favorite Excel Tweaks and TipsChanging Default Formatting for a New WorkbookCreating Links Between Workbooks and WorksheetsNavigating with the Go To Dialog BoxEntering and Sorting Data with Custom SeriesGenerating Random Numbers
4. OneNote
15. Inside OneNote 2010
What’s in a OneNote Notebook?Creating and Opening OneNote FilesFilling a Notebook with Text, Pictures, Clippings, and MoreTextTextListsTablesPicturesWeb ClippingsScreen ClippingsInkEquationsE-Mail Messages and Other Outlook ItemsFile AttachmentsPrintoutsFormatting TextNavigating in OneNoteOpening and Moving Between NotebooksWorking with Sections and Section GroupsWorking with PagesUsing the OneNote Recycle BinCustomizing the Look and Feel of a Notebook PagePage TitlePage TitlePage ColorRule LinesBackground ImagePaper Size and MarginsPersonalizing the OneNote Interface
16. Tagging, Organizing, and Finding Information
Using Tags to Highlight Important NotesApplying and Removing TagsCustomizing TagsCopying Custom Tags to Another Copy of OneNoteUsing Links for Quick ConnectionsCreating Links to Web Pages or FilesCreating Links to Other Places in OneNoteEditing and Removing LinksSmart Search StrategiesSearching on a PageSearching by Section or NotebookReviewing Recently Modified PagesFinding Tagged NotesExpert Organizational TechniquesBacking Up and Recovering Notebooks
17. OneNote 2010 Inside Out
Using OneNote with OutlookSending E-Mail Messages to OneNoteLinking Outlook Contacts to OneNote PagesConnecting Appointments and Meetings to OneNoteUsing Outlook Tasks with OneNoteSending a OneNote Page via E-MailLinking Notes to Documents and Web PagesSharing and Synchronizing NotebooksPrinting, Publishing, and Sharing NotesRecording Audio and VideoOur Favorite OneNote Tweaks and TipsManaging the Recycle Bin and Page VersionsCustomizing the OneNote Taskbar IconUsing Side NotesConverting Printouts to TextSaving and Using Custom Page Templates
5. PowerPoint
18. Inside PowerPoint 2010
What’s in a PowerPoint Presentation?Composing a PresentationSlide BasicsSlide LayoutsPresentation View OptionsNormal View (Slides or Outline)Slide Sorter ViewReading ViewNotes Page ViewAbout Master ViewsSlide Show ViewEditing the Presentation TextSaving and Sharing a PresentationCompressing Your FileBuilding a Presentation from ScratchCreating a New PresentationAdding Slides from an OutlineUsing a Template or DesignUsing Slide SectionsAdding Graphics and Video ClipsInserting GraphicsWorking with GraphicsWorking with VideoInserting VideoEditing VideoWorking with AudioInserting AudioEditing AudioCustomizing Your Presentation’s DesignFormatting TextSetting Page Layout OptionsApplying ThemesAdding Backgrounds
19. Polishing and Delivering a Presentation
Adding Emphasis with AnimationsNeed a Little Inspiration?Adding AnimationLayering Animation EffectsSetting Animation TimingDuplicating Animations with Animation PainterTriggering an Animation EffectSetting Additional Effect OptionsUsing Transitions Between SlidesPlanning and Rehearsing a PresentationRecording NarrationDelivering a Live PresentationNavigating in Slide Show ViewAdding Annotations During a Slide ShowTurning Your Mouse into a Laser PointerWorking with Presenter ViewCreating Notes and HandoutsPrinting NotesPrinting HandoutsAdjusting Color OptionsEditing the Handout Header and FooterEditing Handouts in Word
20. PowerPoint 2010 Inside Out
Broadcasting a PresentationSaving and Reusing Slides and ThemesReusing SlidesSaving ThemesCreating Custom Slide ShowsHiding Slides to Create Dynamic PresentationsDefining a Custom ShowWorking Collaboratively on a PresentationUsing CommentsMerging and Comparing PresentationsLaying the Groundwork for an Expert PresentationCustomizing the Slide MasterCreating a Custom LayoutCustomizing Other MastersCreating a Photo Album with PowerPointTurning Your Presentation into a VideoOur Favorite PowerPoint Tweaks and TipsInserting HyperlinksInserting Action ButtonsEmbedding Fonts in a Presentation FilePlaying Music Behind Your SlidesCreating a CD Presentation PackageCreating Custom Bullets
6. Outlook
21. Inside Outlook 2010
What’s in an Outlook Profile?Outlook ItemsE-Mail MessagesAppointmentsMeetingsContactsTasksNotesJournal EntriesPersonalizing the Outlook InterfaceCustomizing the Navigation PaneOrganizing the To-Do BarUsing the Reading PaneSetting Up Mail AccountsUsing Internet-Standard Mail ServersConfiguring Exchange AccountsUsing Windows Live Hotmail with OutlookSetting Up a Webmail Account from a Non-Microsoft ServiceOrganizing Your ContactsUsing Contact Cards for Quick ViewingBrowsing the Contents of a Contacts FolderChanging Display Names and Sort OrderSearching for ContactsCreating and Using Contact GroupsDealing with Duplicate ContactsManaging Your CalendarCreating and Editing Appointments and MeetingsSetting Up Recurring Appointments and EventsCreating, Sending, and Receiving MessagesChoosing the Right Message FormatAdding and Editing E-Mail Signatures
22. Organizing Outlook Information
Managing Outlook Data Files and FoldersManaging Data FilesUsing and Managing FoldersMastering Outlook SearchChanging the Scope of a SearchAdding Criteria to a SearchBuilding Search Queries with KeywordsCreating and Using Search FoldersSelecting and Customizing Views in OutlookCreating and Saving Custom ViewsViewing E-Mail ConversationsOrganizing E-Mail MessagesConfiguring Quick StepsUsing Rules to Manage Messages AutomaticallyUsing Address Books and Directory Services
23. Outlook 2010 Inside Out
Setting Follow-up Flags and RemindersSharing and Comparing CalendarsArranging Multiple CalendarsWorking with Meeting InvitationsSharing Contact and Calendar Items via E-MailSharing a Calendar via E-Mail or the WebReceiving and Synchronizing DataImporting and Exporting Outlook DataArchiving Outlook DataQuick Cleanup TechniquesArchiving Messages ManuallyAutomatic Archive OptionsReading RSS Feeds in OutlookUsing Outlook Social Connector and the People PaneOur Favorite Outlook Tweaks and TipsChanging Default Formatting for New E-Mail MessagesAttaching Pictures to Contact RecordsJuggling Multiple Time ZonesManaging Auto-Complete Lists and Suggested ContactsRepairing a Damaged Data File
7. Sharing and Collaborating
24. Security, Sharing, and Collaboration
How Office 2010 Protects YouWhat You Can and Can’t Do in Protected ViewWorking Safely with File AttachmentsInspecting and Removing Personal and Confidential InformationFine-Tuning Security SettingsWorking Together with Office 2010Inserting Comments for ReviewTracking Changes to DocumentsComparing VersionsSimultaneous Editing with Multiple AuthorsSharing Documents on a NetworkSharing Documents from a SharePoint Site
25. Using Office in a Web Browser
What Can You Do with Office on the Web?Storing and Using Office Documents on Windows Live SkyDriveCreating New FoldersCreating New FoldersUploading One or More FilesCreating a New FileSetting PermissionsSharing Files and Folders with Other PeopleManaging Files and Folders in SkyDriveSaving Files to SkyDrive from Office ProgramsSynchronizing Office Files with SkyDriveWhat You Can and Can’t Do with Office Web AppsWordExcelPowerPointOneNote
26. Working with SharePoint 2010
What’s in a SharePoint Site or Workspace?SharePoint Users, Groups, and PermissionsCreating a New SharePoint SiteHow SharePoint and Office Work TogetherCustomizing a SharePoint SiteCreating and Using SharePoint LibrariesManaging Files in a Document LibraryChanging Settings for a Document LibraryCreating, Viewing, and Editing SharePoint ListsCreating and Editing SharePoint PagesConnecting Lists, Calendars, and Discussions to OutlookUsing Notifications and Feeds to Track SharePoint Activity
Index
About the Authors
Copyright

Overview

Dive into the essential features in Microsoft Word 2010, Excel 2010, OneNote 2010, Outlook 2010, and PowerPoint 2010. This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Let the experts help you become at ease and proficient with every program in the Office family.

Create great-looking documents using expert formatting tips.

Build spreadsheets for complex calculations and data analysis.

Save notes, clippings, web pages, and more in a notebook.

Create dynamic slides and video-powered presentations.

Expertly manage your inbox and business information.

Protect your security and safeguard private information.

Collaborate with Windows Live SkyDrive and SharePoint.

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: 9780735647817Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills