Table of Contents
Introduction
Who Should Buy This Book
How This Book Is Organized
Part I: Getting Started with Microsoft Office 2013
Part II: Working with Word
Part III: Playing the Numbers with Excel
Part IV: Making Presentations with PowerPoint
Part V: Getting Organized with Outlook
Part VI: Storing Stuff in Access
Part VII: The Part of Tens
How to Use This Book
Conventions
Icons Used in This Book
Getting Started
Part I: Getting Started with Microsoft Office 2013
Chapter 1: Introducing Microsoft Office 2013
Starting an Office 2013 Program
Introducing the Microsoft Office Ribbon
The 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
Chapter 2: 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
Chapter 3: 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
Chapter 4: 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 II: Working with Word
Chapter 5: 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
Chapter 6: 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
Chapter 7: 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 III: Playing the Numbers with Excel
Chapter 8: The 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
Chapter 9: 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
Chapter 10: 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 source
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 IV: Making Presentations with PowerPoint
Chapter 11: 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
Chapter 12: 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
Chapter 13: 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 V: Getting Organized with Outlook
Chapter 14: 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 messages into categories
Changing the appearance of the Reading Pane
Retrieving a file attachment from a message
Deleting E-Mail Messages
Chapter 15: 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 VI: Storing Stuff in Access
Chapter 16: 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
Defining the type and size of 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
Chapter 17: 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 simple query
Creating a crosstab query
Creating a query that finds duplicate field data
Creating an unmatched query
Viewing, renaming, closing, and deleting queries
Chapter 18: 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 VII: The Part of Tens
Chapter 19: 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
Chapter 20: 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
