Microsoft Office 2010 Plain & Simple

by Katherine Murray

Overview

Get the fast facts that make learning Office 2010 plain and simple! This colorful, no-nonsense guide uses easy-to-follow steps and screenshots, and clear, concise language to show the simplest ways to get things done with Microsoft Word, Excel, Outlook, PowerPoint, Access, Publisher, and OneNote.

Here's WHAT You'll Learn

• Create documents, Web pages, and other publications
• Organize your e-mail, calendar, contacts and tasks
• Build spreadsheets to analyze and visualize data
• Set up a simple database
• Capture notes with ink, voice or text

Here's HOW You'll Learn It

• Jump in wherever you need answers
• Easy-to-follow STEPS and SCREENSHOTS show exactly what to do
• Handy TIPS teach new techniques and shortcuts
• Quick TRY THIS! Exercises help you apply what you learn right away

Product Details

ISBN-13:	9780735626973
Publisher:	Pearson Education
Publication date:	06/24/2010
Series:	Plain & Simple
Pages:	448
Product dimensions:	7.30(w) x 9.10(h) x 0.90(d)

About the Author

Katherine Murray is a communications expert who specializes in teaching people and businesses how to improve their productivity with Microsoft technologies. She has written more than 50 books related to Microsoft Office, Web technologies, and the digital lifestyle, including MICROSOFT OFFICE WORD 2007 INSIDE OUT.

Table of Contents

Acknowledgments; Chapter 1: About This Book; 1.1 No Computerspeak!; 1.2 A Quick Overview; 1.3 What's New in Office 2010?; 1.4 A Few Assumptions; 1.5 A Final Word (or Two); Chapter 2: Working in Office 2010; 2.1 What's What in Office 2010?; 2.2 Using the Ribbon; 2.3 Using Galleries and Lists; 2.4 Using Shortcut Menus and Dialog Boxes; 2.5 Using Only the Keyboard; 2.6 Moving and Copying Content; 2.7 Working with Backstage View; 2.8 Getting Help; 2.9 Saving Your Work; 2.10 Office's File Formats; Chapter 3: Common Tasks in Office; 3.1 Working with Old Documents; 3.2 Inserting Pictures; 3.3 Changing the Size of a Picture; 3.4 Editing a Picture; 3.5 Enhancing Your Pictures; 3.6 Making Your Pictures Pop; 3.7 Adding Clip Art; 3.8 Inserting Screenshots; 3.9 Adding Shapes; 3.10 Formatting a Shape; 3.11 Inserting the Date and Time; 3.12 Creating Stylized Text; 3.13 Inserting a SmartArt Diagram; 3.14 Translating Your Text; 3.15 Researching a Subject; Chapter 4: Viewing and Editing Text in Word; 4.1 What's Where in Word 2010?; 4.2 Creating a New Document; 4.3 Composing Different Types of Documents; 4.4 Word's Views; 4.5 Reading a Document; 4.6 Editing Text; 4.7 Discovering the Many Ways to Work with Text; 4.8 Navigating Your Document; 4.9 Replacing Text; 4.10 Correcting Your Spelling and Grammar; 4.11 Correcting Text Automatically; 4.12 Adding Page Numbers; 4.13 Co-Authoring in Word 2010; 4.14 Marking and Reviewing Changes in a Document; 4.15 Comparing Documents Side by Side; Chapter 5: Formatting in Word; 5.1 Controlling the Look: Themes, Styles, and Fonts; 5.2 Choosing a Theme for Your Document; 5.3 Formatting Text with Styles; 5.4 Choosing Styles from the Styles Window; 5.5 Changing Character Fonts; 5.6 Setting Paragraph Alignment; 5.7 Adjusting Paragraph Line Spacing; 5.8 Setting Spacing Between Paragraphs; 5.9 Indenting a Paragraph; 5.10 Formatting with Tabs; 5.11 Adding Emphasis and Special Formatting; 5.12 Copying Your Formatting; 5.13 Creating a Bulleted or Numbered List; 5.14 Formatting a List; 5.15 Creating a Table from Scratch; 5.16 Using a Predesigned Table; 5.17 Creating a Table from Text; 5.18 Adding or Deleting Rows and Columns; 5.19 Formatting a Table; 5.20 Improving the Layout with Hyphenation; 5.21 Laying Out the Page; 5.22 Creating Special Page Setups; 5.23 Creating Headers and Footers; 5.24 Changing Page Orientation Within a Document; 5.25 Flowing Text into Columns; 5.26 Creating Sections; 5.27 Wrapping Text Around a Graphic; 5.28 Sorting Your Information; 5.29 Reorganizing a Document; Chapter 6: Working with Special Content in Word; 6.1 Numbering Headings and Lines; 6.2 Inserting a Cover Page; 6.3 Inserting Information with Additional Actions; 6.4 Inserting an Equation; 6.5 Adding a Sidebar or a Pull Quote; 6.6 Inserting a Watermark; 6.7 Creating Footnotes and Endnotes; 6.8 Inserting a Citation; 6.9 Creating a Table of Contents; 6.10 Printing an Envelope; 6.11 Printing a Mailing Label; 6.12 Mail Merge: The Power and the Pain; 6.13 Creating a Form Letter; 6.14 Finalizing Your Document; Chapter 7: Working in Excel; 7.1 What's Where in Excel?; 7.2 Excel 2010 Basics; 7.3 Using a Predefined Workbook; 7.4 Choosing a Theme for Your Worksheet; 7.5 Entering the Data; 7.6 Editing the Data; 7.7 Formatting Cells; 7.8 Formatting Numbers; 7.9 Moving, Copying, and Pasting Data; 7.10 Adding and Deleting Columns and Rows; 7.11 Hiding Columns and Rows; 7.12 Creating a Data Series; 7.13 Formatting Cell Dimensions; 7.14 Organizing Your Worksheets; 7.15 Preparing for Printing; 7.16 Printing a Worksheet; 7.17 Adding and Viewing Comments; 7.18 Working with the Excel Web App; Chapter 8: Analyzing and Presenting Data in Excel; 8.1 Applying Conditional Formatting to Cells; 8.2 Customizing Conditional Formatting; 8.3 Cell References, Formulas, and Functions; 8.4 Adding Sparklines; 8.5 Introducing Formulas; 8.6 Doing the Math; 8.7 Summing the Data; 8.8 Making Calculations with Functions; 8.9 Creating a Series of Calculations; 8.10 Troubleshooting Formulas; 8.11 Creating a Table; 8.12 Sorting the Data; 8.13 Filtering the Data; 8.14 Separating Data into Columns; 8.15 Creating Subtotals; 8.16 Summarizing the Data with a PivotTable; 8.17 Adding Slicers; 8.18 Reviewing the Data; 8.19 The Anatomy of a Chart; 8.20 Charting Your Data; 8.21 Formatting a Chart; 8.22 Customizing a Chart; Chapter 9: Creating a PowerPoint Presentation; 9.1 What's Where in PowerPoint?; 9.2 Creating a Presentation; 9.3 Set the Page Background; 9.4 Entering Content; 9.5 Formatting a Slide; 9.6 Editing a Presentation; 9.7 Adding Headers and Footers; 9.8 Reusing Slides; 9.9 Modifying the Default Layout; 9.10 Inserting a Table; 9.11 Turning Text into SmartArt; 9.12 Applying WordArt Styleeeeees to Text; 9.13 Animating Items on a Slide; 9.14 Customizing Your Animation; 9.15 Adding an Action to a Slide; 9.16 Adding and Editing Video; 9.17 Adding Sound to Your Slides; 9.18 Setting Slide Transitions; 9.19 Creating a Photo Album; Chapter 10: Presenting a PowerPoint Slide Show; 10.1 Exploring Your Presentation Options; 10.2 Recording a Narration; 10.3 Timing a Presentation; 10.4 Adding Speaker Notes; 10.5 Customizing the Presentation; 10.6 Reviewing a Presentation; 10.7 Creating Different Versions of a Slide Show; 10.8 Printing Handouts; 10.9 Running a Slide Show; 10.10 Sharing a Presentation; 10.11 Publishing Your Slides; 10.12 Packaging Your Presentation; 10.13 Creating Pictures of Your Slides; 10.14 Saving Your Presentation as a Video; 10.15 Broadcasting Your Presentation; 10.16 Changing Slide-Show Settings; Chapter 11: Working with Messages in Outlook; 11.1 What's Where in Outlook Messages?; 11.2 Sending E-mail; 11.3 Receiving and Reading E-mail; 11.4 Replying to and Forwarding a Message; 11.5 Staying in Touch with Outlook Social Connector; 11.6 Sending or Receiving a File; 11.7 Formatting E-mail Messages; 11.8 Managing Messages with Quick Steps; 11.9 Signing Your E-mail; 11.10 Reading RSS Items; 11.11 Setting Up E-mail Accounts; Chapter 12: Organizing with Outlook; 12.1 A Quick Look at Outlook's Organizing Abilities; 12.2 Setting an Appointment; 12.3 Keeping Track of Your Schedule; 12.4 Sharing Calendars; 12.5 Viewing Your Group's Schedule; 12.6 Scheduling a Meeting; 12.7 Managing Your Contacts; 12.8 Keeping Track of Your Tasks; 12.9 Assigning Tasks; 12.10 Tacking Up Notes; 12.11 Creating and E-mailing Contact Business Cards; Chapter 13: Creating a Publication in Publisher; 13.1 Exploring the New Look of Publisher 2010; 13.2 Starting with a Template; 13.3 Creating a Publication from Scratch; 13.4 Adding Text; 13.5 Flowing Text Among Text Boxes; 13.6 Tweaking Your Text; 13.7 Inserting and Modifying a Picture; 13.8 Adding a Table; 13.9 Repeating Objects on Every Page; 13.10 Adding Building Blocks; 13.11 Arranging Objects on the Page; 13.12 Stacking and Grouping Objects; 13.13 Flowing Text Around an Object; 13.14 Reusing Content; 13.15 Inserting Your Contact Information; 13.16 Checking Your Publication; 13.17 Sending a Publication as E-mail; 13.18 Printing Your Publication; Chapter 14: Organize and Share Information in OneNote 2010; 14.1 What's Where in OneNote?; 14.2 OneNote Basics: Gathering Your Thoughts; 14.3 Creating a OneNote Notebook; 14.4 Adding and Working with Sections; 14.5 Inserting and Working with Notes Pages; 14.6 Inking in OneNote; 14.7 Adding Audio Notes; 14.8 Grabbing Web Clippings; 14.9 Sharing Notes in Word and PowerPoint; 14.10 Saving Outlook Data to OneNote; 14.11 Working with Side Notes and Unfiled Notes; Chapter 15: Working in Access; 15.1 What's Where in Access?; 15.2 Databases: A Simple Approach; 15.3 Creating a Database from a Template; 15.4 Using an Existing Database; 15.5 Adding a Data Table; 15.6 Adding and Changing Fields and Records; 15.7 Adding Data to a Table; 15.8 Importing Data; 15.9 Exporting Data; 15.10 Defining Table Relationships; 15.11 Creating a Form; 15.12 Creating a Report from the Data; 15.13 Formatting Reports; 15.14 Querying Information from Your Data Tables; 15.15 Analyzing Data with a PivotChart; Chapter 16: Customizing and Securing Office; 16.1 Customizing the Ribbon; 16.2 Customizing the Quick Access Toolbar; 16.3 Customizing the Work Area; 16.4 Customizing Your Editing; 16.5 Changing Your User Information; 16.6 Customizing the Spelling and Grammar Checkers; 16.7 Customizing Your Spelling Dictionaries; 16.8 Changing the Location and Type of Saved Files; 16.9 Understanding Security in Office 2010; 16.10 Changing File Validation; 16.11 Choosing What's Displayed in Protected View; 16.12 Password Protecting a File; 16.13 Limiting File Changes; 16.14 Recovering Unsaved Versions of a File; 16.15 Setting AutoRecover Options; 16.16 Signing a Document or Workbook with a Digital Signature; 16.17 Setting Macros, Add-Ins, and ActiveX Controls; 16.18 Checking File Compatibility;