Microsoft Office 2010 Inside Out

Table of Contents

Dedication; Acknowledgments; 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; Part 1: Office Fundamentals; Chapter 1: Inside Office 2010; 1.1 What’s New? What’s Changed?; 1.2 A Field Guide to Office 2010 Editions; 1.3 Word 2010; 1.4 Excel 2010; 1.5 OneNote 2010; 1.6 PowerPoint 2010; 1.7 Outlook 2010; 1.8 Sharing and Collaborating on Office Files; Chapter 2: Installing and Updating Microsoft Office 2010; 2.1 Choosing an Office Edition; 2.2 Setting Up Office; 2.3 Customizing Your Office Installation; 2.4 Validating and Activating Your Copy of Office; 2.5 Keeping Office Up to Date; 2.6 Saving and Restoring Settings and Data; Chapter 3: Using and Customizing the Office Interface; 3.1 Managing Programs and Documents in Office Backstage View; 3.2 Using and Customizing the Ribbon; 3.3 Customizing the Quick Access Toolbar; 3.4 Saving and Reusing Custom Ribbon and Toolbar Settings; 3.5 Using and Customizing the Status Bar; 3.6 Adjusting Program Options; 3.7 Finding Help and Support Options; 3.8 Using Keyboard Shortcuts; 3.9 Arranging and Switching Between Document Windows; Chapter 4: Managing Office Files; 4.1 Which File Formats Does Office 2010 Support?; 4.2 Opening and Saving Documents; 4.3 Sharing Your Work in PDF and Other Formats; 4.4 Using Templates to Streamline Document Creation; 4.5 Organizing Office Documents Using File Properties and Details; 4.6 Finding Office Files; 4.7 Backup and Recovery Options; Chapter 5: Entering, Editing, and Formatting Text; 5.1 Entering and Selecting Text; 5.2 Expert Text Editing Techniques; 5.3 Applying Text Formatting; 5.4 Using the Clipboard with Office Programs; 5.5 Finding and Replacing Text and Formatting; 5.6 Checking Spelling; 5.7 Using the Thesaurus and Other References; 5.8 Setting Language and Regional Options; 5.9 Translating Text to Another Language; Chapter 6: Working with Graphics and Pictures; 6.1 Working with Drawing Layers in Office Documents; 6.2 Inserting Pictures into Office Documents; 6.3 Making Your Pictures Look Great; 6.4 Finding and Using Clip Art; 6.5 Capturing and Inserting Screenshots; 6.6 Adding Shapes and Text Boxes; 6.7 Displaying Data Graphically with Charts; 6.8 Adding SmartArt to Documents; 6.9 Applying Text Effects with WordArt; 6.10 Drawing with Ink; 6.11 Using Office Themes; Part 2: Word; Chapter 7: Inside Word 2010; 7.1 What’s in a Word Document?; 7.2 Working in an Appropriate Document View; 7.3 Creating and Editing Documents; 7.4 Navigating in Word Documents; 7.5 Searching Within a Document; 7.6 Making Your Documents Look Good; 7.7 Giving Your Documents a Consistent Appearance; 7.8 Adding Pictures and Graphics; 7.9 Working with Bulleted and Numbered Lists; 7.10 Checking Grammar and Spelling; Chapter 8: Working with Complex Documents; 8.1 Using Outlines to Plan, Organize, and Edit Documents; 8.2 Formatting Columns and Sections; 8.3 Working with Tables; 8.4 Inserting References to Other Parts of a Document; 8.5 Creating Tables of Contents and Indexes; Chapter 9: Reviewing and Sharing Documents; 9.1 Using Review Comments in a Document; 9.2 Tracking and Highlighting Changes Made to a Document; 9.3 Working Together with Other Authors; 9.4 Preparing a Document for Distribution; 9.5 Saving a Document in a Shared Location; 9.6 Creating and Working with Forms; Chapter 10: Word 2010 Inside Out; 10.1 Applying Advanced Text-Formatting Capabilities; 10.2 Using Word to Create and Edit Blog Posts; 10.3 Combining Documents and Data with Mail Merge; 10.4 Printing a Document; 10.5 Using Building Blocks; 10.6 Using Fields to Automate Documents; 10.7 Our Favorite Word Tweaks and Tips; Part 3: Excel; Chapter 11: Inside Excel 2010; 11.1 What’s in an Excel Workbook?; 11.2 Navigating in Worksheets and Workbooks; 11.3 Entering and Filling in Data and Series; 11.4 Using Formulas and Functions; 11.5 Formatting Cells and Ranges; Chapter 12: Managing Lists and Data; 12.1 Sorting Out Your Data Management Options; 12.2 Formatting and Using Tables; 12.3 Sorting, Filtering, and Outlining Data; 12.4 Using PivotTables; 12.5 Importing, Exporting, and Connecting to Data Sources; Chapter 13: Charts and Data Analysis; 13.1 Using Charts to Visualize Data; 13.2 Turning Data into a Chart; 13.3 Choosing the Right Chart Type; 13.4 Linking Worksheet Data to Chart Elements; 13.5 Advanced Chart Formatting Options; 13.6 Highlighting Trends and Variations in Data; Chapter 14: Excel 2010 Inside Out; 14.1 Customizing the Worksheet View; 14.2 Advanced Worksheet Formatting; 14.3 Finding, Editing, Moving, and Copying Data; 14.4 Printing a Worksheet; 14.5 Using Data Validation to Control Data Entry; 14.6 Our Favorite Excel Tweaks and Tips; Part 4: OneNote; Chapter 15: Inside OneNote 2010; 15.1 What’s in a OneNote Notebook?; 15.2 Filling a Notebook with Text, Pictures, Clippings, and More; 15.3 Formatting Text; 15.4 Navigating in OneNote; 15.5 Customizing the Look and Feel of a Notebook Page; 15.6 Personalizing the OneNote Interface; Chapter 16: Tagging, Organizing, and Finding Information; 16.1 Using Tags to Highlight Important Notes; 16.2 Using Links for Quick Connections; 16.3 Smart Search Strategies; 16.4 Expert Organizational Techniques; 16.5 Backing Up and Recovering Notebooks; Chapter 17: OneNote 2010 Inside Out; 17.1 Using OneNote with Outlook; 17.2 Linking Notes to Documents and Web Pages; 17.3 Sharing and Synchronizing Notebooks; 17.4 Printing, Publishing, and Sharing Notes; 17.5 Recording Audio and Video; 17.6 Our Favorite OneNote Tweaks and Tips; Part 5: PowerPoint; Chapter 18: Inside PowerPoint 2010; 18.1 What’s in a PowerPoint Presentation?; 18.2 Building a Presentation from Scratch; 18.3 Adding Graphics and Video Clips; 18.4 Customizing Your Presentation’s Design; Chapter 19: Polishing and Delivering a Presentation; 19.1 Adding Emphasis with Animations; 19.2 Using Transitions Between Slides; 19.3 Planning and Rehearsing a Presentation; 19.4 Delivering a Live Presentation; 19.5 Creating Notes and Handouts; Chapter 20: PowerPoint 2010 Inside Out; 20.1 Broadcasting a Presentation; 20.2 Saving and Reusing Slides and Themes; 20.3 Creating Custom Slide Shows; 20.4 Working Collaboratively on a Presentation; 20.5 Laying the Groundwork for an Expert Presentation; 20.6 Creating a Photo Album with PowerPoint; 20.7 Turning Your Presentation into a Video; 20.8 Our Favorite PowerPoint Tweaks and Tips; Part 6: Outlook; Chapter 21: Inside Outlook 2010; 21.1 What’s in an Outlook Profile?; 21.2 Personalizing the Outlook Interface; 21.3 Setting Up Mail Accounts; 21.4 Organizing Your Contacts; 21.5 Managing Your Calendar; 21.6 Creating, Sending, and Receiving Messages; Chapter 22: Organizing Outlook Information; 22.1 Managing Outlook Data Files and Folders; 22.2 Mastering Outlook Search; 22.3 Selecting and Customizing Views in Outlook; 22.4 Organizing E-Mail Messages; 22.5 Using Address Books and Directory Services; Chapter 23: Outlook 2010 Inside Out; 23.1 Setting Follow-up Flags and Reminders; 23.2 Sharing and Comparing Calendars; 23.3 Receiving and Synchronizing Data; 23.4 Importing and Exporting Outlook Data; 23.5 Archiving Outlook Data; 23.6 Reading RSS Feeds in Outlook; 23.7 Using Outlook Social Connector and the People Pane; 23.8 Our Favorite Outlook Tweaks and Tips; Part 7: Sharing and Collaborating; Chapter 24: Security, Sharing, and Collaboration; 24.1 How Office 2010 Protects You; 24.2 Working Together with Office 2010; 24.3 Simultaneous Editing with Multiple Authors; Chapter 25: Using Office in a Web Browser; 25.1 What Can You Do with Office on the Web?; 25.2 Storing and Using Office Documents on Windows Live SkyDrive; 25.3 What You Can and Can’t Do with Office Web Apps; Chapter 26: Working with SharePoint 2010; 26.1 What’s in a SharePoint Site or Workspace?; 26.2 How SharePoint and Office Work Together; 26.3 Customizing a SharePoint Site; 26.4 Connecting Lists, Calendars, and Discussions to Outlook; 26.5 Using Notifications and Feeds to Track SharePoint Activity;

Ed Bott is an award-winning journalist and one of the most recognized voices in the computing world. He's known to millions of readers through two decades of writing for leading industry publications and more than 25 books on Microsoft® Office and Windows®.

Carl Siechert specializes in writing and producing product documentation for the personal computer industry. Carl has coauthored dozens of books, including WINDOWS® 7 INSIDE OUT, MICROSOFT® WINDOWS XP NETWORKING AND SECURITY INSIDE OUT, and several other popular titles.