Office 2013: The Missing Manual

by Nancy Conner, Matthew MacDonald

Overview

Microsoft Office is the most widely used productivity software in the world, but most people just know the basics. This helpful guide gets you started with the programs in Office 2013, and provides lots of power-user tips and tricks when you’re ready for more. You’ll learn about Office’s new templates and themes, touchscreen features, and other advances, including Excel’s Quick Analysis tool.

The important stuff you need to know:

• Create professional-looking documents. Use Word to craft reports, newsletters, and brochures for the Web and desktop.
• Stay organized. Set up Outlook to track your email, contacts, appointments, and tasks.
• Work faster with Excel. Determine the best way to present your data with the new Quick Analysis tool.
• Make inspiring presentations. Build PowerPoint slideshows with video and audio clips, charts and graphs, and animations.
• Share your Access database. Design a custom database and let other people view it in their web browsers.
• Get to know the whole suite. Use other handy Office tools: Publisher, OneNote, and a full range of Office Web Apps.
• Create and share documents in the cloud. Upload and work with your Office files in Microsoft’s SkyDrive.

Product Details

ISBN-13:	9781449359423
Publisher:	O'Reilly Media, Incorporated
Publication date:	05/22/2013
Sold by:	Barnes & Noble
Format:	eBook
Pages:	1050
File size:	31 MB
Note:	This product may take a few minutes to download.

About the Author

Nancy Conner has a PhD 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 author and copyeditor specializing in technical books, and has written on topics ranging from classical mythology to Google Apps to the MS Office suite.

Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.

Table of Contents

The Missing Credits; About the Authors; About the Creative Team; Acknowledgements; The Missing Manual Series; Introduction; What Is Office 2013?; Flavors of Office 2013; What’s New in Office 2013; About This Book; The Very Basics; About the Online Resources; Safari® Books Online; Part 1: Using Office; Chapter 1: Using Office 2013’s Common Features; 1.1 Opening an Office 2013 Program; 1.2 The Start Screen; 1.3 Working with the Ribbon; 1.4 Going Backstage; 1.5 Customizing Office Applications; Part 2: Word; Chapter 2: Basic Word Processing; 2.1 First Things First: Word’s Start Page; 2.2 Creating a New Document; 2.3 Typing Some Text; 2.4 Saving a Document; 2.5 Closing a Document; 2.6 Opening an Existing Document; 2.7 Different Ways to View Your Work; Chapter 3: Editing and Formatting; 3.1 Selecting and Moving Text; 3.2 Finding and Replacing Text; 3.3 Text Formatting: Font, Size, and Style; 3.4 Paragraph Formatting: Aligning, Indenting, Spacing; 3.5 Working with Lists; 3.6 Formatting a Document; Chapter 4: Tables, Graphics, and Charts; 4.1 Creating a Table; 4.2 Adding Information to a Table; 4.3 Editing a Table; 4.4 Formatting a Table; 4.5 Inserting Images; 4.6 Editing an Image; 4.7 Fun with Fonts and Art That’s Smart; 4.8 Adding Charts and Diagrams; Chapter 5: Proofing and Research Tools; 5.1 Checking Spelling and Grammar; 5.2 Getting Things Right with AutoCorrect; 5.3 Word’s Built-in Research Tools; Chapter 6: Printing Documents; 6.1 Getting Started with Printing; 6.2 Selecting Print Options and Settings; 6.3 Sending a Fax; 6.4 Printing Envelopes; 6.5 Printing Labels; 6.6 Merging Names and Addresses with Documents; Chapter 7: Reports and Long Documents; 7.1 Inserting Page Breaks; 7.2 Breaking a Document into Sections; 7.3 Footnotes and Endnotes; 7.4 Citations and Bibliographies; 7.5 Helping Readers Navigate Your Document; Chapter 8: Customizing Documents with Themes, Templates, and Macros; 8.1 Themes: The Way to Better Designs; 8.2 Templates: Reusable Document Blueprints; 8.3 Saving Time with Macros; Chapter 9: Desktop and Web Publishing; 9.1 Newsletters and Brochures; 9.2 Web Page Design; Chapter 10: Sharing and Collaborating on Documents; 10.1 Sharing a Document; 10.2 Getting Feedback; 10.3 Comparing Documents; 10.4 Combining Documents; 10.5 Protecting Your Documents; 10.6 Coauthoring and Simultaneous Editing; Part 3: Outlook; Chapter 11: Getting Started with Outlook; 11.1 Setting Up Outlook; 11.2 Taking a Quick Look Around; 11.3 Composing and Sending Email; 11.4 Receiving Email; 11.5 Printing a Message; 11.6 Fighting Spam; 11.7 Saving Time with Quick Steps; 11.8 Managing Multiple Email Accounts; Chapter 12: Outlook’s Address Book; 12.1 Adding and Editing Contacts; 12.2 Finding a Contact; 12.3 Viewing Contacts; 12.4 Communicating with a Contact; 12.5 Gathering Contacts into a Group; 12.6 Printing Your Contacts; 12.7 Contacts and Social Networking; Chapter 13: Getting Organized with Folders; 13.1 Finding Folders in the Navigation Pane; 13.2 Creating a New Folder; 13.3 Filling Up and Managing Folders; 13.4 Categorizing Items; 13.5 Searching Folders; 13.6 Cleaning Out Folders; Chapter 14: Getting Organized with Outlook’s Calendar, Tasks, and Notes; 14.1 Your Schedule, Your Calendar; 14.2 Creating an Appointment or Meeting; 14.3 Editing Events; 14.4 Viewing Your Schedule; 14.5 Tasks; 14.6 Adding a Task; 14.7 Managing Tasks; 14.8 Viewing Tasks; 14.9 Taking Notes in Outlook; Part 4: Excel; Chapter 15: Creating Your First Spreadsheet; 15.1 Starting a Workbook; 15.2 Adding Information to a Worksheet; 15.3 Using the Ribbon; 15.4 Using the Status Bar; 15.5 Saving Files; 15.6 Opening Files; 15.7 Adding Different Types of Data; 15.8 Printing; 15.9 Controlling Pagination; Chapter 16: Moving Data; 16.1 Selecting Cells; 16.2 Moving Cells Around; 16.3 Adding and Moving Columns or Rows; 16.4 Worksheets and Workbooks; Chapter 17: Formatting Cells; 17.1 Formatting Cell Values; 17.2 Formatting Cell Appearance; Chapter 18: Building Basic Formulas; 18.1 Creating a Basic Formula; 18.2 Functions; 18.3 Formula Errors; 18.4 Logical Operators; 18.5 Formula Shortcuts; 18.6 Copying Formulas; Chapter 19: Math and Statistical Functions; 19.1 Rounding Numbers; 19.2 Manipulating Text; 19.3 Solving Formula Errors; Chapter 20: Creating Basic Charts; 20.1 Charting 101; 20.2 Basic Tasks with Charts; 20.3 Practical Charting; 20.4 Chart Types; 20.5 Chart Styles and Layouts; 20.6 Adding Chart Elements; Part 5: PowerPoint; Chapter 21: Creating a Presentation; 21.1 Creating a New Presentation; 21.2 Saving a Presentation; 21.3 Opening an Existing Presentation; 21.4 Adding Notes; 21.5 Viewing a Presentation; 21.6 Printing a Presentation; Chapter 22: Editing Slides; 22.1 Editing Text; 22.2 Embedding Other Files in Slides; 22.3 Adding Tables to Slides; 22.4 Adding Images to Slides; 22.5 Arranging Objects on a Slide; Chapter 23: Editing a Presentation; 23.1 Copying, Rearranging, and Deleting Slides; 23.2 Headers and Footers; 23.3 Organizing Your Presentation with Sections; 23.4 Navigating with Links and Action Buttons; 23.5 Slide Masters: Powerful Slide Blueprints; 23.6 Collaborating with Others; Chapter 24: Adding Multimedia and Movement; 24.1 Putting Media Clips in a Presentation; 24.2 Animating Objects; 24.3 Creating Transitions Between Slides; Chapter 25: It’s Showtime! Giving a Presentation; 25.1 Start, Navigate, End: Tips and Shortcuts; 25.2 Before the Show: Prep Work; 25.3 At the Event; 25.4 Other Presentation Options; 25.5 Sharing Your Presentation; Part 6: Access; Chapter 26: Creating Your First Database; 26.1 Understanding Access Databases; 26.2 Starting a Database; 26.3 Building Your First Table; 26.4 Saving Databases; 26.5 Opening Databases; 26.6 The Navigation Pane; Chapter 27: Building Smarter Tables; 27.1 Understanding Data Types; 27.2 Design View; 27.3 Access Data Types; 27.4 The Primary Key; 27.5 Six Principles of Database Design; 27.6 Blocking Bad Data; 27.7 Data Integrity Basics; 27.8 Lookups; Chapter 28: Mastering the Datasheet: Sorting, Searching, and Filtering; 28.1 Datasheet Customization; 28.2 Datasheet Navigation; 28.3 Printing the Datasheet; Chapter 29: Linking Tables with Relationships; 29.1 Relationship Basics; 29.2 Using a Relationship; 29.3 More Exotic Relationships; Part 7: Other Office Tools; Chapter 30: Publisher; 30.1 Creating a New Publication; 30.2 Adding Text; 30.3 Adding Pictures, Shapes, and Other Objects; 30.4 Designing and Laying Out Pages; 30.5 Reviewing Your Design; 30.6 Printing a Publication; Chapter 31: OneNote; 31.1 What Is OneNote?; 31.2 Creating and Filling Up a Notebook; 31.3 Organizing a Notebook; 31.4 Managing Individual Notes; 31.5 Viewing Your Notebooks; 31.6 Sharing Notes; 31.7 Using OneNote with Other Office Programs; Chapter 32: SkyDrive and Office Web Apps; 32.1 Introducing Office on the Web; 32.2 Setting Up Office Web Apps; 32.3 What’s New in Office Web Apps; 32.4 Creating and Editing Files; 32.5 Working with Folders in SkyDrive; 32.6 Managing Files in SkyDrive; 32.7 Sharing Files and Folders; 32.8 Docs.com: Office Web Apps for Facebook;