Office 2013 for dummies

Introduction: Who should buy this book How this book is organized Part I: Getting Started with Office 2013 Part 2: Working With Word Part 3: Playing The Numbers With Excel Part 4: Making Presentations With PowerPoint Part 5: Getting Organized With Outlook Part 6: Storing Stuff In Access Part 7: Part Of Tens How to use this book: Conventions Icons used in this book Getting started Part I: Getting Started with Office 2013: Introducing Microsoft Office 2013: Starting an Office 2013 program Introducing the Microsoft Office Ribbon: File tab Using the Ribbon: Deciphering ribbon icons Identifying ribbon icons Displaying dialog boxes Minimizing the ribbon Using the Quick Access Toolbar: Using the Quick Access icons Adding icons Removing icons Moving the Quick access toolbar Customizing an Office 2013 Program: Changing the file format and default location Customizing the ribbon icons Exiting Office 2013 Selecting and Editing Data: Adding data by pointing Selecting data: Selecting data with the mouse Selecting data with the keyboard Selecting multiple chunks of data with the mouse and keyboard Editing text with the Pop-up Toolbar Deleting data Cutting and Pasting (moving) data Copying and Pasting Data Using Paste Options Dragging with the Mouse to Cut, Copy, and Paste Undo and Redo Sharing Data with Other Office 2013 Programs: Using the Office clipboard Viewing and pasting items off the Office Clipboard Deleting items from the Office Clipboard Modifying Pictures: Adding (and Deleting) pictures Manipulating pictures: Moving a picture Resizing a picture Rotating a picture Enhancing pictures Choosing visual effects Choosing a picture style Adding a border around a picture Getting Help from Office 2013: Browsing the Help Window Searching in the Help Window Making the Help Window easier to read: Resizing and pinning the Help window Enlarging the text in the Help window Printing the text in the Help window Part 2: Working With Word: Typing Text in Word: Moving the Cursor with the Mouse Moving the Cursor with the Keyboard Navigating through a document: Navigating with the mouse Using the Go To command Finding and Replacing Text: Using the Find command Customizing text searching Searching by headings Browsing through pages Using the Find and Replace command Checking your spelling Checking your grammar Viewing a document: Switching between views Using Read Mode view Using Outline view Formatting Text: Changing the Font Changing the Font Size Changing the Text Style Changing colors: Changing the color of text Highlighting text with color Using Text effects Justifying Text alignment Adjusting Line Spacing Making lists: Indenting list items Converting list items back into text Customizing a list Renumbering numbered lists Using the Ruler: Adjusting left and right paragraph margins Defining indentation with the Ruler Using Format Painter Using Styles Using Templates Removing Formatting from Text Designing Your Pages: Inserting new pages Adding (and Deleting) a Cover Page Inserting Page Breaks Inserting Headers and Footers: Creating a header (or footer) Defining which pages display a header (or footer) Deleting a header (or footer) Organizing text in Tables: Creating a table by highlighting rows and columns Creating a table with the Insert Table dialog box Creating a table with the mouse Creating a table from existing text Formatting and coloring a Table: Selecting all or part of a table Aligning text in a table cell Picking a table style Resizing columns and rows Sorting a Table Deleting Tables: Deleting an entire table Deleting rows and columns Deleting cells Deleting cell borders Making Text look artistic: Creating drop caps Creating WordArt Dividing Text into Columns: Editing columns Removing columns Previewing a document before Printing: Defining page size and orientation Using Print Preview Part 3: Playing The Numbers With Excel: Basics Of Spreadsheets: Numbers, Labels, And Formulas: Understanding Spreadsheets Storing stuff in a Spreadsheet: Typing data into a single cell Typing data in multiple cells Typing in sequences with AutoFill Formatting Numbers and Labels: Formatting numbers Formatting cells Navigating a Spreadsheet: Using the mouse to move around in a spreadsheet Using the keyboard to move around a spreadsheet Naming cells Searching a Spreadsheet: Searching for text Searching for formulas Editing a Spreadsheet: Editing data in a cell Changing the size of rows and columns with the mouse Typing the size of rows and columns Adding and deleting rows and columns Adding sheets Renaming sheets Rearranging sheets Deleting a sheet Clearing Data Printing Workbooks: Using Page Layout view Adding a header (or footer) Printing gridlines Defining a print area Inserting (and removing) page breaks Printing row and column headings Defining printing margins Defining paper orientation and size Printing in Excel Playing With Formulas: Creating a Formula: Organizing formulas with parentheses Copying formulas Using Functions: Using the AutoSum command Using recently used functions Editing a Formula Conditional Formatting: Comparing data values Creating conditional formatting rules Data Validation Goal seeking Creating multiple scenarios: Creating a scenario Viewing a scenario Editing a scenario Viewing a scenario summary Auditing Your Formulas: Finding where a formula gets its data Finding which formula(s) a cell can change Checking for errors

Charting And Analyzing Data:

Understanding the Parts of a Chart

Creating a Chart

Editing a Chart:

Moving a chart on a worksheet

Moving a chart to a new sheet

Resizing a chart

Using the Chart Tools:

Changing the chart type

Changing the data sources

Switching rows and columns

Changing the parts of a chart

Designing the layout of a chart

Deleting a chart

Using Sparklines:

Creating a Sparkline

Customizing a Sparkline

Deleting a Sparkline

Organizing Lists in Pivot Tables:

Creating a pivot table

Rearranging labels in a pivot table

Modifying a pivot table

Filtering a pivot table

Summing a pivot table

Slicing up a pivot table

Creating PivotCharts

Part 4: Making Presentations With PowerPoint:

Creating A PowerPoint Presentation:

Defining the purpose of your presentation

Creating a PowerPoint Presentation:

Designing a presentation with Slide view

Designing a presentation with Outline view

Working with Text:

Typing text in a text box

Formatting text

Aligning text

Adjusting line spacing

Making numbered and bulleted lists

Making columns

Moving and resizing a text box

Rotating a text box

Adding Color And Pictures To A Presentation:

Applying a Theme

Changing the background:

Choosing a solid color background

Choosing a gradient background

Choosing a picture background

Adding Graphics to a Slide:

Placing picture files on a slide

Placing clip art on a slide

Creating WordArt

Capturing screenshots

Resizing, moving, and deleting graphic images

Rotating graphics

Layering objects

Adding Movies to a Slide:

Searching for a video on the Internet

Searching for video on your computer

Trimming a video

Coloring a video

formatting the shape of a video

Adding sound to a Slide:

Adding an audio file off the Internet

Adding audio from a file

Recording audio

Showing Off A Presentation:

Spell-Checking your presentation

Organizing Slides in sections:

Adding a section

Expanding and collapsing a section

Deleting a section

Adding Visual transitions:

Adding slide transitions

Text and graphic transitions

Using the Animation Painter

Adding Hyperlinks:

Creating web page hyperlinks

Creating hyperlinks to external files

Running a program through a hyperlink

Viewing a Presentation:

Creating a custom slide show

Hiding a slide

Organizing with Slide Sorter view

Creating handouts

Part 5: Getting Organized With Outlook:

Managing E-Mail With Outlook:

Configuring E-Mail settings

Creating E-Mail:

Creating a new e-mail message

Replying to an e-mail message

Using a stored e-mail address to create a new e-mail message

Attaching Files to messages

Reading and organizing E-Mail:

Grouping message into categories

Changing the appearance of the Reading Pane

Retrieving a file attachment from a message

Deleting E-Mail messages

Calendars, Contacts, And Tasks:

Setting Appointments:

Making an appointment

Viewing appointments

Deleting an appointment

Storing names and addresses:

Adding a name

Viewing names

Searching names

Managing tasks:

Storing a task

Searching tasks

Viewing tasks

Part 6: Storing Stuff In Access:

Using A Database:

Understanding the basics of a Database

Designing a Database

Editing and modifying a Database:

Naming a field

Adding and deleting a field

Typing Data into a Database:

Using Datasheet view

Using Form view

Creating a form

Viewing and editing data in a form

Editing a form

Closing and saving a Database:

Closing a database

Exiting Access

Searching, Sorting, And Querying A Database:

Searching a Database:

Searching for a specific record

Filtering a database

Sorting a Database

Querying a Database:

Creating a simply query

Creating a crosstab query

Creating a query that finds duplicate field data

Creating an unmatched query

Viewing, renaming, closing, and deleting queries

Creating A Database Report:

Using the Report Wizard

Manipulating the Data in a Report:

Switching a report to Layout view

Counting records or values

Sorting a field

Filtering a field

Editing a Report:

Resizing fields

Deleting fields

Making Reports look pretty:

Applying themes

Creating conditional formatting

Deleting a Report

Part 7: Part Of Tens:

Ten Tips For Using Office 2013:

Saving Office 2013 files

Password-protecting your files

Guarding against macro viruses

Customize the Ribbon

Save to SkyDrive

When in doubt, right-click the mouse

Freezing Row and Column Headings in Excel

Displaying slides out of order in PowerPoint .

Reduce Spam in Outlook:

Setting up Outlook's junk e-mail filter

Creating a Safe Senders list

Creating a Blocked Senders list

Using Office Web and Windows RT

Almost Ten Ways To Make Office 2013 Easier To Use:

Build your own Apps for Office

Collaborating with the Review Tab

Using Word's References Tab

Using Excel's Data Tab

Saving and Sending Files

Encrypting a File

Checking File Compatibility

Ignoring the silly Office Ribbon

Index.