You are previewing Office 2013 Bible: The Comprehensive Tutorial Resource.
O'Reilly logo
Office 2013 Bible: The Comprehensive Tutorial Resource

Book Description

The best of the best from our Excel, Word, Access, and PowerPoint Bibles!

Learn the sought-after features of the core applications from the Office 2013 suite. This Office 2013 Bible features the best-of-the-best content from the Excel 2013 Bible, by "Mr. Spreadsheet" John Walkenbach; the Word 2013 Bible, by Office expert Lisa A. Bucki; the PowerPoint 2013 Bible, by MOS Master Instructor and PowerPoint expert Faithe Wempen; and the Access 2013 Bible from Microsoft Certified Application Developer Michael Alexander and Office and Access expert Dick Kusleika.

This major resource also covers Outlook, Publisher, OneNote, SkyDrive, and other important features in the Office 2013 suite. If you want to quickly and effectively use Office 2013, start in the experts' corner with this must-have book.

  • Gives you the best-of-the-best content on Office 2013 from the leading experts, authors, and contributors to our Excel, Word, PowerPoint, and Access Bibles

  • Includes content from John Walkenbach, aka "Mr. Spreadsheet"; Word and Office expert Lisa A. Bucki; MOS Master Instructor and PowerPoint expert Faithe Wempen; Microsoft Certified Application Developer Michael Alexander; and Office and Access expert Dick Kusleika

  • Takes you beyond creating simple text documents, spreadsheets, and presentations to help you use multiple Office applications at once to accomplish critical business tasks

  • Also covers Publisher, OneNote, SkyDrive, the Cloud, and other key features and topics for Office 2013

Get the best of four Office 2013 books in one with this power-packed reference!

Table of Contents

  1. Cover
  2. Contents
  3. Part I: Common Office Features
    1. Chapter 1: Welcome to Microsoft Office 2013
      1. Learning about Office Applications
      2. Taking Advantage of Other Office Applications
      3. Previewing New Features
      4. Starting an Application
      5. Closing an Application
      6. Finding Files
      7. Getting Help
      8. Summary
    2. Chapter 2: Navigating in Office
      1. The Office Look
      2. Your Interface to Faster File Creation
      3. Using an Application Start Screen
      4. Touring an Office Application Screen
      5. Exploring the File Tab
      6. Controlling the Ribbon Display
      7. Gestures and Touch Navigation
      8. Setting Application Options
      9. Working with Dialog Boxes
      10. Summary
    3. Chapter 3: Mastering Fundamental Operations
      1. Working with Files
      2. Printing a File
      3. Working with Multiple Windows
      4. Moving and Copying Information
      5. Undoing and Redoing Actions
      6. Finding and Replacing
      7. Using Go To
      8. Spell Checking
      9. AutoCorrect, AutoFormat, and Actions
      10. Styles and Live Preview
      11. Working with User Accounts
      12. Summary
  4. Part II: Creating Documents with Word 2013
    1. Chapter 4: Diving Into Document Creation
      1. Creating a Blank File
      2. Creating a File from a Template
      3. Opening an Existing File
      4. Saving and File Formats
      5. Compatibility with Previous Versions of Word
      6. Navigation and Selection Tips and Tricks
      7. Choosing the Right Word View for the Task at Hand
      8. Summary
    2. Chapter 5: Font/Character Formatting
      1. Reviewing the Ways You Can Format Text in Word
      2. Formatting Characters Directly or with Styles
      3. Applying Character Formatting
      4. Summary
    3. Chapter 6: Paragraph Formatting
      1. Choosing between Styles and Paragraph Formatting
      2. Finding Paragraph Formatting Tools
      3. Structuring Text with Paragraph Formatting
      4. Setting Off Text with Paragraph Decoration
      5. Summary
    4. Chapter 7: Using Styles to Create a Great Looking Document
      1. Using the Styles Group to Apply Styles
      2. Modifying and Creating Styles
      3. Changing the Whole Document via Style Sets
      4. Managing Styles
      5. Style Inspector
      6. Summary
    5. Chapter 8: Controlling Document Appearance with Sections and More
      1. Changing Basic Page Setup
      2. Section Formatting
      3. Headers and Footers Overview
      4. Header and Footer Navigation and Design
      5. Adding Header and Footer Material
      6. Changing the Number of Columns
      7. Adding and Removing Page Borders
      8. Working More Effectively with Themes
      9. Summary
    6. Chapter 9: Adding Tables and Graphics to a Document
      1. Getting a Quick Start with Quick Tables
      2. Table Basics
      3. Working with Table Layout and Design
      4. Adding a Shape
      5. Inserting a Picture from a File
      6. Adding an Online Picture
      7. Pasting or Snapping a Picture
      8. Manipulating Inserted Pictures (and Other Graphics)
      9. Creating WordArt
      10. Inserting SmartArt
      11. Arranging Pictures and Other Objects
      12. Using the Selection Pane
      13. Summary
    7. Chapter 10: Data Documents and Mail Merge
      1. Previewing the Mail Merge Process
      2. Data Considerations
      3. Reviewing Data File Formats
      4. Choosing the Data Document Type
      5. Attaching a Data Source
      6. Assembling a Merge Document
      7. Mail Merge Pane/Wizard
      8. Summary
    8. Chapter 11: Managing Document Security, Comments, and Tracked Changes
      1. Protection Types
      2. Comments and Tracked Changes
      3. Accepting and Rejecting Changes
      4. Combining Collaborative Documents
      5. Comparing Documents
      6. Combining Documents That Contain Tracked Changes
      7. Summary
  5. Part III: Making the Numbers Work with Excel 2013
    1. Chapter 12: Using Excel Worksheets and Workbooks
      1. Identifying What Excel Is Good For
      2. Seeing What’s New in Excel 2013
      3. Understanding Workbooks and Worksheets
      4. Moving around a Worksheet
      5. Introducing Excel’s Ribbon Tabs
      6. Creating Your First Excel Workbook
      7. Summary
    2. Chapter 13: Entering and Editing Worksheet Data
      1. Exploring Data Types
      2. Entering Text and Values into Your Worksheets
      3. Entering Dates and Times into Your Worksheets
      4. Modifying Cell Contents
      5. Applying Number Formatting
      6. Summary
    3. Chapter 14: Essential Worksheet and Cell Range Operations
      1. Learning the Fundamentals of Excel Worksheets
      2. Controlling the Worksheet View
      3. Working with Rows and Columns
      4. Understanding Cells and Ranges
      5. Copying or Moving Ranges
      6. Using Names to Work with Ranges
      7. Adding Comments to Cells
      8. Summary
    4. Chapter 15: Introducing Formulas and Functions
      1. Understanding Formula Basics
      2. Entering Formulas into Your Worksheets
      3. Editing Formulas
      4. Using Cell References in Formulas
      5. Using Formulas in Tables
      6. Correcting Common Formula Errors
      7. Tips for Working with Formulas
      8. Summary
    5. Chapter 16: Working with Dates and Times
      1. How Excel Handles Dates and Times
      2. Date-Related Worksheet Functions
      3. Time-Related Functions
      4. Summary
    6. Chapter 17: Creating Formulas That Count and Sum
      1. Counting and Summing Worksheet Cells
      2. Basic Counting Formulas
      3. Advanced Counting Formulas
      4. Summing Formulas
      5. Conditional Sums Using a Single Criterion
      6. Conditional Sums Using Multiple Criteria
      7. Summary
    7. Chapter 18: Getting Started Making Charts
      1. What Is a Chart?
      2. Understanding How Excel Handles Charts
      3. Creating a Chart
      4. Hands On: Creating and Customizing a Chart
      5. Working with Charts
      6. Understanding Chart Types
      7. Summary
    8. Chapter 19: Communicating Data Visually
      1. Creating a Table
      2. Changing the Look of a Table
      3. Working with Tables
      4. About Conditional Formatting
      5. Conditional Formats That Use Graphics
      6. Working with Conditional Formats
      7. Introducing Sparklines
      8. Sparkline Types
      9. Creating Sparklines
      10. Customizing Sparklines
      11. Auto-Updating Sparklines
      12. Displaying a Sparkline for a Dynamic Range
      13. Summary
  6. Part IV: Persuading and Informing with PowerPoint 2013
    1. Chapter 20: A First Look at PowerPoint 2013
      1. Who Uses PowerPoint and Why?
      2. What’s New in PowerPoint 2013?
      3. Starting and Exiting PowerPoint
      4. Changing the View
      5. Zooming In and Out
      6. Enabling Optional Display Elements
      7. Opening a New Display Window for the Same Presentation
      8. Summary
    2. Chapter 21: Creating a Presentation, Slides, and Text
      1. Starting a New Presentation
      2. Saving Your Work
      3. Setting Passwords for File Access
      4. Closing and Reopening Presentations
      5. Setting File Properties
      6. Creating New Slides
      7. Inserting Content from External Sources
      8. Managing Slides
      9. Using Content Placeholders
      10. Creating Text Boxes Manually
      11. Working with Text Boxes
      12. Summary
    3. Chapter 22: Working with Layouts, Themes, and Masters
      1. Understanding Layouts and Themes
      2. Changing a Slide’s Layout
      3. Applying a Theme
      4. Managing Themes
      5. Changing Colors, Fonts, and Effects
      6. Changing the Background
      7. Working with Placeholders
      8. Customizing and Creating Layouts
      9. Managing Slide Masters
      10. Summary
    4. Chapter 23: Working with Tables and Charts
      1. Creating a New Table
      2. Moving around in a Table
      3. Selecting Rows, Columns, and Cells
      4. Editing a Table’s Structure
      5. Applying Table Styles
      6. Formatting Table Cells
      7. Understanding Charts
      8. Starting a New Chart
      9. Working with Chart Data
      10. Chart Types and Chart Layout Presets
      11. Working with Chart Elements
      12. Controlling the Axes
      13. Formatting a Chart
      14. Rotating a 3-D Chart
      15. Summary
    5. Chapter 24: Using SmartArt Diagrams, Clip Art, and Pictures
      1. Understanding SmartArt Types and Their Uses
      2. Inserting a SmartArt Graphic
      3. Editing SmartArt Text
      4. Modifying SmartArt Structure
      5. Modifying a Hierarchy Graphic Structure
      6. Formatting a SmartArt Graphic
      7. Saving a SmartArt Graphic as a Picture
      8. Choosing Appropriate Artwork
      9. Inserting Clip Art
      10. Understanding Raster Graphics
      11. Inserting Photos
      12. Sizing and Cropping Photos
      13. Adjusting and Correcting Photos
      14. Compressing Images
      15. Summary
    6. Chapter 25: Building Animation Effects, Transitions, and Support Materials
      1. Understanding Animation and Transitions
      2. Assigning Transitions to Slides
      3. Animating Slide Content
      4. The When and How of Handouts
      5. Creating Handouts
      6. Creating Speaker Notes
      7. Printing an Outline
      8. Printing Slides
      9. Summary
    7. Chapter 26: Delivering a Live Presentation
      1. Starting and Ending a Show
      2. Using the On-Screen Show Controls
      3. Using the On-Screen Pen
      4. Hiding Slides for Backup Use
      5. Using Custom Shows
      6. Giving a Presentation on a Different Computer
      7. Presenting an Online Show
      8. Working with Audio-Visual Equipment
      9. Summary
  7. Part V: Organizing Messages, Contacts, and Time with Outlook
    1. Chapter 27: Fundamentals of E-mail
      1. Setting Up Your E-mail Accounts
      2. Modifying Account Settings
      3. Using Outlook Profiles
      4. Composing and Sending Messages
      5. Reading and Replying to Messages
      6. Understanding the Inbox Display
      7. Understanding Files and Folders
      8. Outlook Data Files
      9. Working with Outlook Folders
      10. Deleting Items and Using the Deleted Items Folder
      11. Setting Options for an Individual E-mail Message
      12. Setting Global E-mail Options
      13. Summary
    2. Chapter 28: Processing and Securing E-mail
      1. Understanding Junk E-mail Filtering
      2. Setting Junk E-mail Options
      3. Blocking and Allowing Specific Addresses
      4. Understanding E-mail Rule Basics
      5. Creating a New Rule
      6. Some Rule Examples
      7. Managing Rules
      8. Protecting against Viruses
      9. Dealing with Attachments
      10. Macro Security
      11. Using Certificates and Digital Signatures
      12. HTML Message Dangers
      13. Summary
    3. Chapter 29: Working with Contacts
      1. Understanding Outlook Contacts (People)
      2. The Contacts Window
      3. Adding Contacts
      4. Sending an E-mail to a Contact or Group
      5. More about Contacts
      6. Performing a Mail Merge from Your Contacts
      7. Setting Contact Options
      8. Summary
    4. Chapter 30: Working with Appointments and Tasks
      1. Understanding the Outlook Calendar
      2. Using the Calendar
      3. Working with Appointments
      4. Searching the Calendar
      5. Setting Calendar Options
      6. Understanding Tasks
      7. Using the Tasks Feature
      8. Creating a New Task
      9. Working with Assigned Tasks
      10. Other Ways of Viewing Tasks
      11. Setting Task Options
      12. Summary
  8. Part VI: Designing Publications with Publisher
    1. Chapter 31: Introducing Publisher
      1. The Publisher Workspace
      2. Using a Template to Create a Publication
      3. Working with Text
      4. Working with Graphics
      5. Working with Tables
      6. Summary
    2. Chapter 32: Designing Dazzling Publications with Publisher
      1. Adding Special Effects
      2. Using Building Blocks
      3. Updating a Publication
      4. Fine-Tuning Objects
      5. Working with Pages
      6. Checking and Printing
      7. Preparing for Outside Printing
      8. Saving a Publication for Online Photo Center Printing
      9. Summary
  9. Part VII: Managing Information with Access and OneNote
    1. Chapter 33: An Introduction to Database Development
      1. The Database Terminology of Access
      2. Relational Databases
      3. Access Database Objects
      4. A Five-Step Design Method
      5. Summary
    2. Chapter 34: Creating Access Tables
      1. The Access Start Screen
      2. How to Create a Blank Desktop Database
      3. The Access 2013 Environment
      4. Creating an Example Table
      5. Setting the Primary Key
      6. Indexing Access Tables
      7. Printing a Table Design
      8. Saving the Completed Table
      9. Manipulating Tables
      10. Adding Records to a Database Table
      11. Navigating Records in a Datasheet
      12. Changing Values in a Datasheet
      13. Understanding Attachment Fields
      14. Summary
    3. Chapter 35: Creating and Entering Data with Basic Access Forms
      1. Formulating Forms1232
      2. Working with Controls
      3. Introducing Properties
      4. Using Form View
      5. Changing Values in a Form
      6. Printing a Form
      7. Summary
    4. Chapter 36: Selecting Data with Queries
      1. Introducing Queries
      2. Creating a Query
      3. Working with Query Fields
      4. Adding Criteria to Your Queries
      5. Printing a Query’s Recordset
      6. Saving a Query
      7. Creating Multi-Table Queries
      8. Working with the Table Pane
      9. Creating and Working with Query Joins
      10. Summary
    5. Chapter 37: Presenting Data with Access Reports
      1. Introducing Reports
      2. Creating a Report, from Beginning to End
      3. Summary
    6. Chapter 38: Keeping Information at Hand with OneNote
      1. Who Needs OneNote and Why
      2. Touring OneNote
      3. Creating a Notebook
      4. Creating a Section
      5. Creating a Page
      6. Inserting Notes
      7. Inserting an Outlook Task
      8. Inserting a Picture or File
      9. Inserting a Screen Clipping
      10. Writing on a Page
      11. Using Linked Note Taking
      12. Using Send To OneNote
      13. Organizing, Finding, and Sharing
      14. Working with Notes in the Cloud
      15. Summary
  10. Part VIII: Sharing and Collaborating in the Cloud and Applications
    1. Chapter 39: Collaborating in the Cloud with SkyDrive
      1. Understanding SkyDrive Pro and SkyDrive for Windows
      2. Saving to the Cloud with SkyDrive
      3. SkyDrive for Windows Application versus SkyDrive in Office
      4. Accessing Your SkyDrive Pro Library on Office 365
      5. Summary
    2. Chapter 40: Integrating Office Application Information
      1. Excel
      2. PowerPoint
      3. Outlook
      4. Access Imports and Exports
      5. OneNote
      6. Summary
  11. Appendix A: Customizing Office
  12. Appendix B: Optimizing Your Office Installation
  13. Appendix C: International Support and Accessibility Features
  14. Introduction