Visit www.dummies.com/cheatsheet/officehomestudent2013aio to view this book's cheat sheet.
Table of Contents
Introduction
What’s in This Book, Anyway?
What Makes This Book Different
Easy-to-look-up information
A task-oriented approach
Meaningful screen shots
Foolish Assumptions
Conventions Used in This Book
Icons Used in This Book
Book I: Common Office Tasks
Book I: Chapter 1: Office Nuts and Bolts
A Survey of Office Applications
Starting an Office Program
Starting an Office program in Windows 7 and Vista
Starting an Office program in Windows 8
Finding Your Way Around the Office Interface
The File tab and Backstage
The Quick Access toolbar
The Ribbon and its tabs
Context-sensitive tabs
The anatomy of a tab
Live previewing
Mini-toolbars and shortcut menus
Office 2013 for keyboard lovers
Saving Your Files
Saving a file
Saving a file for the first time
Declaring where you like to save files
Saving AutoRecovery information
Navigating the Save As and Open Windows
Opening and Closing Files
Opening a file
Closing a file
Reading and Recording File Properties
Locking a File with a Password
Password-protecting a file
Removing a password from a file
Book I: Chapter 2: Wrestling with the Text
Manipulating the Text
Selecting text
Moving and copying text
Taking advantage of the Clipboard task pane
Deleting text
Changing the Look of Text
Choosing fonts for text
Changing the font size of text
Applying font styles to text
Applying text effects to text
Underlining text
Changing the color of text
Quick Ways to Handle Case, or Capitalization
Entering Symbols and Foreign Characters
Creating Hyperlinks
Linking a hyperlink to a web page
Creating a hyperlink to another place in your file
Creating an e-mail hyperlink
Repairing and removing hyperlinks
Book I: Chapter 3: Speed Techniques Worth Knowing About
Undoing and Repeating Commands
Undoing a mistake
Repeating an action — and quicker this time
Zooming In, Zooming Out
Viewing a File Through More Than One Window
Correcting Typos on the Fly
Entering Text Quickly with the AutoCorrect Command
Book II: Word 2013
Book II: Chapter 1: Speed Techniques for Using Word
Introducing the Word Screen
Creating a New Document
Getting a Better Look at Your Documents
Viewing documents in different ways
Splitting the screen
Selecting Text in Speedy Ways
Moving Around Quickly in Documents
Keys for getting around quickly
Navigating from page to page or heading to heading
Going there fast with the Go To command
Bookmarks for hopping around
Inserting a Whole File into a Document
Entering Information Quickly in a Computerized Form
Creating a computerized form
Entering data in the form
Book II: Chapter 2: Laying Out Text and Pages
Paragraphs and Formatting
Inserting a Section Break for Formatting Purposes
Breaking a Line
Starting a New Page
Setting Up and Changing the Margins
Indenting Paragraphs and First Lines
Clicking an Indent button (for left-indents)
“Eyeballing it” with the ruler
Indenting in the Paragraph dialog box
Numbering the Pages
Numbering with page numbers only
Including a page number in a header or footer
Changing page number formats
Putting Headers and Footers on Pages
Creating, editing, and removing headers and footers
Fine-tuning a header or footer
Adjusting the Space between Lines
Adjusting the Space Between Paragraphs
Creating Numbered and Bulleted Lists
Simple numbered and bulleted lists
Constructing lists of your own
Managing a multilevel list
Working with Tabs
Hyphenating Text
Automatically and manually hyphenating a document
Unhyphenating and other hyphenation tasks
Book II: Chapter 3: Word Styles
All About Styles
Styles and templates
Types of styles
Applying Styles to Text and Paragraphs
Applying a style
Experimenting with style sets
Choosing which style names appear on the Style menus
Creating a New Style
Creating a style from a paragraph
Creating a style from the ground up
Modifying a Style
Creating and Managing Templates
Creating a new template
Opening a template so that you can modify it
Modifying, deleting, and renaming styles in templates
Book II: Chapter 4: Constructing the Perfect Table
Talking Table Jargon
Creating a Table
Entering the Text and Numbers
Selecting Different Parts of a Table
Laying Out Your Table
Changing the size of a table, columns, and rows
Adjusting column and row size
Inserting columns and rows
Deleting columns and rows
Moving columns and rows
Aligning Text in Columns and Rows
Merging and Splitting Cells
Repeating Header Rows on Subsequent Pages
Formatting Your Table
Designing a table with a table style
Calling attention to different rows and columns
Decorating your table with borders and colors
Using Math Formulas in Tables
Neat Table Tricks
Changing the direction of header row text
Wrapping text around a table
Using a picture as the table background
Drawing diagonal lines on tables
Drawing on a table
Book II: Chapter 5: Taking Advantage of the Proofing Tools
Correcting Your Spelling Errors
Correcting misspellings one at a time
Running a spell-check
Preventing text from being spell checked
Checking for Grammatical Errors in Word
Getting a Word Definition
Finding and Replacing Text
The basics: Finding stray words and phrases
Narrowing your search
Conducting a find-and-replace operation
Researching a Topic Inside Word
Finding the Right Word with the Thesaurus
Proofing Text Written in a Foreign Language
Telling Office which languages you will use
Marking text as foreign language text
Translating Foreign Language Text
Book II: Chapter 6: Desktop Publishing with Word
Experimenting with Themes
Sprucing Up Your Pages
Decorating a page with a border
Putting a background color on pages
Getting Word’s help with cover letters
Making Use of Charts, Diagrams, Shapes, Clip Art, and Photos
Working with the Drawing Canvas
Positioning and Wrapping Objects Relative to the Page and Text
Wrapping text around an object
Positioning an object on a page
Working with Text Boxes
Inserting a text box
Making text flow from text box to text box
Dropping In a Drop Cap
Watermarking for the Elegant Effect
Putting Newspaper-Style Columns in a Document
Doing the preliminary work
Running text into columns
Landscape Documents
Printing on Different Size Paper
Showing Online Video in a Document
Book II: Chapter 7: Getting Word’s Help with Office Chores
Highlighting Parts of a Document
Commenting on a Document
Entering a comment
Viewing and displaying comments
Caring for and feeding comments
Tracking Changes to Documents
Telling Word to start marking changes
Reading and reviewing a document with change marks
Marking changes when you forgot to turn on change marks
Accepting and rejecting changes to a document
Printing an Address on an Envelope
Printing a Single Address Label (Or a Page of the Same Label)
Churning Out Letters, Envelopes, and Labels for Mass Mailings
Preparing the source file
Merging the document with the source file
Printing form letters, envelopes, and labels
Book II: Chapter 8: Tools for Reports and Scholarly Papers
Alphabetizing a List
Outlines for Organizing Your Work
Viewing the outline in different ways
Rearranging document sections in Outline view
Collapsing and Expanding Parts of a Document
Generating a Table of Contents
Creating a TOC
Updating and removing a TOC
Customizing a TOC
Changing the structure of a TOC
Indexing a Document
Marking index items in the document
Generating the index
Editing an index
Putting Cross-References in a Document
Putting Footnotes and Endnotes in Documents
Entering a footnote or endnote
Choosing the numbering scheme and position of notes
Deleting, moving, and editing notes
Compiling a Bibliography
Inserting a citation for your bibliography
Editing a citation
Changing how citations appear in text
Generating the bibliography
Book III: Excel 2013
Book III: Chapter 1: Up and Running with Excel
Creating a New Excel Workbook
Getting Acquainted with Excel
Rows, columns, and cell addresses
Workbooks and worksheets
Entering Data in a Worksheet
The basics of entering data
Entering text labels
Entering numeric values
Entering date and time values
Quickly Entering Lists and Serial Data with the AutoFill Command
Formatting Numbers, Dates, and Time Values
Conditional Formats for Calling Attention to Data
Establishing Data-Validation Rules
Book III: Chapter 2: Refining Your Worksheet
Editing Worksheet Data
Moving Around in a Worksheet
Getting a Better Look at the Worksheet
Freezing and splitting columns and rows
Hiding columns and rows
Comments for Documenting Your Worksheet
Selecting Cells in a Worksheet
Deleting, Copying, and Moving Data
Handling the Worksheets in a Workbook
Keeping Others from Tampering with Worksheets
Hiding a worksheet
Protecting a worksheet
Book III: Chapter 3: Formulas and Functions for Crunching Numbers
How Formulas Work
Referring to cells in formulas
Referring to formula results in formulas
Operators in formulas
The Basics of Entering a Formula
Speed Techniques for Entering Formulas
Clicking cells to enter cell references
Entering a cell range
Naming cell ranges so that you can use them in formulas
Referring to cells in different worksheets
Copying Formulas from Cell to Cell
Detecting and Correcting Errors in Formulas
Correcting errors one at a time
Running the error checker
Tracing cell references
Working with Functions
Using arguments in functions
Entering a function in a formula
Book III: Chapter 4: Making a Worksheet Easier to Read and Understand
Laying Out a Worksheet
Aligning numbers and text in columns and rows
Inserting and deleting rows and columns
Changing the size of columns and rows
Decorating a Worksheet with Borders and Colors
Cell styles for quickly formatting a worksheet
Formatting cells with table styles
Slapping borders on worksheet cells
Decorating worksheets with colors
Getting Ready to Print a Worksheet
Making a worksheet fit on a page
Making a worksheet more presentable
Repeating row and column headings on each page
Book III: Chapter 5: Advanced Techniques for Analyzing Data
Seeing What the Sparklines Say
Managing Information in Lists
Sorting a list
Filtering a list
Forecasting with the Goal Seek Command
Performing What-If Analyses with Data Tables
Using a one-input table for analysis
Using a two-input table for analysis
Analyzing Data with PivotTables
Creating a PivotTable
Putting the finishing touches on a PivotTable
Book IV: PowerPoint 2013
Book IV: Chapter 1: Getting Started in PowerPoint
Getting Acquainted with PowerPoint
A Brief Geography Lesson
A Whirlwind Tour of PowerPoint
Creating a New Presentation
Advice for Building Persuasive Presentations
Creating New Slides for Your Presentation
Inserting a new slide
Speed techniques for inserting slides
Conjuring slides from Word document headings
Selecting a different layout for a slide
Getting a Better View of Your Work
Changing views
Looking at the different views
Hiding and Displaying the Slides Pane and Notes Pane
Selecting, Moving, and Deleting Slides
Selecting slides
Moving slides
Deleting slides
Putting Together a Photo Album
Creating your photo album
Putting on the final touches
Editing a photo album
Hidden Slides for All Contingencies
Hiding a slide
Showing a hidden slide during a presentation
Book IV: Chapter 2: Fashioning a Look for Your Presentation
Looking at Themes and Slide Backgrounds
Choosing a Theme for Your Presentation
Creating Slide Backgrounds on Your Own
Using a solid (or transparent) color for the slide background
Creating a gradient color blend for slide backgrounds
Placing a picture in the slide background
Using a photo of your own for a slide background
Using a texture for a slide background
Changing the Background of a Single or Handful of Slides
Choosing the Slide Size
Using Master Slides and Master Styles for a Consistent Design
Switching to Slide Master view
Understanding master slides and master styles
Editing a master slide
Changing a master slide layout
Book IV: Chapter 3: Entering the Text
Entering Text
Choosing fonts for text
Changing the font size of text
Changing the look of text
Fun with Text Boxes and Text Box Shapes
Controlling How Text Fits in Text Frames and Text Boxes
Choosing how PowerPoint “AutoFits” text in text frames
Choosing how PowerPoint “AutoFits” text in text boxes
Positioning Text in Frames and Text Boxes
Handling Bulleted and Numbered Lists
Creating a standard bulleted or numbered list
Choosing a different bullet character, size, and color
Choosing a different list-numbering style, size, and color
Putting Footers (and Headers) on Slides
Some background on footers and headers
Putting a standard footer on all your slides
Creating a nonstandard footer
Removing a footer from a single slide
Book IV: Chapter 4: Making Your Presentations Livelier
Suggestions for Enlivening Your Presentation
Presenting Information in a Table
Exploring Transitions and Animations
Showing transitions between slides
Animating parts of a slide
Making Audio Part of Your Presentation
Inserting an audio file on a slide
Telling PowerPoint when and how to play an audio file
Playing audio during a presentation
Playing Video on Slides
Inserting a video on a slide
Fine-tuning a video presentation
Experimenting with the look of the video
Recording a Voice Narration for Slides
Book IV: Chapter 5: Delivering a Presentation
All about Notes
Rehearsing and Timing Your Presentation
Showing Your Presentation
Starting and ending a presentation
Going from slide to slide
Tricks for Making Presentations a Little Livelier
Wielding a pen or highlighter in a presentation
Blanking the screen
Zooming In
Delivering a Presentation When You Can’t Be There in Person
Providing handouts for your audience
Creating a self-running, kiosk-style presentation
Creating a user-run presentation
Presenting a Presentation Online
Packaging your presentation on a CD
Creating a presentation video
Book V: OneNote 2013
Book V: Chapter 1: Up and Running with OneNote
Introducing OneNote
Finding Your Way around the OneNote Screen
Notebook pane
Section (and section group) tabs
Page window
Page pane
Units for Organizing Notes
Creating a Notebook
Creating Sections and Section Groups
Creating a new section
Creating a section group
Creating Pages and Subpages
Creating a new page
Creating a new subpage
Renaming and Deleting Groups and Pages
Getting from Place to Place in OneNote
Changing Your View of OneNote
Book V: Chapter 2: Taking Notes
Entering a Typewritten Note
Notes: The Basics
Moving and resizing note containers
Formatting the Text in Notes
Selecting notes
Deleting notes
Getting more space for notes on a page
Drawing on the Page
Drawing with a pen or highlighter
Drawing a shape
Changing the size and appearance of drawings and shapes
Converting a Handwritten Note to Text
Writing a Math Expression in a Note
Taking a Screen-Clipping Note
Recording and Playing Audio Notes
Recording an audio note
Playing an audio note
Attaching, Copying, and Linking Files to Notes
Attaching an Office file to a note
Copying an Office file into OneNote
Linking a Word or PowerPoint file to OneNote
Copying a note into another Office program
Book V: Chapter 3: Finding and Organizing Your Notes
Finding a Stray Note
Searching by word or phrase
Searching by author
Tagging Notes for Follow Up
Tagging a note
Arranging tagged notes in the task pane
Creating and modifying tags
Color-Coding Notebooks, Sections, and Pages
Merging and Moving Sections, Pages, and Notes
Book VI: Working with Charts and Graphics
Book VI: Chapter 1: Creating a Chart
The Basics: Creating a Chart
Choosing the Right Chart
Area charts
Bar charts
Column charts
Combo charts
Line charts
Pie charts
Radar charts
Stock charts
Surface charts
XY (scatter) charts
Providing the Raw Data for Your Chart
Positioning Your Chart in a Workbook, Page, or Slide
Changing a Chart’s Appearance
Changing the chart type
Changing the size and shape of a chart
Choosing a new look for your chart
Changing the layout of a chart
Handling the gridlines
Changing a chart element’s color, font, or other particular
Saving a Chart as a Template So That You Can Use It Again
Saving a chart as a template
Creating a chart from a template
Chart Tricks for the Daring and Heroic
Decorating a chart with a picture
Annotating a chart
Displaying the raw data alongside the chart
Placing a trendline on a chart
Troubleshooting a Chart
Book VI: Chapter 2: Making a SmartArt Diagram
The Basics: Creating SmartArt Diagrams
Choosing a diagram
Making the diagram your own
Creating the Initial Diagram
Creating a diagram
Swapping one diagram for another
Changing the Size and Position of a Diagram
Laying Out the Diagram Shapes
Selecting a diagram shape
Removing a shape from a diagram
Moving diagram shapes to different positions
Adding shapes to diagrams apart from hierarchy diagrams
Adding shapes to hierarchy diagrams
Adding shapes to Organization charts
Promoting and demoting shapes in hierarchy diagrams
Handling the Text on Diagram Shapes
Entering text on a diagram shape
Entering bulleted lists on diagram shapes
Changing a Diagram’s Direction
Choosing a Look for Your Diagram
Changing the Appearance of Diagram Shapes
Changing the size of a diagram shape
Exchanging one shape for another
Changing a shape’s color, fill, or outline
Changing fonts and font sizes on shapes
Creating a Diagram from Scratch
Book VI: Chapter 3: Handling Graphics, Photos, and Clip Art
All about Picture File Formats
Bitmap and vector graphics
Resolution
Compression
Color depth
Choosing file formats for graphics
Inserting a Picture in an Office File
Inserting a picture of your own
Obtaining a picture online
Touching Up a Picture
Softening and sharpening pictures
Correcting a picture’s brightness and contrast
Recoloring a picture
Choosing an artistic effect
Selecting a picture style
Cropping off part of a picture
Removing the background
Compressing Pictures to Save Disk Space
Book VI: Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects
The Basics: Drawing Lines, Arrows, and Shapes
Handling Lines, Arrows, and Connectors
Changing the length and position of a line or arrow
Changing the appearance of a line, arrow, or connector
Attaching and handling arrowheads on lines and connectors
Connecting shapes by using connectors
Handling Rectangles, Ovals, Stars, and Other Shapes
Drawing a shape
Changing a shape’s symmetry
Using a shape as a text box
WordArt for Embellishing Letters and Words
Creating WordArt
Editing WordArt
Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects
Selecting objects so that you can manipulate them
Hiding and displaying the rulers and grid
Changing an Object’s Size and Shape
Changing an Object’s Color, Outline Color, and Transparency
Filling an object with color, a picture, or a texture
Making a color transparent
Putting the outline around an object
Moving and Positioning Objects
Tricks for aligning and distributing objects
When objects overlap: Choosing which appears above the other
Rotating and flipping objects
Grouping objects to make working with them easier
Book VII: Office 2013 — One Step Beyond
Book VII: Chapter 1: Customizing an Office Program
Customizing the Ribbon
Displaying and selecting tab, group, and command names
Moving tabs and groups on the Ribbon
Adding, removing, and renaming tabs, groups, and commands
Creating new tabs and groups
Resetting your Ribbon customizations
Customizing the Quick Access Toolbar
Adding buttons to the Quick Access toolbar
Changing the order of buttons on the Quick Access toolbar
Removing buttons from the Quick Access toolbar
Placing the Quick Access toolbar above or below the Ribbon
Customizing the Status Bar
Changing the Screen Background
Customizing Keyboard Shortcuts in Word
Book VII: Chapter 2: Ways of Distributing Your Work
Printing — The Old Standby
Distributing a File in PDF Format
About PDF files
Saving an Office file as a PDF
Saving an Office File as a Web Page
Choosing how to save the component parts
Turning a file into a web page
Opening a web page in your browser
Blogging from inside Word
Describing a blog account to Word
Posting an entry to your blog
Taking advantage of the Blog Post tab
Book VII: Chapter 3: Automating Tasks with Macros
What Is a Macro?
Displaying the Developer Tab
Managing the Macro Security Problem
Recording a Macro
Enabling your files for macros
Ground rules for recording macros
Recording the macro
Running a Macro
Editing a Macro
Opening a macro in the Visual Basic Editor
Reading a macro in the Code window
Editing the text that a macro enters
Deleting parts of a macro
Running a Macro from a Button on the Quick Access Toolbar
Book VII: Chapter 4: Linking and Embedding in Compound Files
What Is OLE, Anyway?
Linking and embedding
Uses for object linking
Uses for object embedding
Pitfalls of object linking and embedding
Embedding Data from Other Programs
Embedding foreign data
Editing an embedded object
Linking to a Source File
Establishing the link
Updating a link
Editing data in the source file
Converting a linked object to an embedded object
Book VIII: File Sharing and Collaborating
Book VIII: Chapter 1: Preparing to Use the Office Web Apps
Introducing the Office Web Apps
Storing and Sharing Files on the Internet
Office Web Apps: The Big Picture
Creating a Microsoft Account
Signing In and Out of Your Microsoft Account
Navigating in a Microsoft Account
Managing Your Folders
Creating a folder
Viewing and locating folders in the SkyDrive window
Going from folder to folder in SkyDrive
Deleting, moving, and renaming folders
Book VIII: Chapter 2: Using the Office Web Apps
Creating an Office File in SkyDrive
Uploading Office Files to a Folder on SkyDrive
Saving a File from Office 2013 to SkyDrive
Opening Office Files Stored on SkyDrive
Opening a file in an Office Web App
Opening a file in an Office 2013 application
Downloading Files from SkyDrive to Your Computer
Managing Your Files on SkyDrive
Book VIII: Chapter 3: Sharing and Collaborating
Sharing Files: The Big Picture
File access privileges
Links for sharing files
Sharing Your Files and Folders with Others
Seeing Files and Folders Others Have Shared with You
Investigating and Changing How Files and Folders Are Shared
Co-editing Shared Files on SkyDrive
Soliciting Information with a Survey Form
Office Home & Student 2013 All-in-One For Dummies®
Published by
John Wiley & Sons, Inc.
111 River Street
Hoboken, NJ 07030-5774
www.wiley.com
Copyright © 2013 by John Wiley & Sons, Inc., Hoboken, New Jersey
Published simultaneously in Canada
No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions.
Trademarks: Wiley, the Wiley logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything Easier, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates in the United States and other countries, and may not be used without written permission. Microsoft is a registered trademark of Microsoft Corporation. All other trademarks are the property of their respective owners. John Wiley & Sons, Inc. is not associated with any product or vendor mentioned in this book.
Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with respect to the accuracy or completeness of the contents of this work and specifically disclaim all warranties, including without limitation warranties of fitness for a particular purpose. No warranty may be created or extended by sales or promotional materials. The advice and strategies contained herein may not be suitable for every situation. This work is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional services. If professional assistance is required, the services of a competent professional person should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Website is referred to in this work as a citation and/or a potential source of further information does not mean that the author or the publisher endorses the information the organization or Website may provide or recommendations it may make. Further, readers should be aware that Internet Websites listed in this work may have changed or disappeared between when this work was written and when it is read.
For general information on our other products and services, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002.
For technical support, please visit www.wiley.com/techsupport.
Wiley publishes in a variety of print and electronic formats and by print-on-demand. Some material included with standard print versions of this book may not be included in e-books or in print-on-demand. If this book refers to media such as a CD or DVD that is not included in the version you purchased, you may download this material at http://booksupport.wiley.com. For more information about Wiley products, visit www.wiley.com.
Library of Congress Control Number: 2013934765
ISBN 978-1-118-51637-9 (pbk); ISBN 978-1-118-55030-4 (ebk); ISBN 978-1-118-855023-6 (ebk); ISBN 978-1-118-55019-9 (ebk)
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
About the Author
Peter Weverka is the best-selling author of many For Dummies books, including Office 2013 All-in-One For Dummies, as well as 45 other computer books about various topics. Peter’s humorous articles and stories — none related to computers, thankfully — have appeared in Harper’s, SPY, and other magazines for grown-ups.
Dedication
For Marie Arnoux.
Author’s Acknowledgments
This book owes a lot to many hard-working people at the offices of John Wiley & Sons, Inc. in Indiana. I would like to thank Steve Hayes for his encouragement and for giving me the opportunity to write this book.
I would also like to thank Susan Christophersen, who has edited many of my books, this one included, and is always a pleasure to work with.
Technical Editor Michelle Krazniak made sure that all the explanations in this book are indeed accurate, and I would like to thank her for her diligence and suggestions for improving this book. I would also like to thank BIM Indexing and Proofreading Services for writing the index.
If you turn this page you will see, on the flip side, the names of all the people who worked on this book. I am grateful to all of them.
Finally, thanks to my family — Sofia, Henry, and Addie — for indulging me during the writing of this book.
Authors’ Acknowledgments
We’re proud of this book; please send us your comments at http://dummies.custhelp.com. For other comments, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002.
Some of the people who helped bring this book to market include the following:
Acquisitions and Editorial
Project and Copy Editor: Susan Christophersen
Executive Editor: Steve Hayes
Technical Editor: Michelle Krazniak
Editorial Manager: Jodi Jensen
Editorial Assistant: Annie Sullivan
Sr. Editorial Assistant: Cherie Case
Cover Photo: © Silvia Jansen / iStockphoto.com
Composition Services
Project Coordinator: Sheree Montgomery
Layout and Graphics: Carl Byers, Carrie A. Cesavice, Joyce Haughey
Proofreaders: Jessica Kramer, Tricia Liebig
Indexer: BIM Indexing & Proofreading Services
Publishing and Editorial for Technology Dummies
Richard Swadley, Vice President and Executive Group Publisher
Andy Cummings, Vice President and Publisher
Mary Bednarek, Executive Acquisitions Director
Mary C. Corder, Editorial Director
Publishing for Consumer Dummies
Kathleen Nebenhaus, Vice President and Executive Publisher
Composition Services
Debbie Stailey, Director of Composition Services
Introduction
This book is for users of Microsoft Office Home & Student 2013 who want to get to the heart of Office without wasting time. Don’t look in this book to find out how the different applications in the Office suite work. Look in this book to find out how you can get your work done better and faster with these applications.
I show you everything you need to make the most of each of the Office applications. On the way, you have a laugh or two. No matter how much or how little skill you bring to the table, this book will make you a better, more proficient, more confident user of the Office Home & Student 2013 applications.
What’s in This Book, Anyway?
This book, comprising eight mini-books, is your guide to making the most of the Office applications. It’s jam-packed with how-to’s, advice, shortcuts, and tips. Here’s a bare outline of the ten mini-books of this book:
Book I: Common Office Tasks: Looks into the many commands and features that are common to all or several of the Office Home & Student programs. Master the material in Book I and you will be well on your way to mastering all the programs. Book I explains handling text, the proofing tools, and speed techniques that can make you more productive in most of the Office applications.
Book II: Word 2013: Explains the numerous features in Office’s word processor, including how to create documents from letters to reports. Use the techniques described here to construct tables, manage styles, turn Word into a desktop-publishing program, and quickly dispatch office tasks such as mass-mailings. You also discover how to get Word’s help in writing indexes, bibliographies, and other items of interest to scholars and report writers.
Book III: Excel 2013: Shows the many different ways to crunch the numbers with the bean counter in the Office suite. Along the way, you find out how to design worksheets that are easy to read and understand, use data-validation rules to cut down on entry mistakes, write meaningful formulas, and analyze your data with PivotTables and the goal analysis tools. You find out just how useful Excel can be for financial analyses, data tracking, and forecasting.
Book IV: PowerPoint 2013: Demonstrates how to construct a meaningful presentation that makes the audience say “Wow!” Included in Book IV are instructions for making a presentation livelier and more original, both when you create your presentation and when you deliver it.
Book V: OneNote 2013: Covers how to write, store, and organize notes in the Office 2013 note-taking application. You find out how to record video and audio notes, link notes to files and web pages, find stray notes, and make OneNote a way to organize your thoughts and ideas.
Book VI: Working with Charts and Graphics: Explains how to present information in charts and diagrams, and how to use photos and clip art in your Word documents, PowerPoint presentations, and Excel spreadsheets. You also discover how to create lines, shapes, and text boxes to illustrate your ideas.
Book VII: Office 2013 — One Step Beyond: For people who want to take full advantage of Office, Book VII delves into customizing the Office 2013 applications. It also looks into alternative ways to distribute your work — in a blog or a web page, for example. You also find out how to record and play macros, and how object linking and embedding can help streamline your work.
Book VIII: File Sharing and Collaborating: Explores how to use the Office Web Apps, the online versions of the Office software, to share files with co-workers and collaborate online. You find out how to manage folders on SkyDrive, the Microsoft service for storing and sharing files.
What Makes This Book Different
You are holding in your hands a computer book designed to make learning the Office 2013 applications as easy and comfortable as possible. Besides the fact that this book is easy to read, it’s different from other books about Office. Read on to see why.
Easy-to-look-up information
This book is a reference, which means that readers have to be able to find instructions quickly. To that end, I have taken great pains to make sure that the material in this book is well organized and easy to find. The descriptive headings help you find information quickly. The bulleted and numbered lists make following instructions simpler. The tables make options easier to understand and compare.
I want you to be able to look down the page and see a heading or list with the name of the topic that concerns you. I want you to be able to find instructions quickly. Compare the table of contents in this book to the book next to it on the bookstore shelf. The table of contents in this book is put together better and presents topics so that you can find them in a hurry.
A task-oriented approach
Most computer books describe what the software is, but this book explains how to complete tasks with the software. I assume that you came to this book because you want to know how to do something — print form letters, create a worksheet, or query a database. You came to the right place. This book describes how to get tasks done.
Meaningful screen shots
The screen shots in this book show only the part of the screen that illustrates what is being explained in the text. When instructions refer to one part of the screen, only that part of the screen is shown. I took great care to make sure that the screen shots in this book serve to help you understand the Office 2013 programs and how they work. Compare this book to the one next to it on the bookstore shelf. Do you see how clean the screenshots in this book are?
Foolish Assumptions
Please forgive me, but I made one or two foolish assumptions about you, the reader of this book. I assumed the following:
You own a copy of Office Home & Student 2013 and have installed it on your computer.
You use a Windows operating system. All people who have the Windows operating system installed on their computers are invited to read this book. It serves people who have Windows 8, Windows 7, and Windows Vista.
You are kind to foreign tourists and small animals.
Conventions Used in This Book
I want you to understand all the instructions in this book, and in that spirit, I’ve adopted a few conventions.
Where you see boldface letters or numbers in this book, it means to type the letters or numbers. For example, “Enter 25 in the Percentage text box” means to do exactly that: Enter the number 25.
Sometimes two tabs on the Ribbon have the same name. To distinguish tabs with the same name from one another, I sometimes include one tab’s “Tools” heading in parentheses if there could be confusion about which tab I’m referring to. In PowerPoint, for example, when you see the words “(Table Tools) Design tab,” I’m referring to the Design tab for creating tables, not the Design tab for changing a slide’s appearance. (Book I, Chapter 1 describes the Ribbon and the tabs in detail.)
To show you how to step through command sequences, I use the ⇒ symbol. For example, on the Insert tab in Word, you can click the Page Number button and choose Top of Page⇒Simple to number pages. The ⇒ symbol just creates a shorthand method of saying “Choose Top of Page and then choose Simple.”
To give most commands, you can press combinations of keys. For example, pressing Ctrl+S saves the file you’re working on. In other words, you can hold down the Ctrl key and press the S key to save a file. Where you see Ctrl+, Alt+, or Shift+ and a key name or key names, press the keys simultaneously.
Yet another way to give a command is to click a button. When I tell you to click a button, you see a small illustration of the button in the margin of this book (unless the button is too large to fit in the margin). The button shown here is the Save button, the one you can click to save a file.
Icons Used in This Book
To help you get the most out of this book, I’ve placed icons here and there. Here’s what the icons mean:
Next to the Tip icon, you can find shortcuts and tricks of the trade to make your visit to Officeland more enjoyable.
Where you see the Warning icon, tread softly and carefully. It means that you are about to do something that you may regret later.
When I explain a juicy little fact that bears remembering, I mark it with a Remember icon. When you see this icon, prick up your ears. You will discover something that you need to remember throughout your adventures with Word, Excel, PowerPoint, or the other Office application I am demystifying.
When I am forced to describe high-tech stuff, a Technical Stuff icon appears in the margin. You don’t have to read what’s beside the Technical Stuff icons if you don’t want to, although these technical descriptions often help you understand how a software feature works.
Book I
Common Office Tasks
Visit www.dummies.com for great Dummies content online.
Contents at a Glance
Chapter 1: Office Nuts and Bolts
Chapter 2: Wrestling with the Text
Chapter 3: Speed Techniques Worth Knowing About