3 Review(s)

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. About the Authors Nancy Conner has a Ph.D. in English from Brown University and has taught writing, including technical writing, to college students for more than a dozen years. She is currently a freelance copyeditor, specializing in technical books covering topics ranging from the MS Office suite to programming languages to advanced network security. Matthew MacDonald is a developer, author, and educator in all things Visual Basic and .NET. He's worked with Visual Basic and ASP since their initial versions, and has written over a dozen books on the subject, including The Book of VB .NET (No Starch Press) and Visual Basic 2005: A Developer's Notebook (O'Reilly). He has also written a number of Missing Manual titles on Excel 2007 and Access 2007 (O’Reilly). His website is http://www.prosetech.com/. Table of Contents Word Chapter 1 Basic Word Processing Opening Word Creating a New Document Typing in Some Text Saving a Document Closing a Document Opening an Existing Document Different Ways to View Your Work Chapter 2 Editing and Formatting Selecting and Moving Text Finding and Replacing Text Text Formatting: Font, Size, and Style Paragraph Formatting: Aligning, Indenting, Spacing Working with Lists Formatting a Document Chapter 3 Tables, Graphics, and Charts Creating a Table Adding Information to a Table Editing a Table Formatting a Table Inserting Images Editing an Image Fun with Fonts and Art That's Smart Adding Charts and Diagrams Chapter 4 Proofing and Research Tools Checking Spelling and Grammar Getting Things Right with AutoCorrect Word's Built-in Research Tools Chapter 5 Printing Documents Getting Started with Printing Selecting Print Options and Settings Sending a Fax Printing Envelopes Printing Labels Merging Names and Addresses with Documents Chapter 6 Reports and Long Documents Inserting Page Breaks Breaking a Document into Sections Footnotes and Endnotes Citations and Bibliographies Helping Readers Navigate Your Document Chapter 7 Customizing Your Documents with Themes, Templates, and Macros Themes: The Way to Better Designs Templates: Reusable Document Blueprints Save Time with Macros Chapter 8 Desktop and Web Publishing Newsletters and Brochures Web Page Design Chapter 9 Sharing and Collaborating on Documents Sharing a Document Adding Comments Tracking Changes Comparing Documents Combining Documents Protecting Your Documents Coauthoring and Simultaneous Editing Outlook Chapter 10 Getting Started with Outlook Setting Up Outlook Taking a Quick Look Around Composing and Sending Email Receiving Email Printing a Message Fighting Spam Saving Time with Quick Steps Managing Multiple Email Accounts Chapter 11 Outlook's Address Book Adding and Editing Contacts Finding a Contact Viewing Contacts Communicating with a Contact Gathering Contacts into a Group Printing Your Contacts Chapter 12 Getting Organized with Folders Finding Folders in the Navigation Pane Creating a New Folder Filling Up and Managing Folders Categorizing Items Customizing Views Searching Folders Cleaning Out Folders Chapter 13 Getting Organized with Outlook's Calendar, Tasks, and Notes Your Schedule, Your Calendar Creating an Appointment or Meeting Editing Events Viewing Your Schedule Tasks Adding a Task Managing Tasks Viewing Tasks Taking Notes in Outlook Excel Chapter 14 Creating Your First Spreadsheet Creating a Basic Worksheet Moving Around the Grid A Tour of the Excel Window Saving Files Opening Files Adding Different Types of Data Printing Controlling Pagination Chapter 15 Moving Data and Managing Worksheets Selecting Cells Moving Cells Around Adding and Moving Columns or Rows Worksheets and Workbooks Chapter 16 Formatting Cells Formatting Cell Values Formatting Cell Appearance Chapter 17 Building Basic Formulas Creating a Basic Formula Functions Formula Errors Logical Operators Formula Shortcuts Copying Formulas Chapter 18 A Function Sampler and Formula Troubleshooting Rounding Numbers Manipulating Text Solving Formula Errors Chapter 19 Creating Charts Charting 101 Basic Tasks with Charts Practical Charting Chart Types Chart Styles and Layouts Adding Chart Elements PowerPoint Chapter 20 Creating a Presentation Creating a New Presentation Saving a Presentation Opening an Existing Presentation Adding Notes Viewing a Presentation Printing a Presentation Chapter 21 Editing Slides Editing Text Embedding Other Files in Slides Adding Tables to Slides Adding Images to Slides Arranging Objects on a Slide Chapter 22 Editing a Presentation Copying, Rearranging, and Deleting Slides Headers and Footers Organizing Your Presentation with Sections Navigating with Links and Action Buttons Slide Masters: Powerful Slide Blueprints Collaborating with Others Chapter 23 Adding Multimedia and Movement Putting Media Clips in a Presentation Animating Objects Creating Transitions Between Slides Chapter 24 It's Showtime! Giving a Presentation Start, Navigate, End: Tips and Shortcuts Before the Show: Prep Work At the Event Other Presentation Options Sharing Your Presentation Access Chapter 25 Creating Your First Database Understanding Access Databases Getting Started with Your First Database Saving Databases Opening Databases The Navigation Pane Chapter 26 Building Smarter Tables Understanding Data Types Design View Access Data Types The Primary Key Six Principles of Database Design Blocking Bad Data Data Integrity Basics Lookups Chapter 27 Mastering the Datasheet: Sorting, Searching, Filtering, and More Datasheet Customization Datasheet Navigation Printing the Datasheet Chapter 28 Linking Tables with Relationships Relationship Basics Using a Relationship More Exotic Relationships Other Office Tools Chapter 29 Publisher Creating a New Publication Adding Text Adding Pictures, Shapes, and Other Objects Designing and Laying Out Pages Reviewing Your Design Printing a Publication Chapter 30 OneNote What is OneNote? Creating and Filling up a Notebook Organizing a Notebook Managing Individual Notes Viewing Your Notebooks Sharing Notes Using OneNote with Other Office Programs Chapter 31 Office Web Apps Introducing Office on the Web Setting Up Office Web Apps Creating and Editing Files Working with Folders in SkyDrive Managing Files in SkyDrive Sharing Files Docs.com: Office Web Apps for Facebook Appendix Appendix Customizing Office 2010 Applications Customizing the Quick Access Toolbar Customizing the Ribbon Customizing the Status Bar Colophon