Sign up
Forgot password?
FAQ: Login

Bott Ed, Siechert Carl. Microsoft Office 2010 Inside Out

  • pdf file
  • size 38,82 MB
  • added by
  • info modified
Bott Ed, Siechert Carl. Microsoft Office 2010 Inside Out
Microsoft Press, 2011. — 959 p.
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.
Book Support and Resources.
Additional Resources.
Errata and Book Support.
We Want to Hear from You.
Stay in Touch.
Conventions and Features Used in This Book.
Text Conventions.
Design Conventions.
Office Fundamentals
Inside Office 2010.
What’s New? What’s Changed?
A Field Guide to Office 2010 Editions.
Word 2010.
Excel 2010.
OneNote 2010.
PowerPoint 2010.
Outlook 2010.
Sharing and Collaborating on Office Files.
Installing and Updating Microsoft Office 2010
Choosing an Office Edition.
System Requirements for Office 2010.
Choosing Between 32-Bit and 64-Bit Versions.
Setting Up Office.
Installing from Retail Media.
Installing from the Web with Click-to-Run.
Upgrading from Office 2010 Starter Edition.
Upgrading from an Earlier Office Version.
Using Office Anytime Upgrade.
Customizing Your Office Installation.
Validating and Activating Your Copy of Office.
Keeping Office Up to Date.
Saving and Restoring Settings and Data.
Using and Customizing the Office Interface
Managing Programs and Documents in Office Backstage View.
Backstage View in Word, Excel, and PowerPoint.
Backstage View in OneNote and Outlook.
Using and Customizing the Ribbon.
Using the Ribbon.
Galleries and Live Previews.
Personalizing the Ribbon.
Customizing the Quick Access Toolbar.
Saving and Reusing Custom Ribbon and Toolbar Settings.
Using and Customizing the Status Bar.
Adjusting Program Options.
Finding Help and Support Options.
Using Keyboard Shortcuts.
Arranging and Switching Between Document Windows.
Managing Office Files
Which File Formats Does Office 2010 Support? 76
Understanding the Office 2010 Default Formats: Office Open XML.
Setting a Default File Format.
Using Office 2010 Formats with Earlier Office Versions.
Checking for Compatibility with Earlier Office Versions.
Opening and Saving Documents.
Sharing Your Work in PDF and Other Formats.
Using Templates to Streamline Document Creation.
Organizing Office Documents Using File Properties and Details.
Finding Office Files.
Backup and Recovery Options.
Restoring Previous Versions Saved by AutoRecover.
Restoring Discarded Documents Saved by Autosave.
Entering, Editing, and Formatting Text
Entering and Selecting Text.
Entering Symbols and Other Special Characters.
Expert Text Editing Techniques.
Using Undo, Redo, and Repeat.
Entering Boilerplate and Other Oft-Used Text.
Entering Hyperlinks.
Entering Mathematical Equations.
Applying Text Formatting.
Applying Character Formatting.
Applying Paragraph Formatting.
Using and Managing Fonts.
Copying Formatting.
Using the Clipboard with Office Programs.
Using Paste Options.
Setting Default Paste Options.
Managing Multiple Clippings with the Office Clipboard.
Finding and Replacing Text and Formatting.
Checking Spelling.
Correcting a Single Word.
Correcting Spelling Throughout a Document.
Setting Options for Spelling Correction.
Using Custom Dictionaries.
Using the Thesaurus and Other References.
Setting Language and Regional Options.
Translating Text to Another Language.
Working with Graphics and Pictures
Working with Drawing Layers in Office Documents.
Selecting Graphics and Pictures.
Positioning Objects.
Resizing and Rotating Graphics and Pictures.
Grouping Objects.
Inserting Pictures into Office Documents.
Making Your Pictures Look Great.
Cropping Pictures.
Adjusting Colors and Applying Artistic Effects.
Applying Picture Styles.
Removing the Picture Background.
Undoing Picture Edits.
Finding and Using Clip Art.
Capturing and Inserting Screenshots.
Adding Shapes and Text Boxes.
Displaying Data Graphically with Charts.
Adding SmartArt to Documents.
Applying Text Effects with WordArt.
Drawing with Ink.
Using Office Themes.
Word
Inside Word 2010.
What’s in a Word Document?
Working in an Appropriate Document View.
Full Screen Reading View.
Web Layout View.
Outline View.
Draft View.
Switching Views and Zooming.
Creating and Editing Documents.
Using Tabs.
Inserting Special Characters.
Changing Case.
Controlling Line Breaks and Hyphenation.
Inserting the Date, Time, and Document Properties.
Navigating in Word Documents.
Navigating Within a Document.
Working with Multiple Document Windows.
Searching Within a Document.
Searching for Nonstandard Characters.
Including Formatting in Your Search Criteria.
Repeating a Search.
Searching and Replacing.
Making Your Documents Look Good.
Formatting Text.
Formatting Paragraphs.
Setting Page Layout Options.
Adding Headers, Footers, and Page Numbers.
Giving Your Documents a Consistent Appearance.
Applying Styles.
Making Global Changes to Your Document.
Tools for Working with Styles.
Creating a New Style.
Applying a Template to an Existing Document.
Saving and Modifying Templates.
Adding Pictures and Graphics.
Working with Bulleted and Numbered Lists.
Checking Grammar and Spelling.
Working with Complex Documents
Using Outlines to Plan, Organize, and Edit Documents.
Navigating in Long Documents.
Formatting Columns and Sections.
Creating a Multicolumn Layout.
Working with Tables.
Creating a Table.
Working with Table Data.
Formatting a Table.
Changing the Table Layout.
Deleting a Table.
Inserting References to Other Parts of a Document.
Defining Reference Targets.
Inserting a Reference.
Creating Tables of Contents and Indexes.
Inserting a Table of Contents.
Preparing and Inserting an Index.
Reviewing and Sharing Documents
Using Review Comments in a Document.
Inserting a Comment.
Reviewing Comments.
Printing Comments.
Tracking and Highlighting Changes Made to a Document.
Changing View Options.
Reviewing Tracked Changes.
Setting Options for Tracking Changes.
Working Together with Other Authors.
Preparing a Document for Distribution.
Checking a Document.
Protecting a Document.
Saving a Document in a Shared Location.
Creating and Working with Forms.
Creating a Form Template.
Adding Form Fields.
Protecting and Using the Form.
Word 2010 Inside Out
Applying Advanced Text-Formatting Capabilities.
Applying Shadows, Reflections, and Other Text Effects.
Using Ligatures and Other Fine Typography Effects.
Beginning a Paragraph with a Drop Cap.
Understanding Linked Styles.
Using Word to Create and Edit Blog Posts.
Managing Blog Accounts.
Working with Blog Posts.
Combining Documents and Data with Mail Merge.
Using the Mail Merge Wizard.
Working with Data Files.
Inserting Data Fields in a Document.
Previewing the Merged Output.
Completing the Merge.
Printing a Document.
Using Building Blocks.
Using AutoText.
Creating Other Types of Building Blocks.
Using Fields to Automate Documents.
Working with Field Codes.
Inserting a Field.
Our Favorite Word Tweaks and Tips.
Applying Styles from the Quick Access Toolbar.
Customizing the Quick Access Toolbar and the Status Bar.
Customizing Backstage View.
Resetting Word Options.
Reading Document Text Aloud.
Printing Booklets.
Generating Greek Text.
Excel
Inside Excel 2010.
What’s in an Excel Workbook?
Navigating in Worksheets and Workbooks.
Using Cell Addresses and Range Names.
Using Keyboard Shortcuts.
Entering and Filling in Data and Series.
Using Formulas and Functions.
Creating and Editing Formulas.
Adding Functions to a Formula.
Mastering Excel’s Built-in Functions.
Formatting Cells and Ranges.
Number.
Currency and Accounting.
Date and Time.
Percentage.
Fraction.
Scientific.
Text.
Special.
Managing Lists and Data
Sorting Out Your Data Management Options.
Tables.
PivotTable Reports.
External Database Connections.
Formatting and Using Tables.
Formatting Tables with Table Styles.
Expanding (or Shrinking) a Table.
Adding Totals and Formulas to a Table.
Sorting, Filtering, and Outlining Data.
Sorting a Range, Region, or Table. Filtering Data in a Table.
Outlining Data.
Using PivotTables.
Creating a PivotTable.
Customizing a PivotTable Layout.
Changing the Format of a PivotTable.
Importing, Exporting, and Connecting to Data Sources.
Charts and Data Analysis
Using Charts to Visualize Data.
Turning Data into a Chart.
Choosing the Right Chart Type.
Column Charts.
Line Charts.
Pie Charts.
Bar Charts.
Area Charts.
Scatter (XY) Charts.
Stock Charts.
Other Chart Types.
Linking Worksheet Data to Chart Elements.
Advanced Chart Formatting Options.
Highlighting Trends and Variations in Data.
Using Conditional Formatting to Highlight Cells Based on Their Content.
Using Sparklines to Visualize Trends Within a Range.
Excel 2010 Inside Out
Customizing the Worksheet View.
Hiding Rows and Columns.
Arranging Worksheet Windows.
Splitting, Freezing, and Locking Panes.
Advanced Worksheet Formatting.
Creating Custom Cell Formats.
Creating Custom Cell Styles.
Finding, Editing, Moving, and Copying Data.
Using the Clipboard to Transform Data.
Manipulating Text with Functions.
Printing a Worksheet.
Adjusting Print Settings.
Defining a Print Area.
Adjusting Page Breaks.
Using Data Validation to Control Data Entry.
Our Favorite Excel Tweaks and Tips.
Changing Default Formatting for a New Workbook.
Creating Links Between Workbooks and Worksheets.
Navigating with the Go To Dialog Box.
Entering and Sorting Data with Custom Series.
Generating Random Numbers.
OneNote.
Inside OneNote 2010.
What’s in a OneNote Notebook? 490
Creating and Opening OneNote Files.
Filling a Notebook with Text, Pictures, Clippings, and More.
Formatting Text.
Navigating in OneNote.
Opening and Moving Between Notebooks.
Working with Sections and Section Groups.
Working with Pages.
Using the OneNote Recycle Bin.
Customizing the Look and Feel of a Notebook Page.
Personalizing the OneNote Interface.
Tagging, Organizing, and Finding Information
Using Tags to Highlight Important Notes.
Applying and Removing Tags.
Customizing Tags.
Copying Custom Tags to Another Copy of OneNote.
Using Links for Quick Connections.
Creating Links to Web Pages or Files.
Editing and Removing Links.
Smart Search Strategies.
Searching on a Page.
Searching by Section or Notebook.
Reviewing Recently Modiﯤed Pages.
Finding Tagged Notes.
Expert Organizational Techniques.
Backing Up and Recovering Notebooks.
OneNote 2010 Inside Out
Using OneNote with Outlook.
Sending E-Mail Messages to OneNote.
Linking Outlook Contacts to OneNote Pages.
Connecting Appointments and Meetings to OneNote.
Using Outlook Tasks with OneNote.
Sending a OneNote Page via E-Mail.
Linking Notes to Documents and Web Pages.
Sharing and Synchronizing Notebooks.
Printing, Publishing, and Sharing Notes.
Recording Audio and Video.
Our Favorite OneNote Tweaks and Tips.
Managing the Recycle Bin and Page Versions.
Customizing the OneNote Taskbar Icon.
Using Side Notes.
Converting Printouts to Text.
Saving and Using Custom Page Templates.
PowerPoint
Inside PowerPoint 2010.
What’s in a PowerPoint Presentation? 579
Composing a Presentation.
Presentation View Options.
Editing the Presentation Text.
Saving and Sharing a Presentation.
Building a Presentation from Scratch.
Creating a New Presentation.
Using Slide Sections.
Adding Graphics and Video Clips.
Inserting Graphics.
Working with Graphics.
Working with Video.
Working with Audio.
Customizing Your Presentation’s Design.
Formatting Text.
Setting Page Layout Options.
Applying Themes.
Adding Backgrounds.
Polishing and Delivering a Presentation
Adding Emphasis with Animations.
Need a Little Inspiration?
Adding Animation.
Layering Animation Effects.
Setting Animation Timing.
Duplicating Animations with Animation Painter.
Triggering an Animation Effect.
Setting Additional Effect Options.
Using Transitions Between Slides.
Planning and Rehearsing a Presentation.
Recording Narration.
Delivering a Live Presentation.
Navigating in Slide Show View.
Adding Annotations During a Slide Show.
Turning Your Mouse into a Laser Pointer.
Working with Presenter View.
Creating Notes and Handouts.
Printing Notes.
Printing Handouts.
Adjusting Color Options.
Editing the Handout Header and Footer.
Editing Handouts in Word.
PowerPoint 2010 Inside Out.
Broadcasting a Presentation.
Saving and Reusing Slides and Themes.
Reusing Slides.
Saving Themes.
Creating Custom Slide Shows.
Hiding Slides to Create Dynamic Presentations.
Deﯤning a Custom Show.
Working Collaboratively on a Presentation.
Using Comments.
Merging and Comparing Presentations.
Laying the Groundwork for an Expert Presentation.
Customizing the Slide Master.
Creating a Custom Layout.
Customizing Other Masters.
Creating a Photo Album with PowerPoint.
Turning Your Presentation into a Video.
Our Favorite PowerPoint Tweaks and Tips.
Inserting Hyperlinks.
Inserting Action Buttons.
Embedding Fonts in a Presentation File.
Playing Music Behind Your Slides.
Creating a CD Presentation Package.
Creating Custom Bullets.
Outlook
Inside Outlook 2010.
What’s in an Outlook Profile? 690
Outlook Items.
Personalizing the Outlook Interface.
Customizing the Navigation Pane.
Organizing the To-Do Bar.
Using the Reading Pane.
Setting Up Mail Accounts.
Using Internet-Standard Mail Servers.
Configuring Exchange Accounts.
Using Windows Live Hotmail with Outlook.
Setting Up a Webmail Account from a Non-Microsoft Service.
Organizing Your Contacts.
Using Contact Cards for Quick Viewing.
Browsing the Contents of a Contacts Folder.
Changing Display Names and Sort Order.
Searching for Contacts.
Creating and Using Contact Groups.
Dealing with Duplicate Contacts. Managing Your Calendar.
Creating and Editing Appointments and Meetings.
Setting Up Recurring Appointments and Events.
Creating, Sending, and Receiving Messages.
Choosing the Right Message Format.
Adding and Editing E-Mail Signatures.
Organizing Outlook Information
Managing Outlook Data Files and Folders.
Managing Data Files.
Using and Managing Folders.
Mastering Outlook Search.
Changing the Scope of a Search.
Adding Criteria to a Search.
Building Search Queries with Keywords.
Creating and Using Search Folders.
Selecting and Customizing Views in Outlook.
Creating and Saving Custom Views.
Viewing E-Mail Conversations.
Organizing E-Mail Messages.
Configuring Quick Steps.
Using Rules to Manage Messages Automatically.
Using Address Books and Directory Services.
Outlook 2010 Inside Out
Setting Follow-up Flags and Reminders.
Sharing and Comparing Calendars.
Arranging Multiple Calendars.
Working with Meeting Invitations.
Sharing Contact and Calendar Items via E-Mail.
Sharing a Calendar via E-Mail or the Web.
Receiving and Synchronizing Data.
Importing and Exporting Outlook Data.
Archiving Outlook Data.
Quick Cleanup Techniques.
Archiving Messages Manually.
Automatic Archive Options.
Reading RSS Feeds in Outlook.
Using Outlook Social Connector and the People Pane.
Our Favorite Outlook Tweaks and Tips.
Changing Default Formatting for New E-Mail Messages.
Attaching Pictures to Contact Records.
Juggling Multiple Time Zones.
Managing Auto-Complete Lists and Suggested Contacts.
Repairing a Damaged Data File.
Sharing and Collaborating.
Security, Sharing, and Collaboration.
How Office 2010 Protects You.
What You Can and Can't Do in Protected View.
Working Safely with File Attachments.
Inspecting and Removing Personal and Confidential Information.
Fine-Tuning Security Settings.
Working Together with Office 2010.
Inserting Comments for Review.
Tracking Changes to Documents.
Comparing Versions.
Simultaneous Editing with Multiple Authors.
Sharing Documents on a Network.
Sharing Documents from a SharePoint Site.
Using Office in a Web Browser
What Can You Do with Office on the Web?
Storing and Using Office Documents on Windows Live SkyDrive.
What You Can and Can't Do with Office Web Apps.
Word.
Excel.
PowerPoint.
OneNote.
Working with SharePoint 2010
What's in a SharePoint Site or Workspace?
SharePoint Users, Groups, and Permissions.
Creating a New SharePoint Site.
How SharePoint and Office Work Together.
Customizing a SharePoint Site.
Creating and Using SharePoint Libraries.
Creating, Viewing, and Editing SharePoint Lists.
Creating and Editing SharePoint Pages.
Connecting Lists, Calendars, and Discussions to Outlook.
Using Notifications and Feeds to Track SharePoint Activity.
Index to Troubleshooting Topics.
  • Sign up or login using form at top of the page to download this file.
  • Sign up
Up