Contents
Part I: Common Office Features
Chapter 1: Welcome to Microsoft Office 2013
Learning about Office Applications
Taking Advantage of Other Office Applications
Chapter 2: Navigating in Office
Your Interface to Faster File Creation
Using an Application Start Screen
Touring an Office Application Screen
Controlling the Ribbon Display
Chapter 3: Mastering Fundamental Operations
Moving and Copying Information
AutoCorrect, AutoFormat, and Actions
Part II: Creating Documents with Word 2013
Chapter 4: Diving Into Document Creation
Creating a File from a Template
Compatibility with Previous Versions of Word
Navigation and Selection Tips and Tricks
Choosing the Right Word View for the Task at Hand
Chapter 5: Font/Character Formatting
Reviewing the Ways You Can Format Text in Word
Formatting Characters Directly or with Styles
Chapter 6: Paragraph Formatting
Choosing between Styles and Paragraph Formatting
Finding Paragraph Formatting Tools
Structuring Text with Paragraph Formatting
Setting Off Text with Paragraph Decoration
Chapter 7: Using Styles to Create a Great Looking Document
Using the Styles Group to Apply Styles
Changing the Whole Document via Style Sets
Chapter 8: Controlling Document Appearance with Sections and More
Header and Footer Navigation and Design
Adding Header and Footer Material
Changing the Number of Columns
Adding and Removing Page Borders
Working More Effectively with Themes
Chapter 9: Adding Tables and Graphics to a Document
Getting a Quick Start with Quick Tables
Working with Table Layout and Design
Inserting a Picture from a File
Manipulating Inserted Pictures (and Other Graphics)
Arranging Pictures and Other Objects
Chapter 10: Data Documents and Mail Merge
Previewing the Mail Merge Process
Choosing the Data Document Type
Chapter 11: Managing Document Security, Comments, and Tracked Changes
Accepting and Rejecting Changes
Combining Collaborative Documents
Combining Documents That Contain Tracked Changes
Part III: Making the Numbers Work with Excel 2013
Chapter 12: Using Excel Worksheets and Workbooks
Identifying What Excel Is Good For
Seeing What’s New in Excel 2013
Understanding Workbooks and Worksheets
Introducing Excel’s Ribbon Tabs
Creating Your First Excel Workbook
Chapter 13: Entering and Editing Worksheet Data
Entering Text and Values into Your Worksheets
Entering Dates and Times into Your Worksheets
Chapter 14: Essential Worksheet and Cell Range Operations
Learning the Fundamentals of Excel Worksheets
Controlling the Worksheet View
Understanding Cells and Ranges
Using Names to Work with Ranges
Chapter 15: Introducing Formulas and Functions
Entering Formulas into Your Worksheets
Using Cell References in Formulas
Correcting Common Formula Errors
Tips for Working with Formulas
Chapter 16: Working with Dates and Times
How Excel Handles Dates and Times
Date-Related Worksheet Functions
Chapter 17: Creating Formulas That Count and Sum
Counting and Summing Worksheet Cells
Conditional Sums Using a Single Criterion
Conditional Sums Using Multiple Criteria
Chapter 18: Getting Started Making Charts
Understanding How Excel Handles Charts
Hands On: Creating and Customizing a Chart
Chapter 19: Communicating Data Visually
Conditional Formats That Use Graphics
Working with Conditional Formats
Displaying a Sparkline for a Dynamic Range
Part IV: Persuading and Informing with PowerPoint 2013
Chapter 20: A First Look at PowerPoint 2013
What’s New in PowerPoint 2013?
Starting and Exiting PowerPoint
Enabling Optional Display Elements
Opening a New Display Window for the Same Presentation
Chapter 21: Creating a Presentation, Slides, and Text
Setting Passwords for File Access
Closing and Reopening Presentations
Inserting Content from External Sources
Chapter 22: Working with Layouts, Themes, and Masters
Understanding Layouts and Themes
Changing Colors, Fonts, and Effects
Customizing and Creating Layouts
Chapter 23: Working with Tables and Charts
Selecting Rows, Columns, and Cells
Chart Types and Chart Layout Presets
Chapter 24: Using SmartArt Diagrams, Clip Art, and Pictures
Understanding SmartArt Types and Their Uses
Modifying a Hierarchy Graphic Structure
Saving a SmartArt Graphic as a Picture
Adjusting and Correcting Photos
Chapter 25: Building Animation Effects, Transitions, and Support Materials
Understanding Animation and Transitions
Assigning Transitions to Slides
Chapter 26: Delivering a Live Presentation
Using the On-Screen Show Controls
Giving a Presentation on a Different Computer
Working with Audio-Visual Equipment
Part V: Organizing Messages, Contacts, and Time with Outlook
Chapter 27: Fundamentals of E-mail
Setting Up Your E-mail Accounts
Composing and Sending Messages
Reading and Replying to Messages
Understanding the Inbox Display
Understanding Files and Folders
Deleting Items and Using the Deleted Items Folder
Setting Options for an Individual E-mail Message
Chapter 28: Processing and Securing E-mail
Understanding Junk E-mail Filtering
Blocking and Allowing Specific Addresses
Understanding E-mail Rule Basics
Using Certificates and Digital Signatures
Chapter 29: Working with Contacts
Understanding Outlook Contacts (People)
Sending an E-mail to a Contact or Group
Performing a Mail Merge from Your Contacts
Chapter 30: Working with Appointments and Tasks
Understanding the Outlook Calendar
Part VI: Designing Publications with Publisher
Chapter 31: Introducing Publisher
Using a Template to Create a Publication
Chapter 32: Designing Dazzling Publications with Publisher
Preparing for Outside Printing
Saving a Publication for Online Photo Center Printing
Part VII: Managing Information with Access and OneNote
Chapter 33: An Introduction to Database Development
The Database Terminology of Access
Chapter 34: Creating Access Tables
How to Create a Blank Desktop Database
Adding Records to a Database Table
Navigating Records in a Datasheet
Changing Values in a Datasheet
Understanding Attachment Fields
Chapter 35: Creating and Entering Data with Basic Access Forms
Chapter 36: Selecting Data with Queries
Adding Criteria to Your Queries
Creating and Working with Query Joins
Chapter 37: Presenting Data with Access Reports
Creating a Report, from Beginning to End
Chapter 38: Keeping Information at Hand with OneNote
Organizing, Finding, and Sharing
Working with Notes in the Cloud
Part VIII: Sharing and Collaborating in the Cloud and Applications
Chapter 39: Collaborating in the Cloud with SkyDrive
Understanding SkyDrive Pro and SkyDrive for Windows
Saving to the Cloud with SkyDrive
SkyDrive for Windows Application versus SkyDrive in Office
Accessing Your SkyDrive Pro Library on Office 365
Chapter 40: Integrating Office Application Information
Appendix A: Customizing Office
Appendix B: Optimizing Your Office Installation
Appendix C: International Support and Accessibility Features